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

Line 85: fnd_msg_pub.initialize;

81:
82: -- Initialize message list if p_init_msg_list is set to TRUE.
83: IF FND_API.to_Boolean( p_init_msg_list )
84: THEN
85: fnd_msg_pub.initialize;
86: END IF;
87:
88: -- Debug Message
89: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

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

85: fnd_msg_pub.initialize;
86: END IF;
87:
88: -- Debug Message
89: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
90: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
91: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || '. Roletype: ' || p_notify_type ||
92: '. Itemtype: ' || p_itemtype || '. p_assignemnt_status: ' || p_assignment_status);
93: fnd_msg_pub.Add;

Line 93: fnd_msg_pub.Add;

89: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
90: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
91: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || '. Roletype: ' || p_notify_type ||
92: '. Itemtype: ' || p_itemtype || '. p_assignemnt_status: ' || p_assignment_status);
93: fnd_msg_pub.Add;
94: END IF;
95:
96: x_return_status := FND_API.G_RET_STS_SUCCESS ;
97:

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

117: if l_role_list.count > 0 then
118:
119:
120: -- Debug Message
121: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
122: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
123: if l_exist_rolename is null then
124: fnd_message.Set_token('TEXT', 'Creating role: '||l_adhoc_role||' with members :--');
125: else

Line 128: fnd_msg_pub.Add;

124: fnd_message.Set_token('TEXT', 'Creating role: '||l_adhoc_role||' with members :--');
125: else
126: fnd_message.Set_token('TEXT', 'Adding to role: '||l_adhoc_role||' with members :--');
127: end if;
128: fnd_msg_pub.Add;
129: END IF;
130:
131: FOR i in 1 .. l_role_list.count
132: LOOP

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

132: LOOP
133:
134:
135:
136: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
137: fnd_message.Set_token('TEXT', l_role_list(i) );
138: fnd_msg_pub.Add;
139: END IF;
140:

Line 138: fnd_msg_pub.Add;

134:
135:
136: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
137: fnd_message.Set_token('TEXT', l_role_list(i) );
138: fnd_msg_pub.Add;
139: END IF;
140:
141: END LOOP;
142:

Line 159: fnd_msg_pub.ADD;

155:
156: else
157:
158: fnd_message.SET_NAME('PV', 'PV_EMPTY_ROLE');
159: fnd_msg_pub.ADD;
160:
161: raise FND_API.G_EXC_ERROR;
162:
163: end if;

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

166: COMMIT WORK;
167: END IF;
168:
169: -- Standard call to get message count and if count is 1, get message info.
170: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
171: p_count => x_msg_count,
172: p_data => x_msg_data);
173: EXCEPTION
174:

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

174:
175: WHEN FND_API.G_EXC_ERROR THEN
176:
177: x_return_status := FND_API.G_RET_STS_ERROR ;
178: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
179: p_count => x_msg_count,
180: p_data => x_msg_data);
181:
182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

181:
182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
183:
184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
185: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
186: p_count => x_msg_count,
187: p_data => x_msg_data);
188:
189: WHEN OTHERS THEN

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

188:
189: WHEN OTHERS THEN
190:
191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
192: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
193: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
194: p_count => x_msg_count,
195: p_data => x_msg_data);
196: end CreateRole;

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

189: WHEN OTHERS THEN
190:
191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
192: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
193: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
194: p_count => x_msg_count,
195: p_data => x_msg_data);
196: end CreateRole;
197:

Line 259: fnd_msg_pub.initialize;

255:
256: -- Initialize message list if p_init_msg_list is set to TRUE.
257: IF FND_API.to_Boolean( p_init_msg_list )
258: THEN
259: fnd_msg_pub.initialize;
260: END IF;
261:
262: -- Debug Message
263: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

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

259: fnd_msg_pub.initialize;
260: END IF;
261:
262: -- Debug Message
263: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
264: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
265: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || p_from_status || p_to_status);
266: fnd_msg_pub.Add;
267: END IF;

Line 266: fnd_msg_pub.Add;

262: -- Debug Message
263: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
264: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
265: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || p_from_status || p_to_status);
266: fnd_msg_pub.Add;
267: END IF;
268:
269: x_return_status := FND_API.G_RET_STS_SUCCESS ;
270:

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

270:
271: -- check the profile value and return if the value is not Y
272: l_email_enabled := nvl(fnd_profile.value('PV_EMAIL_NOTIFICATION_FLAG'), 'Y');
273:
274: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
275: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
276: fnd_message.Set_Token('TEXT', 'Email Notication is Enabled '||l_email_enabled);
277: fnd_msg_pub.Add;
278: END IF;

Line 277: fnd_msg_pub.Add;

273:
274: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
275: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
276: fnd_message.Set_Token('TEXT', 'Email Notication is Enabled '||l_email_enabled);
277: fnd_msg_pub.Add;
278: END IF;
279:
280: if (l_email_enabled <> 'Y') then
281: return;

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

279:
280: if (l_email_enabled <> 'Y') then
281: return;
282: else
283: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
284: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
285: fnd_message.Set_Token('TEXT', 'Email Notication is Enabled ');
286: fnd_msg_pub.Add;
287: END IF;

Line 286: fnd_msg_pub.Add;

282: else
283: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
284: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
285: fnd_message.Set_Token('TEXT', 'Email Notication is Enabled ');
286: fnd_msg_pub.Add;
287: END IF;
288: end if;
289:
290: SELECT PV_LEAD_WORKFLOWS_S.nextval INTO l_itemKey

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

292:
293: FOR i in 1 .. p_user_name_tbl.count
294: LOOP
295:
296: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
297: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
298: fnd_message.Set_Token('TEXT', 'In Loop of p_user_name_tbl '||p_user_name_tbl(i));
299: fnd_msg_pub.Add;
300: END IF;

Line 299: fnd_msg_pub.Add;

295:
296: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
297: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
298: fnd_message.Set_Token('TEXT', 'In Loop of p_user_name_tbl '||p_user_name_tbl(i));
299: fnd_msg_pub.Add;
300: END IF;
301:
302: IF p_user_type_tbl(i) = 'AM' THEN
303: l_am_role_list(i) := p_user_name_tbl(i);

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

315: l_am_adhoc_role := 'PV_' || l_itemKey || 'AM' || '_' || '0';
316:
317: -- Debug Message
318:
319: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
320: Debug('Creating role AM : '|| l_am_adhoc_role || ' with members :--');
321: END IF;
322:
323: FOR i in 1 .. l_am_role_list.count

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

324: LOOP
325:
326:
327:
328: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
329: dEBUG( l_am_role_list(i) );
330: END IF;
331:
332: END LOOP;

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

339: IF l_cm_role_list.count > 0 then
340: l_cm_adhoc_role := 'PV_' || l_itemKey || 'CM' || '_' || '0';
341:
342: -- Debug Message
343: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
344: debug('Creating role CM : '|| l_cm_adhoc_role || ' with members :-' );
345: END IF;
346:
347: FOR i in 1 .. l_cm_role_list.count

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

345: END IF;
346:
347: FOR i in 1 .. l_cm_role_list.count
348: LOOP
349: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
350: dEBUG( l_cm_role_list(i) );
351: END IF;
352: END LOOP;
353: wf_directory.CreateAdHocRole2(role_name => l_cm_adhoc_role,

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

358: IF l_pt_role_list.count > 0 then
359: l_pt_adhoc_role := 'PV_' || l_itemKey || 'PT' || '_' || '0';
360:
361: -- Debug Message
362: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
363: debug( 'Creating role PT: '|| l_pt_adhoc_role || ' with members :-' );
364: END IF;
365: FOR i in 1 .. l_pt_role_list.count
366: LOOP

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

363: debug( 'Creating role PT: '|| l_pt_adhoc_role || ' with members :-' );
364: END IF;
365: FOR i in 1 .. l_pt_role_list.count
366: LOOP
367: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
368: dEBUG( l_pt_role_list(i) );
369: END IF;
370: END LOOP;
371:

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

377: IF l_ot_role_list.count > 0 then
378: l_ot_adhoc_role := 'PV_' || l_itemKey || 'OTHER' || '_' || '0';
379:
380: -- Debug Message
381: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
382: debug('Creating role OT : '|| l_ot_adhoc_role || ' with members:- ' );
383: END IF;
384: FOR i in 1 .. l_ot_role_list.count
385: LOOP

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

382: debug('Creating role OT : '|| l_ot_adhoc_role || ' with members:- ' );
383: END IF;
384: FOR i in 1 .. l_ot_role_list.count
385: LOOP
386: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
387: dEBUG( l_ot_role_list(i) );
388: END IF;
389: END LOOP;
390:

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

502: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
503: raise FND_API.G_EXC_ERROR;
504: end if;
505:
506: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
507: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
508: fnd_message.Set_token('TEXT', 'After Checkforerror');
509: fnd_msg_pub.Add;
510: END IF;

Line 509: fnd_msg_pub.Add;

505:
506: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
507: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
508: fnd_message.Set_token('TEXT', 'After Checkforerror');
509: fnd_msg_pub.Add;
510: END IF;
511: END IF;
512:
513: IF FND_API.To_Boolean ( p_commit ) THEN

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

514: COMMIT WORK;
515: END IF;
516:
517: -- Standard call to get message count and if count is 1, get message info.
518: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
519: p_count => x_msg_count,
520: p_data => x_msg_data);
521: EXCEPTION
522:

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

521: EXCEPTION
522:
523: WHEN FND_API.G_EXC_ERROR THEN
524: x_return_status := FND_API.G_RET_STS_ERROR ;
525: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
526: p_count => x_msg_count,
527: p_data => x_msg_data);
528: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

526: p_count => x_msg_count,
527: p_data => x_msg_data);
528: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
530: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
531: p_count => x_msg_count,
532: p_data => x_msg_data);
533: WHEN OTHERS THEN
534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

531: p_count => x_msg_count,
532: p_data => x_msg_data);
533: WHEN OTHERS THEN
534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
535: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
536: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
537: p_count => x_msg_count,
538: p_data => x_msg_data);
539: end Send_Email_By_Workflow;

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

532: p_data => x_msg_data);
533: WHEN OTHERS THEN
534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
535: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
536: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
537: p_count => x_msg_count,
538: p_data => x_msg_data);
539: end Send_Email_By_Workflow;
540:

Line 614: fnd_msg_pub.initialize;

610:
611: -- Initialize message list if p_init_msg_list is set to TRUE.
612: IF FND_API.to_Boolean( p_init_msg_list )
613: THEN
614: fnd_msg_pub.initialize;
615: END IF;
616:
617: -- Debug Message
618: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

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

614: fnd_msg_pub.initialize;
615: END IF;
616:
617: -- Debug Message
618: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
619: debug( 'In ' || l_api_name);
620: END IF;
621:
622: -- Initialize API return status to success

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

624:
625: -- check the profile value and return if the value is not Y
626: l_email_enabled := nvl(fnd_profile.value('PV_EMAIL_NOTIFICATION_FLAG'), 'Y');
627:
628: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
629: debug('Email Enabled Flag '||l_email_enabled);
630: END IF;
631:
632: if (l_email_enabled <> 'Y') then

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

657: raise FND_API.G_EXC_ERROR;
658: end if;
659:
660: -- Debug Message
661: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
662: debug( 'After Createrole, withing Startworkflow');
663: END IF;
664:
665: wf_engine.CreateProcess ( ItemType => p_itemtype,

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

725:
726: wf_engine.StartProcess ( itemtype => p_itemtype,
727: itemkey => p_itemkey);
728:
729: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
730:
731: debug('wf item attr '|| wf_engine.GetItemAttrText ( itemtype => p_itemType, itemkey => p_itemKey,
732: aname => g_wf_attr_send_url));
733: debug('End of Workflow process');

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

740: COMMIT WORK;
741: END IF;
742:
743: -- Standard call to get message count and if count is 1, get message info.
744: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
745: p_count => x_msg_count,
746: p_data => x_msg_data);
747: EXCEPTION
748:

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

747: EXCEPTION
748:
749: WHEN FND_API.G_EXC_ERROR THEN
750: x_return_status := FND_API.G_RET_STS_ERROR ;
751: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
752: p_count => x_msg_count,
753: p_data => x_msg_data);
754: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
755: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

752: p_count => x_msg_count,
753: p_data => x_msg_data);
754: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
755: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
756: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
757: p_count => x_msg_count,
758: p_data => x_msg_data);
759: WHEN OTHERS THEN
760: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

757: p_count => x_msg_count,
758: p_data => x_msg_data);
759: WHEN OTHERS THEN
760: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
761: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
762: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
763: p_count => x_msg_count,
764: p_data => x_msg_data);
765: end StartWorkflow;

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

758: p_data => x_msg_data);
759: WHEN OTHERS THEN
760: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
761: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
762: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
763: p_count => x_msg_count,
764: p_data => x_msg_data);
765: end StartWorkflow;
766:

Line 921: fnd_msg_pub.initialize;

917: END IF;
918:
919: -- Initialize message list if p_init_msg_list is set to TRUE.
920: IF FND_API.to_Boolean( p_init_msg_list ) THEN
921: fnd_msg_pub.initialize;
922: END IF;
923:
924: -- Debug Message
925: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

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

921: fnd_msg_pub.initialize;
922: END IF;
923:
924: -- Debug Message
925: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
926: Debug('In ' || l_api_name);
927: END IF;
928:
929: -- Initialize API return status to success

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

928:
929: -- Initialize API return status to success
930: x_return_status := FND_API.G_RET_STS_SUCCESS;
931:
932: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
933: Debug('Relationship Type ' || p_relationship_type);
934: END IF;
935:
936: IF p_relationship_type is not null THEN

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

949: l_lead_workflow_rec.routing_status := l_r_status_unassigned;
950: END IF;
951: END IF;
952:
953: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
954: Debug('Routing Status ' || l_lead_workflow_rec.routing_status);
955: END IF;
956:
957: pv_assign_util_pvt.Create_lead_workflow_row

Line 998: FND_MSG_PUB.add;

994:
995: -- If Channel manager found create assignment and notification record
996: If l_rs_details_tbl.count <= 0 THEN
997: FND_MESSAGE.set_name('PV', 'PV_EMPTY_ROLE');
998: FND_MSG_PUB.add;
999: RAISE FND_API.g_exc_unexpected_error;
1000: ELSE
1001: -- Insert into table PV_LEAD_ASSIGNMENTS with STATUS to PT_CREATED.
1002: -- Populate data with the following values.

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

1055: l_party_notify_rec_tbl.USER_ID(i) := l_rs_details_tbl(i).user_id;
1056: l_party_notify_rec_tbl.USER_NAME(i) := l_rs_details_tbl(i).user_name;
1057: l_party_notify_rec_tbl.DECISION_MAKER_FLAG(i):= 'Y';
1058:
1059: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1060:
1061: Debug( 'Assignment ID: ' || l_lead_assignment_id ||
1062: '. Notification type: ' || l_party_notify_rec_tbl.NOTIFICATION_TYPE(i) ||
1063: '. Username: ' || l_party_notify_rec_tbl.USER_NAME(i));

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

1100: l_sales_team_rec.person_id := null;
1101: l_sales_team_rec.partner_cont_party_id := l_rs_details_tbl(i).person_id;
1102: end if;
1103:
1104: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1105: Debug( 'Partner Contact Party ID '||l_sales_team_rec.partner_cont_party_id);
1106: END IF;
1107:
1108: l_sales_team_rec.lead_id := l_lead_id;

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

1114: l_sales_team_rec.team_leader_flag := 'Y'; --Added per Suresh
1115:
1116: l_access_profile_rec := null;
1117:
1118: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1119: Debug( 'Lead ID '||l_lead_id ||' Customer ID '||l_customer_id||'salesforce_id'||
1120: l_rs_details_tbl(i).resource_id);
1121: END IF;
1122:

Line 1149: fnd_msg_pub.ADD;

1145:
1146: fnd_message.SET_NAME ('PV', 'PV_DEBUG_MESSAGE');
1147: fnd_message.SET_TOKEN ('TEXT' , 'No Default Sales Group for resource id '||
1148: l_rs_details_tbl(i).resource_id);
1149: fnd_msg_pub.ADD;
1150:
1151: fnd_message.SET_NAME ('PV', 'PV_DEBUG_MESSAGE');
1152: fnd_message.SET_TOKEN ('TEXT' , 'Not adding to oppty salesteam: '||l_rs_details_tbl(i).user_name);
1153: fnd_msg_pub.ADD;

Line 1153: fnd_msg_pub.ADD;

1149: fnd_msg_pub.ADD;
1150:
1151: fnd_message.SET_NAME ('PV', 'PV_DEBUG_MESSAGE');
1152: fnd_message.SET_TOKEN ('TEXT' , 'Not adding to oppty salesteam: '||l_rs_details_tbl(i).user_name);
1153: fnd_msg_pub.ADD;
1154:
1155: else
1156:
1157: l_sales_team_rec.sales_group_id := l_sales_group_id;

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

1174: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1175: RAISE FND_API.G_EXC_ERROR;
1176: END IF;
1177:
1178: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1179: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1180: fnd_message.Set_Token('TEXT', 'After 1st Create Sales team');
1181: fnd_msg_pub.Add;
1182: END IF;

Line 1181: fnd_msg_pub.Add;

1177:
1178: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1179: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1180: fnd_message.Set_Token('TEXT', 'After 1st Create Sales team');
1181: fnd_msg_pub.Add;
1182: END IF;
1183:
1184: end if;
1185:

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

1194: FETCH lc_address
1195: INTO l_address_id, l_partner_resource_id;
1196: CLOSE lc_address;
1197:
1198: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1199: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1200: fnd_message.Set_Token('TEXT', 'Salesgroup ID'||l_sales_team_rec.sales_group_id);
1201: fnd_msg_pub.Add;
1202: END IF;

Line 1201: fnd_msg_pub.Add;

1197:
1198: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1199: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1200: fnd_message.Set_Token('TEXT', 'Salesgroup ID'||l_sales_team_rec.sales_group_id);
1201: fnd_msg_pub.Add;
1202: END IF;
1203:
1204: l_sales_team_rec.sales_group_id := null;
1205: l_sales_team_rec.person_id := null;

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

1277: END IF;
1278:
1279: END IF;
1280:
1281: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1282: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1283: fnd_message.Set_Token('TEXT', 'After 2nd Create Sales team');
1284: fnd_msg_pub.Add;
1285: END IF;

Line 1284: fnd_msg_pub.Add;

1280:
1281: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1282: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1283: fnd_message.Set_Token('TEXT', 'After 2nd Create Sales team');
1284: fnd_msg_pub.Add;
1285: END IF;
1286:
1287: -- Update AS_LEADS_ALL set AUTO_ASSIGNMENT_TYPE in AS_LEADS_ALL to PRM for the lead_id.
1288:

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

1314: CLOSE lc_get_opp_amt;
1315:
1316: l_opp_amt_curncy := nvl(l_opp_amt,0) ||' '||l_currency_code;
1317:
1318: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1319: debug('before starting workflow ...............');
1320: END IF;
1321:
1322: -- When all the table are updated start the workflow .

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

1345: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1346: RAISE FND_API.G_EXC_ERROR;
1347: END IF;
1348:
1349: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1350: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1351: fnd_message.Set_Token('TEXT', 'After Workflow is started');
1352: fnd_msg_pub.Add;
1353: END IF;

Line 1352: fnd_msg_pub.Add;

1348:
1349: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1350: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1351: fnd_message.Set_Token('TEXT', 'After Workflow is started');
1352: fnd_msg_pub.Add;
1353: END IF;
1354:
1355: -- Call the following procedure to see whether workflow was able to send notification successfully.
1356: PV_ASSIGN_UTIL_PVT.checkforErrors

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

1374: EXCEPTION
1375:
1376: WHEN FND_API.G_EXC_ERROR THEN
1377: x_return_status := FND_API.G_RET_STS_ERROR ;
1378: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
1379: p_count => x_msg_count,
1380: p_data => x_msg_data);
1381: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

1379: p_count => x_msg_count,
1380: p_data => x_msg_data);
1381: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1383: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
1384: p_count => x_msg_count,
1385: p_data => x_msg_data);
1386: WHEN OTHERS THEN
1387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1384: p_count => x_msg_count,
1385: p_data => x_msg_data);
1386: WHEN OTHERS THEN
1387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1388: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1389: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
1390: p_count => x_msg_count,
1391: p_data => x_msg_data);
1392: END Notify_CM_On_Create_Oppty;

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

1385: p_data => x_msg_data);
1386: WHEN OTHERS THEN
1387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1388: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1389: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
1390: p_count => x_msg_count,
1391: p_data => x_msg_data);
1392: END Notify_CM_On_Create_Oppty;
1393:

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

1418: WHERE lead_id = pc_lead_id;
1419:
1420: BEGIN
1421:
1422: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1423: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1424: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || ' Funcmode: ' || funcmode);
1425: fnd_msg_pub.Add;
1426: END IF;

Line 1425: fnd_msg_pub.Add;

1421:
1422: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1423: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1424: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || ' Funcmode: ' || funcmode);
1425: fnd_msg_pub.Add;
1426: END IF;
1427:
1428: IF (funcmode = 'RUN') then
1429:

Line 1459: fnd_msg_pub.Count_And_Get(

1455: resultout := l_resultout;
1456: EXCEPTION
1457: WHEN OTHERS THEN
1458:
1459: fnd_msg_pub.Count_And_Get(
1460: p_encoded => FND_API.G_TRUE
1461: ,p_count => l_msg_count
1462: ,p_data => l_msg_data);
1463:

Line 1513: fnd_msg_pub.initialize;

1509: END IF;
1510:
1511: -- Initialize message list if p_init_msg_list is set to TRUE.
1512: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1513: fnd_msg_pub.initialize;
1514: END IF;
1515:
1516: -- Debug Message
1517: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

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

1513: fnd_msg_pub.initialize;
1514: END IF;
1515:
1516: -- Debug Message
1517: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1518: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1519: fnd_message.Set_Token('TEXT', 'In ' || l_api_name);
1520: fnd_msg_pub.Add;
1521: END IF;

Line 1520: fnd_msg_pub.Add;

1516: -- Debug Message
1517: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1518: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1519: fnd_message.Set_Token('TEXT', 'In ' || l_api_name);
1520: fnd_msg_pub.Add;
1521: END IF;
1522:
1523: -- Initialize API return status to success
1524: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1550: RAISE FND_API.G_EXC_ERROR;
1551: END IF;
1552:
1553: -- Standard call to get message count and if count is 1, get message info.
1554: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
1555: p_count => x_msg_count,
1556: p_data => x_msg_data);
1557:
1558: EXCEPTION

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

1559:
1560: WHEN FND_API.G_EXC_ERROR THEN
1561:
1562: x_return_status := FND_API.G_RET_STS_ERROR ;
1563: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
1564: p_count => x_msg_count,
1565: p_data => x_msg_data);
1566:
1567: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1566:
1567: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1568:
1569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1570: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
1571: p_count => x_msg_count,
1572: p_data => x_msg_data);
1573:
1574: WHEN OTHERS THEN

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

1571: p_count => x_msg_count,
1572: p_data => x_msg_data);
1573:
1574: WHEN OTHERS THEN
1575: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1576: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1577: fnd_message.Set_Token('TEXT', sqlcode||sqlerrm);
1578: fnd_msg_pub.Add;
1579: END IF;

Line 1578: fnd_msg_pub.Add;

1574: WHEN OTHERS THEN
1575: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1576: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1577: fnd_message.Set_Token('TEXT', sqlcode||sqlerrm);
1578: fnd_msg_pub.Add;
1579: END IF;
1580:
1581: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1582:

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

1579: END IF;
1580:
1581: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1582:
1583: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1584: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
1585: p_count => x_msg_count,
1586: p_data => x_msg_data);
1587:

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

1580:
1581: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1582:
1583: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1584: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
1585: p_count => x_msg_count,
1586: p_data => x_msg_data);
1587:
1588: END NOTIFY_ON_UPDATE_OPPTY_JBES;

Line 1805: fnd_msg_pub.initialize;

1801: END IF;
1802:
1803: -- Initialize message list if p_init_msg_list is set to TRUE.
1804: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1805: fnd_msg_pub.initialize;
1806: END IF;
1807:
1808: -- Debug Message
1809: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

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

1805: fnd_msg_pub.initialize;
1806: END IF;
1807:
1808: -- Debug Message
1809: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1810: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1811: fnd_message.Set_Token('TEXT', 'In ' || l_api_name);
1812: fnd_msg_pub.Add;
1813: END IF;

Line 1812: fnd_msg_pub.Add;

1808: -- Debug Message
1809: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1810: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1811: fnd_message.Set_Token('TEXT', 'In ' || l_api_name);
1812: fnd_msg_pub.Add;
1813: END IF;
1814:
1815: -- Initialize API return status to success
1816: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1837:
1838: END IF;
1839:
1840: -- Debug Message
1841: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1842: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1843: fnd_message.Set_Token('TEXT', 'After Found : ' || l_creating_username || ' salesforce id : ' || p_salesforce_id);
1844: fnd_msg_pub.Add;
1845: END IF;

Line 1844: fnd_msg_pub.Add;

1840: -- Debug Message
1841: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1842: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1843: fnd_message.Set_Token('TEXT', 'After Found : ' || l_creating_username || ' salesforce id : ' || p_salesforce_id);
1844: fnd_msg_pub.Add;
1845: END IF;
1846:
1847: -- Get the Opportunity Status from header and table
1848: -- IF Status is changed

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

1845: END IF;
1846:
1847: -- Get the Opportunity Status from header and table
1848: -- IF Status is changed
1849: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1850: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1851: fnd_message.Set_Token('TEXT', 'Status '||l_status);
1852: fnd_msg_pub.Add;
1853: END IF;

Line 1852: fnd_msg_pub.Add;

1848: -- IF Status is changed
1849: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1850: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1851: fnd_message.Set_Token('TEXT', 'Status '||l_status);
1852: fnd_msg_pub.Add;
1853: END IF;
1854:
1855: IF l_status is null THEN
1856: return;

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

1860: loop
1861: fetch lc_get_meaning into l_status_from, l_status_to, l_db_status, l_curr_win_loss_flag;
1862: exit when lc_get_meaning%notfound;
1863:
1864: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1865: Debug( 'l_status_to '||l_status_to ||' l_status_from '||l_status_from ||' DB Status '||l_db_status);
1866: END IF;
1867:
1868: IF l_db_status = l_status_from THEN

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

1874:
1875: end loop;
1876: close lc_get_meaning;
1877:
1878: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1879: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1880: fnd_message.Set_Token('TEXT', 'STATUS before : ' || l_from_status || ', After : ' || l_to_status);
1881: fnd_msg_pub.Add;
1882: END IF;

Line 1881: fnd_msg_pub.Add;

1877:
1878: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1879: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1880: fnd_message.Set_Token('TEXT', 'STATUS before : ' || l_from_status || ', After : ' || l_to_status);
1881: fnd_msg_pub.Add;
1882: END IF;
1883:
1884: IF l_from_status IS NULL OR l_to_status IS NULL THEN
1885: return;

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

1918: end if;
1919:
1920: if l_message_name is not null then
1921:
1922: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1923: fnd_message.SET_NAME('PV', 'PV_DEBUG_MESSAGE');
1924: fnd_message.Set_token('TEXT', 'Logging status change message: ' || l_message_name ||
1925: ' for lead_id:' || l_lead_id || ' by resource:' || p_salesforce_id);
1926: fnd_msg_pub.Add;

Line 1926: fnd_msg_pub.Add;

1922: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1923: fnd_message.SET_NAME('PV', 'PV_DEBUG_MESSAGE');
1924: fnd_message.Set_token('TEXT', 'Logging status change message: ' || l_message_name ||
1925: ' for lead_id:' || l_lead_id || ' by resource:' || p_salesforce_id);
1926: fnd_msg_pub.Add;
1927: END IF;
1928:
1929: for l_pt_id in 1..l_partner_id_tbl.count loop
1930: PVX_Utility_PVT.create_history_log(

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

1953: INTO l_notify_pt_flag, l_notify_am_flag, l_notify_cm_flag, l_notify_others_flag;
1954: CLOSE lc_status_notify;
1955:
1956: -- Debug Message
1957: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1958: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1959: fnd_message.Set_Token('TEXT', 'After PV Party Notification : ' || l_notify_pt_flag || l_notify_am_flag ||
1960: l_notify_cm_flag || l_notify_others_flag);
1961: fnd_msg_pub.Add;

Line 1961: fnd_msg_pub.Add;

1957: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1958: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1959: fnd_message.Set_Token('TEXT', 'After PV Party Notification : ' || l_notify_pt_flag || l_notify_am_flag ||
1960: l_notify_cm_flag || l_notify_others_flag);
1961: fnd_msg_pub.Add;
1962: END IF;
1963:
1964: l_partner_id_tbl := JTF_NUMBER_TABLE();
1965:

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

1986: END LOOP;
1987: CLOSE lc_users;
1988:
1989: -- Debug Message
1990: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1991: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1992: fnd_message.Set_Token('TEXT', 'Total number of parties to be notified : ' ||
1993: l_user_name_tbl.count || ' lead_id : ' || l_lead_id);
1994: fnd_msg_pub.Add;

Line 1994: fnd_msg_pub.Add;

1990: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1991: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1992: fnd_message.Set_Token('TEXT', 'Total number of parties to be notified : ' ||
1993: l_user_name_tbl.count || ' lead_id : ' || l_lead_id);
1994: fnd_msg_pub.Add;
1995: END IF;
1996:
1997: IF l_user_name_tbl.count > 0 THEN
1998: OPEN lc_opportunity(l_lead_id);

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

2000: CLOSE lc_opportunity;
2001:
2002: l_opp_amt_curncy := l_opp_amt ||' '||l_currency_code;
2003:
2004: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2005: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2006: fnd_message.Set_Token('TEXT', 'before calling the send_email ');
2007: fnd_msg_pub.Add;
2008: END IF;

Line 2007: fnd_msg_pub.Add;

2003:
2004: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2005: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2006: fnd_message.Set_Token('TEXT', 'before calling the send_email ');
2007: fnd_msg_pub.Add;
2008: END IF;
2009:
2010: Send_Email_By_Workflow (
2011: p_api_version_number => p_api_version_number,

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

2038: END IF; -- If Assignment has been started
2039: CLOSE lc_assign_ids;
2040:
2041: -- Standard call to get message count and if count is 1, get message info.
2042: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2043: p_count => x_msg_count,
2044: p_data => x_msg_data);
2045:
2046: EXCEPTION

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

2047:
2048: WHEN FND_API.G_EXC_ERROR THEN
2049:
2050: x_return_status := FND_API.G_RET_STS_ERROR ;
2051: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2052: p_count => x_msg_count,
2053: p_data => x_msg_data);
2054:
2055: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2054:
2055: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2056:
2057: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2058: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2059: p_count => x_msg_count,
2060: p_data => x_msg_data);
2061:
2062: WHEN OTHERS THEN

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

2059: p_count => x_msg_count,
2060: p_data => x_msg_data);
2061:
2062: WHEN OTHERS THEN
2063: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2064: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2065: fnd_message.Set_Token('TEXT', sqlcode||sqlerrm);
2066: fnd_msg_pub.Add;
2067: END IF;

Line 2066: fnd_msg_pub.Add;

2062: WHEN OTHERS THEN
2063: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2064: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2065: fnd_message.Set_Token('TEXT', sqlcode||sqlerrm);
2066: fnd_msg_pub.Add;
2067: END IF;
2068:
2069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2070:

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

2067: END IF;
2068:
2069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2070:
2071: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2072: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2073: p_count => x_msg_count,
2074: p_data => x_msg_data);
2075:

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

2068:
2069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2070:
2071: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2072: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2073: p_count => x_msg_count,
2074: p_data => x_msg_data);
2075:
2076: END Notify_Party_On_Update_Oppty;

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

2105: l_context VARCHAR2(80);
2106:
2107: Begin
2108:
2109: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2110: Debug( 'In ' || l_api_name || ' Funcmode: ' || funcmode);
2111: END IF;
2112:
2113: if (funcmode = 'RUN') then

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

2117: l_pt_adhoc_role := wf_engine.GetItemAttrText( itemtype => itemtype,
2118: itemkey => itemkey,
2119: aname => g_wf_attr_pt_notify_role);
2120:
2121: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2122: Debug('Partner Role' || l_pt_adhoc_role);
2123: END IF;
2124:
2125: l_cm_adhoc_role := wf_engine.GetItemAttrText( itemtype => itemtype,

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

2125: l_cm_adhoc_role := wf_engine.GetItemAttrText( itemtype => itemtype,
2126: itemkey => itemkey,
2127: aname => g_wf_attr_cm_notify_role);
2128:
2129: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2130: Debug('CM Role' || l_cm_adhoc_role);
2131: END IF;
2132:
2133: l_ot_adhoc_role := wf_engine.GetItemAttrText( itemtype => itemtype,

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

2133: l_ot_adhoc_role := wf_engine.GetItemAttrText( itemtype => itemtype,
2134: itemkey => itemkey,
2135: aname => g_wf_attr_ot_notify_role);
2136:
2137: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2138: Debug( 'Others Role' || l_ot_adhoc_role);
2139: END IF;
2140:
2141: l_am_adhoc_role := wf_engine.GetItemAttrText( itemtype => itemtype,

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

2141: l_am_adhoc_role := wf_engine.GetItemAttrText( itemtype => itemtype,
2142: itemkey => itemkey,
2143: aname => g_wf_attr_am_notify_role);
2144:
2145: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2146: Debug('AM Role' || l_am_adhoc_role);
2147: END IF;
2148:
2149: IF l_pt_adhoc_role IS NOT NULL THEN

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

2206: priority => NULL );
2207:
2208: END IF;
2209:
2210: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2211:
2212: Debug('Group Notify ID' || l_group_notify_id);
2213:
2214: END IF;

Line 2231: fnd_msg_pub.Count_And_Get(

2227: resultout := l_resultout;
2228: EXCEPTION
2229: WHEN OTHERS THEN
2230:
2231: fnd_msg_pub.Count_And_Get(
2232: p_encoded => FND_API.G_TRUE
2233: ,p_count => l_msg_count
2234: ,p_data => l_msg_data);
2235:

Line 2280: fnd_msg_pub.initialize;

2276: /***************************************************************************/
2277:
2278: -- Initialize message list if p_init_msg_list is set to TRUE.
2279: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2280: fnd_msg_pub.initialize;
2281: END IF;
2282:
2283: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2284: fnd_msg_pub.initialize;

Line 2284: fnd_msg_pub.initialize;

2280: fnd_msg_pub.initialize;
2281: END IF;
2282:
2283: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2284: fnd_msg_pub.initialize;
2285: END IF;
2286:
2287: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2288: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

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

2283: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2284: fnd_msg_pub.initialize;
2285: END IF;
2286:
2287: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2288: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2289: fnd_message.Set_Token('TEXT', 'In ' || l_api_name||' Lead ID : '||p_oppty_header_rec.lead_id
2290: ||' Salesforce ID : '||p_salesforce_id);
2291: fnd_msg_pub.Add;

Line 2291: fnd_msg_pub.Add;

2287: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2288: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2289: fnd_message.Set_Token('TEXT', 'In ' || l_api_name||' Lead ID : '||p_oppty_header_rec.lead_id
2290: ||' Salesforce ID : '||p_salesforce_id);
2291: fnd_msg_pub.Add;
2292: END IF;
2293:
2294: -- Initialize API return status to success
2295: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2364: EXCEPTION
2365: WHEN FND_API.G_EXC_ERROR THEN
2366:
2367: x_return_status := FND_API.G_RET_STS_ERROR ;
2368: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2369: p_count => x_msg_count,
2370: p_data => x_msg_data);
2371:
2372: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2371:
2372: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2373:
2374: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2375: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2376: p_count => x_msg_count,
2377: p_data => x_msg_data);
2378:
2379: WHEN OTHERS THEN

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

2378:
2379: WHEN OTHERS THEN
2380:
2381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2382: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2383: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2384: p_count => x_msg_count,
2385: p_data => x_msg_data);
2386:

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

2379: WHEN OTHERS THEN
2380:
2381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2382: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2383: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2384: p_count => x_msg_count,
2385: p_data => x_msg_data);
2386:
2387: end Create_Opportunity_Post;

Line 2425: fnd_msg_pub.initialize;

2421: /***************************************************************************/
2422:
2423: -- Initialize message list if p_init_msg_list is set to TRUE.
2424: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2425: fnd_msg_pub.initialize;
2426: END IF;
2427:
2428: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2429: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

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

2424: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2425: fnd_msg_pub.initialize;
2426: END IF;
2427:
2428: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2429: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2430: fnd_message.Set_Token('TEXT', 'In ' || l_api_name);
2431: fnd_msg_pub.Add;
2432: END IF;

Line 2431: fnd_msg_pub.Add;

2427:
2428: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2429: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2430: fnd_message.Set_Token('TEXT', 'In ' || l_api_name);
2431: fnd_msg_pub.Add;
2432: END IF;
2433:
2434: -- Initialize API return status to success
2435: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2488: exception
2489: WHEN FND_API.G_EXC_ERROR THEN
2490:
2491: x_return_status := FND_API.G_RET_STS_ERROR ;
2492: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2493: p_count => x_msg_count,
2494: p_data => x_msg_data);
2495:
2496: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2495:
2496: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2497:
2498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2499: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2500: p_count => x_msg_count,
2501: p_data => x_msg_data);
2502:
2503: WHEN no_data_found THEN

Line 2507: fnd_msg_pub.Add;

2503: WHEN no_data_found THEN
2504: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2505: fnd_message.Set_Token('TEXT', 'Current resource does not have a login user assigned. '||
2506: 'Please use resource manager to assign a login user to this resource ');
2507: fnd_msg_pub.Add;
2508:
2509: x_return_status := FND_API.G_RET_STS_ERROR ;
2510: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2511: p_count => x_msg_count,

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

2506: 'Please use resource manager to assign a login user to this resource ');
2507: fnd_msg_pub.Add;
2508:
2509: x_return_status := FND_API.G_RET_STS_ERROR ;
2510: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2511: p_count => x_msg_count,
2512: p_data => x_msg_data);
2513:
2514: WHEN OTHERS THEN

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

2513:
2514: WHEN OTHERS THEN
2515:
2516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2517: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2518: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2519: p_count => x_msg_count,
2520: p_data => x_msg_data);
2521:

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

2514: WHEN OTHERS THEN
2515:
2516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2517: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2518: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2519: p_count => x_msg_count,
2520: p_data => x_msg_data);
2521:
2522: end Update_Opportunity_Pre;

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

2585: AND peav.attribute_id(+) = 3;
2586:
2587: begin
2588:
2589: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2590: debug('In '||l_api_name);
2591: END IF;
2592:
2593: -- Initialize API return status to success

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

2599: FROM fnd_user fu, jtf_rs_resource_extns js
2600: WHERE fu.user_id = js.user_id
2601: AND js.resource_id = p_salesforce_id;
2602:
2603: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2604: debug('Person Party ID '|| l_party_id);
2605: debug('Person User name'|| x_user_name);
2606: END IF;
2607:

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

2621: end if;
2622:
2623: IF l_relationship_type is not null THEN
2624:
2625: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2626: Debug('Relationship Type '|| l_relationship_type);
2627: END IF;
2628:
2629: x_relationship_type := l_relationship_type;

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

2640:
2641: END IF;
2642:
2643: END IF;
2644: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2645: Debug('Partner Type '|| x_party_type);
2646: END IF;
2647:
2648: if (x_party_type = 'PARTNER' or x_party_type = 'VAD') THEN

Line 2657: fnd_msg_pub.ADD;

2653: close lc_chk_channel_code;
2654:
2655: if (l_channel_flag = null or l_channel_flag = 'N') then
2656: fnd_message.SET_NAME('PV', 'PV_INVALID_CHANNEL_CODE');
2657: fnd_msg_pub.ADD;
2658: raise FND_API.G_EXC_ERROR;
2659: end if;
2660:
2661: end if;

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

2663: exception
2664: WHEN FND_API.G_EXC_ERROR THEN
2665:
2666: x_return_status := FND_API.G_RET_STS_ERROR ;
2667: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2668: p_count => x_msg_count,
2669: p_data => x_msg_data);
2670:
2671: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2670:
2671: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2672:
2673: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2674: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2675: p_count => x_msg_count,
2676: p_data => x_msg_data);
2677:
2678: WHEN no_data_found THEN

Line 2682: fnd_msg_pub.Add;

2678: WHEN no_data_found THEN
2679: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2680: fnd_message.Set_Token('TEXT', 'Current resource does not have a login user assigned. '||
2681: 'Please use resource manager to assign a login user to this resource ');
2682: fnd_msg_pub.Add;
2683:
2684: x_return_status := FND_API.G_RET_STS_ERROR ;
2685: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2686: p_count => x_msg_count,

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

2681: 'Please use resource manager to assign a login user to this resource ');
2682: fnd_msg_pub.Add;
2683:
2684: x_return_status := FND_API.G_RET_STS_ERROR ;
2685: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2686: p_count => x_msg_count,
2687: p_data => x_msg_data);
2688:
2689:

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

2690:
2691: WHEN OTHERS THEN
2692:
2693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2694: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2695: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2696: p_count => x_msg_count,
2697: p_data => x_msg_data);
2698: end get_user_info;

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

2691: WHEN OTHERS THEN
2692:
2693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2694: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2695: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2696: p_count => x_msg_count,
2697: p_data => x_msg_data);
2698: end get_user_info;
2699:

Line 2708: FND_MSG_PUB.Add;

2704:
2705: BEGIN
2706: FND_MESSAGE.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2707: FND_MESSAGE.Set_Token('TEXT', p_msg_string);
2708: FND_MSG_PUB.Add;
2709:
2710: END Debug;
2711:
2712: