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

Line 93: FND_MSG_PUB.initialize;

89:
90: -- Initialize message list if p_init_msg_list is set to TRUE.
91: IF FND_API.to_Boolean( p_init_msg_list )
92: THEN
93: FND_MSG_PUB.initialize;
94: END IF;
95:
96: -- Debug Message
97: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

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

93: FND_MSG_PUB.initialize;
94: END IF;
95:
96: -- Debug Message
97: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
98: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
99: fnd_message.Set_Token('TEXT', 'In ' || l_api_name);
100: fnd_msg_pub.Add;
101: END IF;

Line 100: fnd_msg_pub.Add;

96: -- Debug Message
97: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
98: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
99: fnd_message.Set_Token('TEXT', 'In ' || l_api_name);
100: fnd_msg_pub.Add;
101: END IF;
102:
103: -- Initialize API return status to SUCCESS
104: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 164: FND_MSG_PUB.Count_And_Get

160: COMMIT WORK;
161: END IF;
162:
163: -- Standard call to get message count and if count is 1, get message info.
164: FND_MSG_PUB.Count_And_Get
165: ( p_count => x_msg_count,
166: p_data => x_msg_data
167: );
168:

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

170:
171: WHEN FND_API.G_EXC_ERROR THEN
172:
173: x_return_status := FND_API.G_RET_STS_ERROR ;
174: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
175: p_count => x_msg_count,
176: p_data => x_msg_data);
177:
178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

177:
178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
179:
180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
181: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
182: p_count => x_msg_count,
183: p_data => x_msg_data);
184:
185: WHEN OTHERS THEN

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

184:
185: WHEN OTHERS THEN
186:
187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
188: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
189: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
190: p_count => x_msg_count,
191: p_data => x_msg_data);
192:

Line 189: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,

185: WHEN OTHERS THEN
186:
187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
188: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
189: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
190: p_count => x_msg_count,
191: p_data => x_msg_data);
192:
193: END Create_Oppty_Routing_Log_Row;

Line 227: FND_MSG_PUB.initialize;

223:
224: -- Initialize message list if p_init_msg_list is set to TRUE.
225: IF FND_API.to_Boolean( p_init_msg_list )
226: THEN
227: FND_MSG_PUB.initialize;
228: END IF;
229:
230: -- Debug Message
231: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

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

227: FND_MSG_PUB.initialize;
228: END IF;
229:
230: -- Debug Message
231: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
232: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
233: fnd_message.Set_Token('TEXT', 'In ' || l_api_name);
234: fnd_msg_pub.Add;
235: END IF;

Line 234: fnd_msg_pub.Add;

230: -- Debug Message
231: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
232: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
233: fnd_message.Set_Token('TEXT', 'In ' || l_api_name);
234: fnd_msg_pub.Add;
235: END IF;
236:
237: -- Initialize API return status to SUCCESS
238: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 315: FND_MSG_PUB.Count_And_Get

311: COMMIT WORK;
312: END IF;
313:
314: -- Standard call to get message count and if count is 1, get message info.
315: FND_MSG_PUB.Count_And_Get
316: ( p_count => x_msg_count,
317: p_data => x_msg_data
318: );
319:

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

321:
322: WHEN FND_API.G_EXC_ERROR THEN
323:
324: x_return_status := FND_API.G_RET_STS_ERROR ;
325: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
326: p_count => x_msg_count,
327: p_data => x_msg_data);
328:
329: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

328:
329: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
330:
331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
332: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
333: p_count => x_msg_count,
334: p_data => x_msg_data);
335:
336: WHEN OTHERS THEN

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

335:
336: WHEN OTHERS THEN
337:
338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
339: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
340: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
341: p_count => x_msg_count,
342: p_data => x_msg_data);
343:

Line 340: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,

336: WHEN OTHERS THEN
337:
338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
339: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
340: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
341: p_count => x_msg_count,
342: p_data => x_msg_data);
343:
344: End Create_assignment_log_row;

Line 386: fnd_msg_pub.initialize;

382:
383: -- Initialize message list if p_init_msg_list is set to TRUE.
384: IF FND_API.to_Boolean( p_init_msg_list )
385: THEN
386: fnd_msg_pub.initialize;
387: END IF;
388:
389: -- Debug Message
390: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

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

386: fnd_msg_pub.initialize;
387: END IF;
388:
389: -- Debug Message
390: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
391: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
392: fnd_message.Set_Token('TEXT', 'In ' || l_api_name);
393: fnd_msg_pub.Add;
394: END IF;

Line 393: fnd_msg_pub.Add;

389: -- Debug Message
390: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
391: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
392: fnd_message.Set_Token('TEXT', 'In ' || l_api_name);
393: fnd_msg_pub.Add;
394: END IF;
395:
396: x_return_status := FND_API.G_RET_STS_SUCCESS ;
397:

Line 412: fnd_msg_pub.ADD;

408: into l_lead_assignment_id, l_party_resource_id;
409:
410: IF (SQL%NOTFOUND) THEN
411: fnd_message.SET_NAME('PV', 'Cannot find row to update');
412: fnd_msg_pub.ADD;
413:
414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
415: END IF;
416:

Line 421: fnd_msg_pub.ADD;

417: if (l_lead_assignment_id <> p_lead_assignment_id or
418: l_party_resource_id <> p_party_resource_id )
419: then
420: fnd_message.SET_NAME('PV', 'Updated wrong row');
421: fnd_msg_pub.ADD;
422:
423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
424: end if;
425:

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

452: COMMIT WORK;
453: END IF;
454:
455: -- Standard call to get message count and if count is 1, get message info.
456: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
457: p_count => x_msg_count,
458: p_data => x_msg_data);
459: EXCEPTION
460:

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

460:
461: WHEN FND_API.G_EXC_ERROR THEN
462:
463: x_return_status := FND_API.G_RET_STS_ERROR ;
464: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
465: p_count => x_msg_count,
466: p_data => x_msg_data);
467:
468: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

467:
468: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
469:
470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
471: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
472: p_count => x_msg_count,
473: p_data => x_msg_data);
474:
475: WHEN OTHERS THEN

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

474:
475: WHEN OTHERS THEN
476:
477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
478: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
479: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
480: p_count => x_msg_count,
481: p_data => x_msg_data);
482:

Line 479: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,

475: WHEN OTHERS THEN
476:
477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
478: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
479: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
480: p_count => x_msg_count,
481: p_data => x_msg_data);
482:
483: End update_party_response;

Line 542: fnd_msg_pub.initialize;

538:
539: -- Initialize message list if p_init_msg_list is set to TRUE.
540: IF FND_API.to_Boolean( p_init_msg_list )
541: THEN
542: fnd_msg_pub.initialize;
543: END IF;
544:
545: -- Debug Message
546: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

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

542: fnd_msg_pub.initialize;
543: END IF;
544:
545: -- Debug Message
546: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
547: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
548: fnd_message.Set_Token('TEXT', 'In ' || l_api_name);
549: fnd_msg_pub.Add;
550: END IF;

Line 549: fnd_msg_pub.Add;

545: -- Debug Message
546: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
547: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
548: fnd_message.Set_Token('TEXT', 'In ' || l_api_name);
549: fnd_msg_pub.Add;
550: END IF;
551:
552: x_return_status := FND_API.G_RET_STS_SUCCESS ;
553:

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

555: itemtype => p_itemtype,
556: itemkey => p_itemkey,
557: aname => pv_workflow_pub.g_wf_attr_partner_id), 0);
558:
559: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
560: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
561: fnd_message.Set_Token('TEXT', 'Get notify id for partner_id: ' || l_partner_id);
562: fnd_msg_pub.Add;
563: END IF;

Line 562: fnd_msg_pub.Add;

558:
559: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
560: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
561: fnd_message.Set_Token('TEXT', 'Get notify id for partner_id: ' || l_partner_id);
562: fnd_msg_pub.Add;
563: END IF;
564:
565: open lc_get_notified (pc_itemtype => p_itemtype,
566: pc_itemkey => p_itemkey,

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

601: COMMIT WORK;
602: END IF;
603:
604: -- Standard call to get message count and if count is 1, get message info.
605: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
606: p_count => x_msg_count,
607: p_data => x_msg_data);
608: EXCEPTION
609:

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

609:
610: WHEN FND_API.G_EXC_ERROR THEN
611:
612: x_return_status := FND_API.G_RET_STS_ERROR ;
613: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
614: p_count => x_msg_count,
615: p_data => x_msg_data);
616:
617: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

616:
617: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
618:
619: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
620: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
621: p_count => x_msg_count,
622: p_data => x_msg_data);
623:
624: WHEN OTHERS THEN

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

623:
624: WHEN OTHERS THEN
625:
626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
627: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
628: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
629: p_count => x_msg_count,
630: p_data => x_msg_data);
631:

Line 628: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,

624: WHEN OTHERS THEN
625:
626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
627: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
628: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
629: p_count => x_msg_count,
630: p_data => x_msg_data);
631:
632: End bulk_set_party_notify_id;

Line 777: fnd_msg_pub.initialize;

773:
774: -- Initialize message list if p_init_msg_list is set to TRUE.
775: IF FND_API.to_Boolean( p_init_msg_list )
776: THEN
777: fnd_msg_pub.initialize;
778: END IF;
779:
780: -- Debug Message
781: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

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

777: fnd_msg_pub.initialize;
778: END IF;
779:
780: -- Debug Message
781: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
782:
783: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
784: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || '. ID: ' || p_lead_assignment_id || ' Action: ' || p_action);
785: fnd_msg_pub.Add;

Line 785: fnd_msg_pub.Add;

781: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
782:
783: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
784: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || '. ID: ' || p_lead_assignment_id || ' Action: ' || p_action);
785: fnd_msg_pub.Add;
786:
787: if p_action = pv_assignment_pub.g_asgn_action_status_update then
788:
789: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

Line 791: fnd_msg_pub.Add;

787: if p_action = pv_assignment_pub.g_asgn_action_status_update then
788:
789: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
790: fnd_message.Set_Name('PV', 'Status: ' || p_status);
791: fnd_msg_pub.Add;
792:
793: end if;
794:
795: END IF;

Line 807: fnd_msg_pub.ADD;

803: pv_assignment_pub.g_asgn_action_move_to_log) then
804:
805: fnd_message.SET_NAME('PV', 'PV_DEBUG_MESSAGE');
806: fnd_message.SET_TOKEN('TEXT', 'Invalid action mode:' || nvl(p_action, 'NULL') );
807: fnd_msg_pub.ADD;
808:
809: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
810:
811: end if;

Line 838: fnd_msg_pub.ADD;

834:
835: IF (l_rowid is NULL) THEN
836: fnd_message.SET_NAME('PV', 'PV_DEBUG_MESSAGE');
837: fnd_message.SET_TOKEN('TEXT', 'Cannot find row');
838: fnd_msg_pub.ADD;
839:
840: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
841: END IF;
842:

Line 896: fnd_msg_pub.ADD;

892:
893: IF (SQL%NOTFOUND) THEN
894: fnd_message.SET_NAME('PV', 'PV_DEBUG_MESSAGE');
895: fnd_message.SET_TOKEN('TEXT', 'Cannot find row to update');
896: fnd_msg_pub.ADD;
897:
898: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
899: END IF;
900:

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

914:
915: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
916: raise FND_API.G_EXC_ERROR;
917: end if;
918: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
919: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
920: fnd_message.Set_Token('TEXT', 'START:Logging in Opportunity Routing Log ');
921: fnd_msg_pub.Add;
922: END IF;

Line 921: fnd_msg_pub.Add;

917: end if;
918: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
919: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
920: fnd_message.Set_Token('TEXT', 'START:Logging in Opportunity Routing Log ');
921: fnd_msg_pub.Add;
922: END IF;
923:
924: -- vansub
925: -- Start :Rivendell Update

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

950: l_oppty_routing_log_rec.event := 'OPPTY_WITHDRAW';
951: ELSIF p_status = pv_assignment_pub.g_la_status_lost_chance THEN
952: l_oppty_routing_log_rec.event := 'OPPTY_TAKEN';
953: END IF;
954: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
955: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
956: fnd_message.Set_Token('TEXT', 'Status : '||p_status||' Event : '||l_oppty_routing_log_rec.event);
957: fnd_msg_pub.Add;
958: END IF;

Line 957: fnd_msg_pub.Add;

953: END IF;
954: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
955: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
956: fnd_message.Set_Token('TEXT', 'Status : '||p_status||' Event : '||l_oppty_routing_log_rec.event);
957: fnd_msg_pub.Add;
958: END IF;
959: l_oppty_routing_log_rec.lead_id := l_lead_id;
960: l_oppty_routing_log_rec.lead_workflow_id := l_lead_workflow_id;
961: l_oppty_routing_log_rec.routing_type := l_routing_type;

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

976: ELSIF l_user_category = PV_ASSIGNMENT_PUB.g_resource_party THEN
977: l_oppty_routing_log_rec.vendor_user_id := NULL;
978: l_oppty_routing_log_rec.pt_contact_user_id := FND_GLOBAL.user_id;
979: END IF;
980: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
981: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
982: fnd_message.Set_Token('TEXT', 'Vendor User ID '||l_oppty_routing_log_rec.vendor_user_id);
983: fnd_msg_pub.Add;
984: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

Line 983: fnd_msg_pub.Add;

979: END IF;
980: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
981: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
982: fnd_message.Set_Token('TEXT', 'Vendor User ID '||l_oppty_routing_log_rec.vendor_user_id);
983: fnd_msg_pub.Add;
984: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
985: fnd_message.Set_Token('TEXT', 'Partner User ID '||l_oppty_routing_log_rec.pt_contact_user_id);
986: fnd_msg_pub.Add;
987: END IF;-- Setting Vendor and Partner User ID to SYSTEM and user type also to SYSTEM

Line 986: fnd_msg_pub.Add;

982: fnd_message.Set_Token('TEXT', 'Vendor User ID '||l_oppty_routing_log_rec.vendor_user_id);
983: fnd_msg_pub.Add;
984: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
985: fnd_message.Set_Token('TEXT', 'Partner User ID '||l_oppty_routing_log_rec.pt_contact_user_id);
986: fnd_msg_pub.Add;
987: END IF;-- Setting Vendor and Partner User ID to SYSTEM and user type also to SYSTEM
988: IF p_status IN ( pv_assignment_pub.g_la_status_cm_timeout
989: , pv_assignment_pub.g_la_status_pt_timeout
990: , pv_assignment_pub.g_la_status_lost_chance

Line 1061: fnd_msg_pub.ADD;

1057:
1058: IF (SQL%ROWCOUNT = 0) THEN
1059: fnd_message.SET_NAME('PV', 'PV_DEBUG_MESSAGE');
1060: fnd_message.SET_TOKEN('TEXT', 'Cannot find row to delete');
1061: fnd_msg_pub.ADD;
1062:
1063: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1064: END IF;
1065:

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

1100: COMMIT WORK;
1101: END IF;
1102:
1103: -- Standard call to get message count and if count is 1, get message info.
1104: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
1105: p_count => x_msg_count,
1106: p_data => x_msg_data);
1107: EXCEPTION
1108: -- -------------------------------------------------------------------------------

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

1112: -- when the current session has not completed yet.
1113: -- -------------------------------------------------------------------------------
1114: WHEN g_e_resource_busy THEN
1115: x_return_status := FND_API.G_RET_STS_ERROR;
1116: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
1117: p_count => x_msg_count,
1118: p_data => x_msg_data);
1119:
1120: RAISE;

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

1122:
1123: WHEN FND_API.G_EXC_ERROR THEN
1124:
1125: x_return_status := FND_API.G_RET_STS_ERROR ;
1126: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
1127: p_count => x_msg_count,
1128: p_data => x_msg_data);
1129:
1130: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1129:
1130: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1131:
1132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1133: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
1134: p_count => x_msg_count,
1135: p_data => x_msg_data);
1136:
1137: WHEN OTHERS THEN

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

1136:
1137: WHEN OTHERS THEN
1138:
1139: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1140: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1141: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
1142: p_count => x_msg_count,
1143: p_data => x_msg_data);
1144:

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

1137: WHEN OTHERS THEN
1138:
1139: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1140: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1141: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
1142: p_count => x_msg_count,
1143: p_data => x_msg_data);
1144:
1145: end UpdateAssignment;

Line 1388: fnd_msg_pub.initialize;

1384:
1385: -- Initialize message list if p_init_msg_list is set to TRUE.
1386: IF FND_API.to_Boolean( p_init_msg_list )
1387: THEN
1388: fnd_msg_pub.initialize;
1389: END IF;
1390:
1391: -- Debug Message
1392: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

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

1388: fnd_msg_pub.initialize;
1389: END IF;
1390:
1391: -- Debug Message
1392: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1393: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1394: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || '. itemkey = ' || p_itemkey);
1395: fnd_msg_pub.Add;
1396: END IF;

Line 1395: fnd_msg_pub.Add;

1391: -- Debug Message
1392: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1393: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1394: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || '. itemkey = ' || p_itemkey);
1395: fnd_msg_pub.Add;
1396: END IF;
1397:
1398: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1399:

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

1438: EXIT WHEN lc_get_pt_cm_accesses%NOTFOUND;
1439: END IF;
1440:
1441: -- Debug Message
1442: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1443: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1444: fnd_message.Set_Token('TEXT', 'Removing ' || l_party || ' from accesses');
1445: fnd_msg_pub.Add;
1446: END IF;

Line 1445: fnd_msg_pub.Add;

1441: -- Debug Message
1442: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1443: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1444: fnd_message.Set_Token('TEXT', 'Removing ' || l_party || ' from accesses');
1445: fnd_msg_pub.Add;
1446: END IF;
1447:
1448: if l_party = 'PARTNER' then
1449: l_access_type := pv_assignment_pub.G_PT_ORG_ACCESS;

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

1482: FETCH lc_get_reject_accesses_pt INTO l_lead_id, l_party, l_resource_id;
1483: EXIT WHEN lc_get_reject_accesses_pt%NOTFOUND;
1484:
1485: -- Debug Message
1486: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1487: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1488: fnd_message.Set_Token('TEXT', 'Removing ' || l_party || ' from accesses');
1489: fnd_msg_pub.Add;
1490: END IF;

Line 1489: fnd_msg_pub.Add;

1485: -- Debug Message
1486: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1487: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1488: fnd_message.Set_Token('TEXT', 'Removing ' || l_party || ' from accesses');
1489: fnd_msg_pub.Add;
1490: END IF;
1491:
1492: pv_assign_util_pvt.UpdateAccess(
1493: p_api_version_number => 1.0,

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

1530: COMMIT WORK;
1531: END IF;
1532:
1533: -- Standard call to get message count and if count is 1, get message info.
1534: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
1535: p_count => x_msg_count,
1536: p_data => x_msg_data);
1537: EXCEPTION
1538:

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

1538:
1539: WHEN FND_API.G_EXC_ERROR THEN
1540:
1541: x_return_status := FND_API.G_RET_STS_ERROR ;
1542: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
1543: p_count => x_msg_count,
1544: p_data => x_msg_data);
1545:
1546: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1545:
1546: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1547:
1548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1549: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
1550: p_count => x_msg_count,
1551: p_data => x_msg_data);
1552:
1553: WHEN OTHERS THEN

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

1552:
1553: WHEN OTHERS THEN
1554:
1555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1556: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1557:
1558: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
1559: p_count => x_msg_count,
1560: p_data => x_msg_data);

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

1554:
1555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1556: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1557:
1558: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
1559: p_count => x_msg_count,
1560: p_data => x_msg_data);
1561:
1562: end removeRejectedFromAccess;

Line 1632: fnd_msg_pub.initialize;

1628:
1629: -- Initialize message list if p_init_msg_list is set to TRUE.
1630: IF FND_API.to_Boolean( p_init_msg_list )
1631: THEN
1632: fnd_msg_pub.initialize;
1633: END IF;
1634:
1635: -- Debug Message
1636: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

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

1632: fnd_msg_pub.initialize;
1633: END IF;
1634:
1635: -- Debug Message
1636: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1637: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1638: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || '. itemkey: ' || p_itemkey || '. Type: ' || p_timeouttype);
1639: fnd_msg_pub.Add;
1640: END IF;

Line 1639: fnd_msg_pub.Add;

1635: -- Debug Message
1636: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1637: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1638: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || '. itemkey: ' || p_itemkey || '. Type: ' || p_timeouttype);
1639: fnd_msg_pub.Add;
1640: END IF;
1641:
1642: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1643:

Line 1657: fnd_msg_pub.Add;

1653: else
1654:
1655: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1656: fnd_message.set_token('TEXT', 'Invalid timeout type: ' || p_timeoutType);
1657: fnd_msg_pub.Add;
1658:
1659: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1660:
1661: end if;

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

1669: itemkey => p_itemkey,
1670: aname => pv_workflow_pub.g_wf_attr_process_rule_id);
1671:
1672:
1673: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1674: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1675: fnd_message.Set_Token('TEXT', 'Process Rule ID from set timeout '||l_process_rule_id);
1676: fnd_msg_pub.Add;
1677: END IF;

Line 1676: fnd_msg_pub.Add;

1672:
1673: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1674: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1675: fnd_message.Set_Token('TEXT', 'Process Rule ID from set timeout '||l_process_rule_id);
1676: fnd_msg_pub.Add;
1677: END IF;
1678:
1679:
1680: --l_server_timezone_id := fnd_profile.value('AMS_SYSTEM_TIMEZONE_ID');

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

1685: select UPGRADE_TZ_ID into l_GMT_timezone_id
1686: from fnd_timezones_vl
1687: where timezone_code = 'GMT';
1688:
1689: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1690: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1691: fnd_message.Set_Token('TEXT', 'GMT Timezone ID '|| l_GMT_timezone_id);
1692: fnd_msg_pub.Add;
1693: END IF;

Line 1692: fnd_msg_pub.Add;

1688:
1689: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1690: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1691: fnd_message.Set_Token('TEXT', 'GMT Timezone ID '|| l_GMT_timezone_id);
1692: fnd_msg_pub.Add;
1693: END IF;
1694:
1695: -- -----------------------------------------------------------------------
1696: -- This query retrieves CM or partner timeout based on the address' country.

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

1746:
1747: open lc_get_rule_timeout(p_timeoutType, l_process_rule_id);
1748: fetch lc_get_rule_timeout into l_rule_timeout;
1749:
1750: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1751: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1752: fnd_message.Set_Token('TEXT', 'Timeout type is '||p_timeoutType||'Rule timeout is '|| l_rule_timeout);
1753: fnd_msg_pub.Add;
1754: END IF;

Line 1753: fnd_msg_pub.Add;

1749:
1750: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1751: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1752: fnd_message.Set_Token('TEXT', 'Timeout type is '||p_timeoutType||'Rule timeout is '|| l_rule_timeout);
1753: fnd_msg_pub.Add;
1754: END IF;
1755:
1756: IF lc_get_rule_timeout%FOUND and l_rule_timeout is not null THEN
1757: l_timeout := l_rule_timeout*60;

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

1778: open lc_get_rule_timeout(p_timeoutType, l_process_rule_id);
1779: fetch lc_get_rule_timeout into l_rule_timeout;
1780:
1781:
1782: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1783: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1784: fnd_message.Set_Token('TEXT', 'Rule timeout is from auto matching rule '|| l_rule_timeout);
1785: fnd_msg_pub.Add;
1786: END IF;

Line 1785: fnd_msg_pub.Add;

1781:
1782: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1783: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1784: fnd_message.Set_Token('TEXT', 'Rule timeout is from auto matching rule '|| l_rule_timeout);
1785: fnd_msg_pub.Add;
1786: END IF;
1787:
1788: IF lc_get_rule_timeout%FOUND and l_rule_timeout is not null THEN
1789: l_timeout := l_rule_timeout*60;

Line 1822: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1818: -- If l_timeout is NULL, i.e. no address defined for this customer and
1819: -- no default timeout profile specified, throw an exception.
1820: -- ------------------------------------------------------------------
1821: IF (l_timeout IS NULL AND l_timeout_profile = 'PV_DEFAULT_CM_TIMEOUT') THEN
1822: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1823: p_msg_name => 'PV_NO_DEFAULT_CM_TIMEOUT',
1824: p_token1 => null,
1825: p_token1_value => null,
1826: p_token2 => null,

Line 1832: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1828:
1829: RAISE FND_API.G_EXC_ERROR;
1830:
1831: ELSIF (l_timeout IS NULL AND l_timeout_profile = 'PV_DEFAULT_PT_TIMEOUT') THEN
1832: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1833: p_msg_name => 'PV_NO_DEFAULT_PT_TIMEOUT',
1834: p_token1 => null,
1835: p_token1_value => null,
1836: p_token2 => null,

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

1870:
1871: l_GMT_time := to_char(l_GMT_date,'DD-MON-YYYY HH24:MI')||' '||'GMT';
1872:
1873:
1874: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1875: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1876: fnd_message.Set_Token('TEXT', 'GMT timeout is '|| l_GMT_time);
1877: fnd_msg_pub.Add;
1878: END IF;

Line 1877: fnd_msg_pub.Add;

1873:
1874: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1875: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1876: fnd_message.Set_Token('TEXT', 'GMT timeout is '|| l_GMT_time);
1877: fnd_msg_pub.Add;
1878: END IF;
1879:
1880:
1881: IF p_timeoutType = pv_assignment_pub.g_matched_timeout THEN

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

1915:
1916: END IF;
1917:
1918: -- Debug Message
1919: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1920: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1921: fnd_message.Set_token('TEXT', 'Timeout set to: ' || l_timeout);
1922: fnd_msg_pub.Add;
1923: END IF;

Line 1922: fnd_msg_pub.Add;

1918: -- Debug Message
1919: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1920: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1921: fnd_message.Set_token('TEXT', 'Timeout set to: ' || l_timeout);
1922: fnd_msg_pub.Add;
1923: END IF;
1924:
1925: IF FND_API.To_Boolean ( p_commit ) THEN
1926: COMMIT WORK;

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

1926: COMMIT WORK;
1927: END IF;
1928:
1929: -- Standard call to get message count and if count is 1, get message info.
1930: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
1931: p_count => x_msg_count,
1932: p_data => x_msg_data);
1933: EXCEPTION
1934:

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

1934:
1935: WHEN FND_API.G_EXC_ERROR THEN
1936:
1937: x_return_status := FND_API.G_RET_STS_ERROR ;
1938: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
1939: p_count => x_msg_count,
1940: p_data => x_msg_data);
1941:
1942: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1941:
1942: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1943:
1944: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1945: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
1946: p_count => x_msg_count,
1947: p_data => x_msg_data);
1948:
1949: WHEN OTHERS THEN

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

1948:
1949: WHEN OTHERS THEN
1950:
1951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1952: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1953: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
1954: p_count => x_msg_count,
1955: p_data => x_msg_data);
1956:

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

1949: WHEN OTHERS THEN
1950:
1951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1952: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1953: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
1954: p_count => x_msg_count,
1955: p_data => x_msg_data);
1956:
1957: end setTimeout;

Line 1993: fnd_msg_pub.initialize;

1989:
1990: -- Initialize message list if p_init_msg_list is set to TRUE.
1991: IF FND_API.to_Boolean( p_init_msg_list )
1992: THEN
1993: fnd_msg_pub.initialize;
1994: END IF;
1995:
1996: -- Debug Message
1997: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

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

1993: fnd_msg_pub.initialize;
1994: END IF;
1995:
1996: -- Debug Message
1997: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1998: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1999: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || '. Itemkey: ' || p_itemkey || '. Partner id: ' || p_partner_id);
2000: fnd_msg_pub.Add;
2001: END IF;

Line 2000: fnd_msg_pub.Add;

1996: -- Debug Message
1997: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1998: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1999: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || '. Itemkey: ' || p_itemkey || '. Partner id: ' || p_partner_id);
2000: fnd_msg_pub.Add;
2001: END IF;
2002:
2003: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2004:

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

2037: COMMIT WORK;
2038: END IF;
2039:
2040: -- Standard call to get message count and if count is 1, get message info.
2041: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2042: p_count => x_msg_count,
2043: p_data => x_msg_data);
2044: EXCEPTION
2045:

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

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

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

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

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

2059:
2060: WHEN OTHERS THEN
2061:
2062: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2063: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2064: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2065: p_count => x_msg_count,
2066: p_data => x_msg_data);
2067:

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

2060: WHEN OTHERS THEN
2061:
2062: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2063: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2064: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2065: p_count => x_msg_count,
2066: p_data => x_msg_data);
2067:
2068: end SetPartnerAttributes;

Line 2158: fnd_msg_pub.initialize;

2154:
2155: -- Initialize message list if p_init_msg_list is set to TRUE.
2156: IF FND_API.to_Boolean( p_init_msg_list )
2157: THEN
2158: fnd_msg_pub.initialize;
2159: END IF;
2160:
2161: -- Debug Message
2162: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

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

2158: fnd_msg_pub.initialize;
2159: END IF;
2160:
2161: -- Debug Message
2162: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2163: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2164: fnd_message.Set_Token('TEXT', 'In ' || l_api_name);
2165: fnd_msg_pub.Add;
2166: END IF;

Line 2165: fnd_msg_pub.Add;

2161: -- Debug Message
2162: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2163: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2164: fnd_message.Set_Token('TEXT', 'In ' || l_api_name);
2165: fnd_msg_pub.Add;
2166: END IF;
2167:
2168: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2169:

Line 2191: fnd_msg_pub.Add;

2187: if lc_get_pt_org_name%notfound then
2188:
2189: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2190: fnd_message.Set_token('TEXT', 'Cannot find partner for itemkey: ' || p_itemkey || '. Partner id: ' || p_partner_id);
2191: fnd_msg_pub.Add;
2192: raise FND_API.G_EXC_ERROR;
2193:
2194: end if;
2195:

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

2299: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
2300: raise FND_API.G_EXC_ERROR;
2301: end if;
2302:
2303: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2304: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2305: fnd_message.Set_Token('TEXT', 'Updating opportunity last offered date for partner ' || nvl(to_char(p_partner_id), '(s)'));
2306: fnd_msg_pub.Add;
2307: END IF;

Line 2306: fnd_msg_pub.Add;

2302:
2303: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2304: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2305: fnd_message.Set_Token('TEXT', 'Updating opportunity last offered date for partner ' || nvl(to_char(p_partner_id), '(s)'));
2306: fnd_msg_pub.Add;
2307: END IF;
2308:
2309: if p_partner_id is not null then
2310: -- single and serial

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

2337: pv_assignment_pub.g_la_status_cm_timeout
2338: ));
2339: end if;
2340:
2341: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2342: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2343: fnd_message.Set_Token('TEXT', 'Setting access code for partner ' || nvl(to_char(p_partner_id), '(s)'));
2344: fnd_msg_pub.Add;
2345: END IF;

Line 2344: fnd_msg_pub.Add;

2340:
2341: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2342: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2343: fnd_message.Set_Token('TEXT', 'Setting access code for partner ' || nvl(to_char(p_partner_id), '(s)'));
2344: fnd_msg_pub.Add;
2345: END IF;
2346:
2347: if p_partner_id is not null then
2348: -- single and serial

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

2386: COMMIT WORK;
2387: END IF;
2388:
2389: -- Standard call to get message count and if count is 1, get message info.
2390: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2391: p_count => x_msg_count,
2392: p_data => x_msg_data);
2393: EXCEPTION
2394:

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

2394:
2395: WHEN FND_API.G_EXC_ERROR THEN
2396:
2397: x_return_status := FND_API.G_RET_STS_ERROR ;
2398: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2399: p_count => x_msg_count,
2400: p_data => x_msg_data);
2401:
2402: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2401:
2402: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2403:
2404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2405: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2406: p_count => x_msg_count,
2407: p_data => x_msg_data);
2408:
2409: WHEN OTHERS THEN

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

2408:
2409: WHEN OTHERS THEN
2410:
2411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2412: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2413: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2414: p_count => x_msg_count,
2415: p_data => x_msg_data);
2416:

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

2409: WHEN OTHERS THEN
2410:
2411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2412: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2413: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2414: p_count => x_msg_count,
2415: p_data => x_msg_data);
2416:
2417: end set_offered_attributes;

Line 2512: fnd_msg_pub.initialize;

2508:
2509: -- Initialize message list if p_init_msg_list is set to TRUE.
2510: IF FND_API.to_Boolean( p_init_msg_list )
2511: THEN
2512: fnd_msg_pub.initialize;
2513: END IF;
2514:
2515: -- Debug Message
2516: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

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

2512: fnd_msg_pub.initialize;
2513: END IF;
2514:
2515: -- Debug Message
2516: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2517: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2518: fnd_message.Set_Token('TEXT', 'In ' || l_api_name);
2519: fnd_msg_pub.Add;
2520: END IF;

Line 2519: fnd_msg_pub.Add;

2515: -- Debug Message
2516: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2517: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2518: fnd_message.Set_Token('TEXT', 'In ' || l_api_name);
2519: fnd_msg_pub.Add;
2520: END IF;
2521:
2522: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2523:

Line 2535: fnd_msg_pub.ADD;

2531:
2532: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2533: fnd_message.SET_TOKEN('TEXT', 'Invalid workflow routing stage. Itemkey: ' || p_itemkey ||
2534: '. Stage: ' || p_routing_stage);
2535: fnd_msg_pub.ADD;
2536:
2537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2538:
2539: end if;

Line 2551: fnd_msg_pub.ADD;

2547:
2548: if l_rowid is null then
2549: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2550: fnd_message.SET_TOKEN('TEXT', 'Cannot find workflow row to update. Itemkey: ' || p_itemkey);
2551: fnd_msg_pub.ADD;
2552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2553: end if;
2554:
2555: if p_routing_stage = pv_assignment_pub.g_r_status_active and p_active_but_open_flag = 'Y' then

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

2753: COMMIT WORK;
2754: END IF;
2755:
2756: -- Standard call to get message count and if count is 1, get message info.
2757: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2758: p_count => x_msg_count,
2759: p_data => x_msg_data);
2760: EXCEPTION
2761:

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

2761:
2762: WHEN FND_API.G_EXC_ERROR THEN
2763:
2764: x_return_status := FND_API.G_RET_STS_ERROR ;
2765: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2766: p_count => x_msg_count,
2767: p_data => x_msg_data);
2768:
2769: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2768:
2769: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2770:
2771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2772: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2773: p_count => x_msg_count,
2774: p_data => x_msg_data);
2775:
2776: WHEN OTHERS THEN

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

2775:
2776: WHEN OTHERS THEN
2777:
2778: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2779: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2780: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2781: p_count => x_msg_count,
2782: p_data => x_msg_data);
2783:

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

2776: WHEN OTHERS THEN
2777:
2778: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2779: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2780: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2781: p_count => x_msg_count,
2782: p_data => x_msg_data);
2783:
2784: end update_routing_stage;

Line 2823: fnd_msg_pub.initialize;

2819:
2820: -- Initialize message list if p_init_msg_list is set to TRUE.
2821: IF FND_API.to_Boolean( p_init_msg_list )
2822: THEN
2823: fnd_msg_pub.initialize;
2824: END IF;
2825:
2826: -- Debug Message
2827: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

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

2823: fnd_msg_pub.initialize;
2824: END IF;
2825:
2826: -- Debug Message
2827: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2828: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2829: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || '. Itemtype: ' || p_itemtype || '. Itemkey: ' || p_itemkey);
2830: fnd_msg_pub.Add;
2831: END IF;

Line 2830: fnd_msg_pub.Add;

2826: -- Debug Message
2827: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2828: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2829: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || '. Itemtype: ' || p_itemtype || '. Itemkey: ' || p_itemkey);
2830: fnd_msg_pub.Add;
2831: END IF;
2832:
2833: -- Initialize API return status to success
2834: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2884: wf_engine.SetItemAttrText ( itemtype => p_itemType,
2885: itemkey => p_itemKey,
2886: aname => 'PV_PT_RESPOND_URL_ATTR',
2887: avalue => l_pt_respond_URL);
2888: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2889: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2890: fnd_message.Set_Token('TEXT', 'process rule id in the if of workflow set'|| p_attrib_values_rec.process_rule_id);
2891: fnd_msg_pub.Add;
2892: END IF;

Line 2891: fnd_msg_pub.Add;

2887: avalue => l_pt_respond_URL);
2888: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2889: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2890: fnd_message.Set_Token('TEXT', 'process rule id in the if of workflow set'|| p_attrib_values_rec.process_rule_id);
2891: fnd_msg_pub.Add;
2892: END IF;
2893:
2894: -- Setting Process Rule ID Attribute
2895: wf_engine.SetItemAttrNumber( itemtype => p_itemType,

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

2914: itemkey => p_itemkey,
2915: aname => pv_workflow_pub.g_wf_attr_entity_name,
2916: avalue => p_attrib_values_rec.entity_name);
2917:
2918: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2919: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2920: fnd_message.Set_Token('TEXT', 'in startworkflow Entity Amount'||p_attrib_values_rec.entity_amount);
2921: fnd_msg_pub.Add;
2922: END IF;

Line 2921: fnd_msg_pub.Add;

2917:
2918: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2919: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2920: fnd_message.Set_Token('TEXT', 'in startworkflow Entity Amount'||p_attrib_values_rec.entity_amount);
2921: fnd_msg_pub.Add;
2922: END IF;
2923: wf_engine.SetItemAttrText( itemtype => p_itemtype,
2924: itemkey => p_itemkey,
2925: aname => pv_workflow_pub.g_wf_attr_entity_amount,

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

2925: aname => pv_workflow_pub.g_wf_attr_entity_amount,
2926: avalue => p_attrib_values_rec.entity_amount);
2927:
2928:
2929: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2930: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2931: fnd_message.Set_Token('TEXT', 'after the entity amount');
2932: fnd_msg_pub.Add;
2933: END IF;

Line 2932: fnd_msg_pub.Add;

2928:
2929: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2930: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2931: fnd_message.Set_Token('TEXT', 'after the entity amount');
2932: fnd_msg_pub.Add;
2933: END IF;
2934:
2935: wf_engine.SetItemAttrText ( itemtype => p_itemtype,
2936: itemkey => p_itemkey,

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

2964: COMMIT WORK;
2965: END IF;
2966:
2967: -- Standard call to get message count and if count is 1, get message info.
2968: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2969: p_count => x_msg_count,
2970: p_data => x_msg_data);
2971: EXCEPTION
2972:

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

2972:
2973: WHEN FND_API.G_EXC_ERROR THEN
2974:
2975: x_return_status := FND_API.G_RET_STS_ERROR ;
2976: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2977: p_count => x_msg_count,
2978: p_data => x_msg_data);
2979:
2980: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2979:
2980: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2981:
2982: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2983: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2984: p_count => x_msg_count,
2985: p_data => x_msg_data);
2986:
2987: WHEN OTHERS THEN

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

2986:
2987: WHEN OTHERS THEN
2988:
2989: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2990: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2991: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2992: p_count => x_msg_count,
2993: p_data => x_msg_data);
2994: end StartWorkflow;

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

2987: WHEN OTHERS THEN
2988:
2989: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2990: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2991: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2992: p_count => x_msg_count,
2993: p_data => x_msg_data);
2994: end StartWorkflow;
2995:

Line 3039: fnd_msg_pub.initialize;

3035:
3036: -- Initialize message list if p_init_msg_list is set to TRUE.
3037: IF FND_API.to_Boolean( p_init_msg_list )
3038: THEN
3039: fnd_msg_pub.initialize;
3040: END IF;
3041:
3042: -- Debug Message
3043: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

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

3039: fnd_msg_pub.initialize;
3040: END IF;
3041:
3042: -- Debug Message
3043: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
3044: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
3045: fnd_message.Set_Token('TEXT', 'In ' || l_api_name);
3046: fnd_msg_pub.Add;
3047: END IF;

Line 3046: fnd_msg_pub.Add;

3042: -- Debug Message
3043: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
3044: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
3045: fnd_message.Set_Token('TEXT', 'In ' || l_api_name);
3046: fnd_msg_pub.Add;
3047: END IF;
3048:
3049: x_return_status := FND_API.G_RET_STS_SUCCESS ;
3050:

Line 3055: fnd_msg_pub.ADD;

3051: if p_response_code is null then
3052:
3053: fnd_message.SET_NAME('PV', 'PV_INVALID_RESPONSE');
3054: fnd_message.SET_TOKEN('STATUS', p_response_code);
3055: fnd_msg_pub.ADD;
3056:
3057: raise FND_API.G_EXC_ERROR;
3058:
3059: end if;

Line 3064: fnd_msg_pub.ADD;

3060:
3061: if p_decision_maker_flag <> 'Y' or p_decision_maker_flag is NULL then
3062:
3063: fnd_message.set_name('PV', 'PV_NOT_DECISION_MAKER');
3064: fnd_msg_pub.ADD;
3065:
3066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3067:
3068: end if;

Line 3080: fnd_msg_pub.ADD;

3076: if l_response_txt is null then
3077:
3078: fnd_message.SET_NAME('PV', 'PV_INVALID_RESPONSE');
3079: fnd_message.SET_TOKEN('STATUS', p_response_code);
3080: fnd_msg_pub.ADD;
3081:
3082: raise FND_API.G_EXC_ERROR;
3083: end if;
3084:

Line 3127: fnd_msg_pub.ADD;

3123:
3124: fnd_message.SET_NAME('PV', 'PV_INVALID_LEAD_RESPONSE');
3125: fnd_message.SET_TOKEN('P_RESPONSE', l_response_txt);
3126: fnd_message.SET_TOKEN('P_LEAD_STATUS', l_routing_status_txt);
3127: fnd_msg_pub.ADD;
3128:
3129: raise FND_API.G_EXC_ERROR;
3130: end if;
3131:

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

3134: COMMIT WORK;
3135: END IF;
3136:
3137: -- Standard call to get message count and if count is 1, get message info.
3138: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
3139: p_count => x_msg_count,
3140: p_data => x_msg_data);
3141: EXCEPTION
3142:

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

3142:
3143: WHEN FND_API.G_EXC_ERROR THEN
3144:
3145: x_return_status := FND_API.G_RET_STS_ERROR ;
3146: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
3147: p_count => x_msg_count,
3148: p_data => x_msg_data);
3149:
3150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

3149:
3150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3151:
3152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3153: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
3154: p_count => x_msg_count,
3155: p_data => x_msg_data);
3156:
3157: WHEN OTHERS THEN

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

3156:
3157: WHEN OTHERS THEN
3158:
3159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3160: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3161: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
3162: p_count => x_msg_count,
3163: p_data => x_msg_data);
3164: end validateResponse;

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

3157: WHEN OTHERS THEN
3158:
3159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3160: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3161: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
3162: p_count => x_msg_count,
3163: p_data => x_msg_data);
3164: end validateResponse;
3165:

Line 3196: fnd_msg_pub.initialize;

3192:
3193: -- Initialize message list if p_init_msg_list is set to TRUE.
3194: IF FND_API.to_Boolean( p_init_msg_list )
3195: THEN
3196: fnd_msg_pub.initialize;
3197: END IF;
3198:
3199: -- Debug Message
3200: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

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

3196: fnd_msg_pub.initialize;
3197: END IF;
3198:
3199: -- Debug Message
3200: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
3201: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
3202: fnd_message.Set_Token('TEXT', 'In ' || l_api_name);
3203: fnd_msg_pub.Add;
3204: END IF;

Line 3203: fnd_msg_pub.Add;

3199: -- Debug Message
3200: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
3201: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
3202: fnd_message.Set_Token('TEXT', 'In ' || l_api_name);
3203: fnd_msg_pub.Add;
3204: END IF;
3205:
3206: x_return_status := FND_API.G_RET_STS_SUCCESS ;
3207:

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

3216: COMMIT WORK;
3217: END IF;
3218:
3219: -- Standard call to get message count and if count is 1, get message info.
3220: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
3221: p_count => x_msg_count,
3222: p_data => x_msg_data);
3223: EXCEPTION
3224:

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

3224:
3225: WHEN FND_API.G_EXC_ERROR THEN
3226:
3227: x_return_status := FND_API.G_RET_STS_ERROR ;
3228: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
3229: p_count => x_msg_count,
3230: p_data => x_msg_data);
3231:
3232: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

3231:
3232: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3233:
3234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3235: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
3236: p_count => x_msg_count,
3237: p_data => x_msg_data);
3238:
3239: WHEN OTHERS THEN

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

3238:
3239: WHEN OTHERS THEN
3240:
3241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3242: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3243: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
3244: p_count => x_msg_count,
3245: p_data => x_msg_data);
3246:

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

3239: WHEN OTHERS THEN
3240:
3241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3242: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3243: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
3244: p_count => x_msg_count,
3245: p_data => x_msg_data);
3246:
3247: end set_current_routing_flag;

Line 3285: FND_MSG_PUB.initialize;

3281:
3282: -- Initialize message list if p_init_msg_list is set to TRUE.
3283: IF FND_API.to_Boolean( p_init_msg_list )
3284: THEN
3285: FND_MSG_PUB.initialize;
3286: END IF;
3287:
3288: -- Debug Message
3289: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

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

3285: FND_MSG_PUB.initialize;
3286: END IF;
3287:
3288: -- Debug Message
3289: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
3290: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
3291: fnd_message.Set_Token('TEXT', 'In ' || l_api_name);
3292: fnd_msg_pub.Add;
3293: END IF;

Line 3292: fnd_msg_pub.Add;

3288: -- Debug Message
3289: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
3290: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
3291: fnd_message.Set_Token('TEXT', 'In ' || l_api_name);
3292: fnd_msg_pub.Add;
3293: END IF;
3294:
3295: -- Initialize API return status to SUCCESS
3296: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

3298: --
3299: -- API body
3300: --
3301:
3302: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
3303: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
3304: fnd_message.Set_Token('TEXT', 'Bulk adding ' || p_party_Notify_rec_tbl.lead_assignment_id.count || ' rows');
3305: fnd_msg_pub.Add;
3306: END IF;

Line 3305: fnd_msg_pub.Add;

3301:
3302: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
3303: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
3304: fnd_message.Set_Token('TEXT', 'Bulk adding ' || p_party_Notify_rec_tbl.lead_assignment_id.count || ' rows');
3305: fnd_msg_pub.Add;
3306: END IF;
3307:
3308: if p_party_Notify_rec_tbl.lead_assignment_id.count > 0 then
3309:

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

3367: COMMIT WORK;
3368: END IF;
3369:
3370: -- Standard call to get message count and if count is 1, get message info.
3371: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
3372: p_count => x_msg_count,
3373: p_data => x_msg_data);
3374: EXCEPTION
3375:

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

3375:
3376: WHEN FND_API.G_EXC_ERROR THEN
3377:
3378: x_return_status := FND_API.G_RET_STS_ERROR ;
3379: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
3380: p_count => x_msg_count,
3381: p_data => x_msg_data);
3382:
3383: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

3382:
3383: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3384:
3385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3386: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
3387: p_count => x_msg_count,
3388: p_data => x_msg_data);
3389:
3390: WHEN OTHERS THEN

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

3389:
3390: WHEN OTHERS THEN
3391:
3392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3393: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3394: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
3395: p_count => x_msg_count,
3396: p_data => x_msg_data);
3397:

Line 3394: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,

3390: WHEN OTHERS THEN
3391:
3392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3393: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3394: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
3395: p_count => x_msg_count,
3396: p_data => x_msg_data);
3397:
3398: END Bulk_cr_party_notification;

Line 3584: fnd_msg_pub.initialize;

3580:
3581: -- Initialize message list if p_init_msg_list is set to TRUE.
3582: IF FND_API.to_Boolean( p_init_msg_list )
3583: THEN
3584: fnd_msg_pub.initialize;
3585: END IF;
3586:
3587: -- Debug Message
3588: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

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

3584: fnd_msg_pub.initialize;
3585: END IF;
3586:
3587: -- Debug Message
3588: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
3589: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
3590: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || '. itemkey = ' || p_itemkey);
3591: fnd_msg_pub.Add;
3592: END IF;

Line 3591: fnd_msg_pub.Add;

3587: -- Debug Message
3588: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
3589: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
3590: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || '. itemkey = ' || p_itemkey);
3591: fnd_msg_pub.Add;
3592: END IF;
3593:
3594: x_return_status := FND_API.G_RET_STS_SUCCESS ;
3595:

Line 3623: fnd_msg_pub.ADD;

3619: if l_notify_enabled_flag is NULL then
3620:
3621: fnd_message.SET_NAME('PV', 'PV_DEBUG_MESSAGE');
3622: fnd_message.SET_TOKEN('TEXT', 'Cannot find routing stage: ' || p_route_stage || ' in pv_status_notifications');
3623: fnd_msg_pub.ADD;
3624: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3625:
3626: end if;
3627:

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

3624: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3625:
3626: end if;
3627:
3628: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
3629: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
3630: fnd_message.Set_Token('TEXT', 'Lead id: ' || l_lead_id ||
3631: '. Notification for routing: ' || p_route_stage ||
3632: '. Enabled: ' || l_notify_enabled_flag);

Line 3633: fnd_msg_pub.Add;

3629: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
3630: fnd_message.Set_Token('TEXT', 'Lead id: ' || l_lead_id ||
3631: '. Notification for routing: ' || p_route_stage ||
3632: '. Enabled: ' || l_notify_enabled_flag);
3633: fnd_msg_pub.Add;
3634: END IF;
3635:
3636: if l_notify_enabled_flag = 'Y' then
3637:

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

3634: END IF;
3635:
3636: if l_notify_enabled_flag = 'Y' then
3637:
3638: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
3639: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
3640: fnd_message.Set_Token('TEXT', ' Notify AM: ' || l_notify_am_flag ||
3641: ' Notify PT: ' || l_notify_pt_flag ||
3642: ' Notify CM: ' || l_notify_cm_flag ||

Line 3644: fnd_msg_pub.Add;

3640: fnd_message.Set_Token('TEXT', ' Notify AM: ' || l_notify_am_flag ||
3641: ' Notify PT: ' || l_notify_pt_flag ||
3642: ' Notify CM: ' || l_notify_cm_flag ||
3643: ' Notify other: ' || l_notify_ot_flag);
3644: fnd_msg_pub.Add;
3645: END IF;
3646:
3647: if p_partner_id is not null then
3648: l_selected_pt_only := true;

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

3736:
3737: l_profile_flag := nvl(fnd_profile.value_specific(name => 'PV_' || p_route_stage || '_NOTIFY_FLAG',
3738: user_id => l_user_id), 'Y');
3739:
3740: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
3741: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
3742: fnd_message.Set_Token('TEXT', 'User: ' || l_username || '. Usertype: ' || l_usertype ||
3743: '. Profile notify flag: ' || l_profile_flag || '. partner id: ' || l_partner_id);
3744: fnd_msg_pub.Add;

Line 3744: fnd_msg_pub.Add;

3740: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
3741: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
3742: fnd_message.Set_Token('TEXT', 'User: ' || l_username || '. Usertype: ' || l_usertype ||
3743: '. Profile notify flag: ' || l_profile_flag || '. partner id: ' || l_partner_id);
3744: fnd_msg_pub.Add;
3745: end if;
3746:
3747: if l_profile_flag = 'Y' then
3748:

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

3925: debug ('l_role_list.count ::' ||l_role_list.count);
3926:
3927: if l_msg_name is not null then
3928:
3929: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
3930: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
3931: fnd_message.Set_token('TEXT', 'Creating role: '||l_adhoc_role||' with members--- ');
3932: fnd_msg_pub.Add;
3933: END IF;

Line 3932: fnd_msg_pub.Add;

3928:
3929: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
3930: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
3931: fnd_message.Set_token('TEXT', 'Creating role: '||l_adhoc_role||' with members--- ');
3932: fnd_msg_pub.Add;
3933: END IF;
3934:
3935: FOR ind in 1 .. l_role_list.count
3936: LOOP

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

3948: role_display_name => l_adhoc_role,
3949: role_users => l_role_list);
3950: EXCEPTION
3951: WHEN OTHERS THEN
3952: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
3953: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
3954: fnd_message.Set_token('TEXT', 'Did not create the role as it already exists');
3955: fnd_msg_pub.Add;
3956: END IF;

Line 3955: fnd_msg_pub.Add;

3951: WHEN OTHERS THEN
3952: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
3953: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
3954: fnd_message.Set_token('TEXT', 'Did not create the role as it already exists');
3955: fnd_msg_pub.Add;
3956: END IF;
3957: EXIT;
3958: END;
3959:

Line 3972: fnd_msg_pub.Add;

3968: if l_partner_org is null then
3969:
3970: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
3971: fnd_message.Set_token('TEXT', 'Cannot find partner id: ' || l_partner_id);
3972: fnd_msg_pub.Add;
3973: raise FND_API.G_EXC_ERROR;
3974:
3975: end if;
3976:

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

4030: context => l_context,
4031: send_comment => NULL,
4032: priority => NULL );
4033:
4034: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
4035: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
4036: fnd_message.Set_Token('TEXT', 'Sent notification to role: ' || l_adhoc_role ||
4037: ' using message: ' || l_msg_name || '. Notify id: ' || l_group_notify_id );
4038: fnd_msg_pub.Add;

Line 4038: fnd_msg_pub.Add;

4034: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
4035: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
4036: fnd_message.Set_Token('TEXT', 'Sent notification to role: ' || l_adhoc_role ||
4037: ' using message: ' || l_msg_name || '. Notify id: ' || l_group_notify_id );
4038: fnd_msg_pub.Add;
4039: end if;
4040:
4041: end if;
4042:

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

4072: end if; -- l_notify_enabled_flag
4073:
4074: else
4075:
4076: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
4077: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
4078: fnd_message.Set_Token('TEXT', 'Email is diabled at site level');
4079: fnd_msg_pub.Add;
4080: end if;

Line 4079: fnd_msg_pub.Add;

4075:
4076: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
4077: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
4078: fnd_message.Set_Token('TEXT', 'Email is diabled at site level');
4079: fnd_msg_pub.Add;
4080: end if;
4081:
4082: end if; --l_email_enabled_flag
4083:

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

4085: COMMIT WORK;
4086: END IF;
4087:
4088: -- Standard call to get message count and if count is 1, get message info.
4089: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
4090: p_count => x_msg_count,
4091: p_data => x_msg_data);
4092: EXCEPTION
4093:

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

4093:
4094: WHEN FND_API.G_EXC_ERROR THEN
4095:
4096: x_return_status := FND_API.G_RET_STS_ERROR ;
4097: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
4098: p_count => x_msg_count,
4099: p_data => x_msg_data);
4100:
4101: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

4100:
4101: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4102:
4103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4104: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
4105: p_count => x_msg_count,
4106: p_data => x_msg_data);
4107:
4108: WHEN OTHERS THEN

Line 4112: fnd_msg_pub.Add;

4108: WHEN OTHERS THEN
4109: IF sqlcode = -20002 THEN
4110:
4111: fnd_message.Set_Name('PV', 'PV_WF_COMP_ACTY_ERR');
4112: fnd_msg_pub.Add;
4113:
4114: ELSE
4115:
4116: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

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

4112: fnd_msg_pub.Add;
4113:
4114: ELSE
4115:
4116: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
4117:
4118: END IF;
4119:
4120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

4118: END IF;
4119:
4120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4121:
4122: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
4123: p_count => x_msg_count,
4124: p_data => x_msg_data);
4125:
4126: end send_notification;

Line 4166: fnd_msg_pub.initialize;

4162:
4163: -- Initialize message list if p_init_msg_list is set to TRUE.
4164: IF FND_API.to_Boolean( p_init_msg_list )
4165: THEN
4166: fnd_msg_pub.initialize;
4167: END IF;
4168:
4169: -- Debug Message
4170: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

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

4166: fnd_msg_pub.initialize;
4167: END IF;
4168:
4169: -- Debug Message
4170: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
4171: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
4172: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || '. Itemtype: ' || l_itemtype);
4173: fnd_msg_pub.Add;
4174: END IF;

Line 4173: fnd_msg_pub.Add;

4169: -- Debug Message
4170: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
4171: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
4172: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || '. Itemtype: ' || l_itemtype);
4173: fnd_msg_pub.Add;
4174: END IF;
4175:
4176: -- Initialize API return status to success
4177: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

4178:
4179: select pv_lead_workflows_s.nextval into l_itemkey from dual;
4180:
4181:
4182: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
4183: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
4184: fnd_message.Set_Token('TEXT', 'Before Creating the workflow process with Itemtype: ' || l_itemtype);
4185: fnd_msg_pub.Add;
4186: END IF;

Line 4185: fnd_msg_pub.Add;

4181:
4182: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
4183: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
4184: fnd_message.Set_Token('TEXT', 'Before Creating the workflow process with Itemtype: ' || l_itemtype);
4185: fnd_msg_pub.Add;
4186: END IF;
4187:
4188:
4189: wf_engine.CreateProcess ( ItemType => l_itemtype,

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

4270: COMMIT WORK;
4271: END IF;
4272:
4273: -- Standard call to get message count and if count is 1, get message info.
4274: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
4275: p_count => x_msg_count,
4276: p_data => x_msg_data);
4277: EXCEPTION
4278:

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

4278:
4279: WHEN FND_API.G_EXC_ERROR THEN
4280:
4281: x_return_status := FND_API.G_RET_STS_ERROR ;
4282: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
4283: p_count => x_msg_count,
4284: p_data => x_msg_data);
4285:
4286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

4285:
4286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4287:
4288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4289: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
4290: p_count => x_msg_count,
4291: p_data => x_msg_data);
4292:
4293: WHEN OTHERS THEN

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

4292:
4293: WHEN OTHERS THEN
4294:
4295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4296: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
4297: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
4298: p_count => x_msg_count,
4299: p_data => x_msg_data);
4300: end AbandonWorkflow;

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

4293: WHEN OTHERS THEN
4294:
4295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4296: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
4297: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
4298: p_count => x_msg_count,
4299: p_data => x_msg_data);
4300: end AbandonWorkflow;
4301:

Line 4326: FND_MSG_PUB.Add;

4322:
4323: BEGIN
4324: FND_MESSAGE.Set_Name('PV', 'PV_DEBUG_MESSAGE');
4325: FND_MESSAGE.Set_Token('TEXT', p_msg_string);
4326: FND_MSG_PUB.Add;
4327: END Debug;
4328: -- =================================End of Debug================================
4329:
4330:

Line 4358: IF FND_MSG_PUB.Check_Msg_Level(p_msg_level) THEN

4354: p_token3_value IN VARCHAR2 := NULL
4355: )
4356: IS
4357: BEGIN
4358: IF FND_MSG_PUB.Check_Msg_Level(p_msg_level) THEN
4359: FND_MESSAGE.Set_Name('PV', p_msg_name);
4360: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
4361:
4362: IF (p_token2 IS NOT NULL) THEN

Line 4370: FND_MSG_PUB.Add;

4366: IF (p_token3 IS NOT NULL) THEN
4367: FND_MESSAGE.Set_Token(p_token3, p_token3_value);
4368: END IF;
4369:
4370: FND_MSG_PUB.Add;
4371: END IF;
4372: END Set_Message;
4373: -- ==============================End of Set_Message==============================
4374: