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_ASSIGN_UTIL_PVT dependencies on FND_MESSAGE

Line 111: fnd_message.SET_NAME('PV', 'PV_DEBUG_MESSAGE');

107: END IF;
108:
109: -- Debug Message
110: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
111: fnd_message.SET_NAME('PV', 'PV_DEBUG_MESSAGE');
112: fnd_message.Set_token('TEXT', 'In ' || l_api_name);
113: fnd_msg_pub.Add;
114: END IF;
115:

Line 112: fnd_message.Set_token('TEXT', 'In ' || l_api_name);

108:
109: -- Debug Message
110: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
111: fnd_message.SET_NAME('PV', 'PV_DEBUG_MESSAGE');
112: fnd_message.Set_token('TEXT', 'In ' || l_api_name);
113: fnd_msg_pub.Add;
114: END IF;
115:
116: x_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 223: fnd_message.SET_NAME('PV', 'PV_DEBUG_MESSAGE');

219: END IF;
220:
221: -- Debug Message
222: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
223: fnd_message.SET_NAME('PV', 'PV_DEBUG_MESSAGE');
224: fnd_message.Set_token('TEXT', 'In ' || l_api_name);
225: fnd_msg_pub.Add;
226: END IF;
227:

Line 224: fnd_message.Set_token('TEXT', 'In ' || l_api_name);

220:
221: -- Debug Message
222: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
223: fnd_message.SET_NAME('PV', 'PV_DEBUG_MESSAGE');
224: fnd_message.Set_token('TEXT', 'In ' || l_api_name);
225: fnd_msg_pub.Add;
226: END IF;
227:
228: x_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 262: fnd_message.SET_NAME('PV', 'PV_DEBUG_MESSAGE');

258: end if;
259:
260: if l_message_name is not null then
261: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
262: fnd_message.SET_NAME('PV', 'PV_DEBUG_MESSAGE');
263: fnd_message.Set_token('TEXT', 'Logging routing message: ' || l_message_name ||
264: ' for lead_id:' || p_assignment_rec.lead_id || ' for partner_id:' || p_assignment_rec.partner_id);
265: fnd_msg_pub.Add;
266: END IF;

Line 263: fnd_message.Set_token('TEXT', 'Logging routing message: ' || l_message_name ||

259:
260: if l_message_name is not null then
261: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
262: fnd_message.SET_NAME('PV', 'PV_DEBUG_MESSAGE');
263: fnd_message.Set_token('TEXT', 'Logging routing message: ' || l_message_name ||
264: ' for lead_id:' || p_assignment_rec.lead_id || ' for partner_id:' || p_assignment_rec.partner_id);
265: fnd_msg_pub.Add;
266: END IF;
267:

Line 359: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

355: END IF;
356:
357: -- Debug Message
358: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
359: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
360: fnd_message.Set_Token('TEXT', 'In ' || l_api_name);
361: fnd_msg_pub.Add;
362: END IF;
363:

Line 360: fnd_message.Set_Token('TEXT', 'In ' || l_api_name);

356:
357: -- Debug Message
358: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
359: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
360: fnd_message.Set_Token('TEXT', 'In ' || l_api_name);
361: fnd_msg_pub.Add;
362: END IF;
363:
364: -- Initialize API return status to SUCCESS

Line 536: fnd_message.SET_NAME('PV', 'PV_DEBUG_MESSAGE');

532: END IF;
533:
534: -- Debug Message
535: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
536: fnd_message.SET_NAME('PV', 'PV_DEBUG_MESSAGE');
537: fnd_message.Set_token('TEXT', 'In ' || l_api_name);
538: fnd_msg_pub.Add;
539: END IF;
540:

Line 537: fnd_message.Set_token('TEXT', 'In ' || l_api_name);

533:
534: -- Debug Message
535: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
536: fnd_message.SET_NAME('PV', 'PV_DEBUG_MESSAGE');
537: fnd_message.Set_token('TEXT', 'In ' || l_api_name);
538: fnd_msg_pub.Add;
539: END IF;
540:
541: x_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 544: fnd_message.SET_NAME('PV', 'PV_INVALID_SOURCE_TYPE');

540:
541: x_return_status := FND_API.G_RET_STS_SUCCESS ;
542:
543: if p_assignment_rec.SOURCE_TYPE not in ('CAMPAIGN', 'MATCHING', 'TAP', 'SALESTEAM') then
544: fnd_message.SET_NAME('PV', 'PV_INVALID_SOURCE_TYPE');
545: fnd_msg_pub.ADD;
546:
547: raise FND_API.G_EXC_ERROR;
548: end if;

Line 554: fnd_message.SET_NAME('PV', 'PV_DEBUG_MESSAGE');

550: select pv_lead_assignments_s.nextval into l_Lead_assignment_ID from sys.dual;
551:
552: -- Debug Message
553: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
554: fnd_message.SET_NAME('PV', 'PV_DEBUG_MESSAGE');
555: fnd_message.Set_token('TEXT', 'p_assignment_rec.wf_item_type ' || p_assignment_rec.wf_item_type||
556: 'p_assignment_rec.wf_item_key ' || p_assignment_rec.wf_item_key||
557: 'p_assignment_rec.lead_id ' || p_assignment_rec.lead_id||
558: 'p_assignment_rec.partner_id ' || p_assignment_rec.partner_id);

Line 555: fnd_message.Set_token('TEXT', 'p_assignment_rec.wf_item_type ' || p_assignment_rec.wf_item_type||

551:
552: -- Debug Message
553: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
554: fnd_message.SET_NAME('PV', 'PV_DEBUG_MESSAGE');
555: fnd_message.Set_token('TEXT', 'p_assignment_rec.wf_item_type ' || p_assignment_rec.wf_item_type||
556: 'p_assignment_rec.wf_item_key ' || p_assignment_rec.wf_item_key||
557: 'p_assignment_rec.lead_id ' || p_assignment_rec.lead_id||
558: 'p_assignment_rec.partner_id ' || p_assignment_rec.partner_id);
559: fnd_msg_pub.Add;

Line 632: fnd_message.SET_NAME('PV', 'PV_DEBUG_MESSAGE');

628:
629: x_lead_assignment_id := l_lead_assignment_id;
630:
631: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
632: fnd_message.SET_NAME('PV', 'PV_DEBUG_MESSAGE');
633: fnd_message.Set_token('TEXT', 'x_lead_assignment_id ' || x_lead_assignment_id);
634: fnd_msg_pub.Add;
635: END IF;
636:

Line 633: fnd_message.Set_token('TEXT', 'x_lead_assignment_id ' || x_lead_assignment_id);

629: x_lead_assignment_id := l_lead_assignment_id;
630:
631: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
632: fnd_message.SET_NAME('PV', 'PV_DEBUG_MESSAGE');
633: fnd_message.Set_token('TEXT', 'x_lead_assignment_id ' || x_lead_assignment_id);
634: fnd_msg_pub.Add;
635: END IF;
636:
637: IF FND_API.To_Boolean ( p_commit ) THEN

Line 717: fnd_message.SET_NAME('PV', 'PV_DEBUG_MESSAGE');

713: END IF;
714:
715: -- Debug Message
716: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
717: fnd_message.SET_NAME('PV', 'PV_DEBUG_MESSAGE');
718: fnd_message.Set_token('TEXT', 'In ' || l_api_name);
719: fnd_msg_pub.Add;
720: END IF;
721:

Line 718: fnd_message.Set_token('TEXT', 'In ' || l_api_name);

714:
715: -- Debug Message
716: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
717: fnd_message.SET_NAME('PV', 'PV_DEBUG_MESSAGE');
718: fnd_message.Set_token('TEXT', 'In ' || l_api_name);
719: fnd_msg_pub.Add;
720: END IF;
721:
722: x_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 773: fnd_message.SET_NAME('PV', 'PV_DEBUG_MESSAGE');

769:
770: x_itemkey := to_char(l_lead_workflow_id);
771:
772: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
773: fnd_message.SET_NAME('PV', 'PV_DEBUG_MESSAGE');
774: fnd_message.Set_token('TEXT', 'Row created in pv_lead_workflows ');
775: fnd_msg_pub.Add;
776: END IF;
777:

Line 774: fnd_message.Set_token('TEXT', 'Row created in pv_lead_workflows ');

770: x_itemkey := to_char(l_lead_workflow_id);
771:
772: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
773: fnd_message.SET_NAME('PV', 'PV_DEBUG_MESSAGE');
774: fnd_message.Set_token('TEXT', 'Row created in pv_lead_workflows ');
775: fnd_msg_pub.Add;
776: END IF;
777:
778: IF p_workflow_rec.routing_status = PV_ASSIGNMENT_PUB.g_r_status_failed_auto THEN

Line 781: fnd_message.SET_NAME('PV', 'PV_DEBUG_MESSAGE');

777:
778: IF p_workflow_rec.routing_status = PV_ASSIGNMENT_PUB.g_r_status_failed_auto THEN
779:
780: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
781: fnd_message.SET_NAME('PV', 'PV_DEBUG_MESSAGE');
782: fnd_message.Set_token('TEXT', 'Logging in routing history'||p_workflow_rec.routing_type);
783: fnd_msg_pub.Add;
784: END IF;
785: l_user_id := nvl(p_workflow_rec.last_updated_by, fnd_global.user_id);

Line 782: fnd_message.Set_token('TEXT', 'Logging in routing history'||p_workflow_rec.routing_type);

778: IF p_workflow_rec.routing_status = PV_ASSIGNMENT_PUB.g_r_status_failed_auto THEN
779:
780: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
781: fnd_message.SET_NAME('PV', 'PV_DEBUG_MESSAGE');
782: fnd_message.Set_token('TEXT', 'Logging in routing history'||p_workflow_rec.routing_type);
783: fnd_msg_pub.Add;
784: END IF;
785: l_user_id := nvl(p_workflow_rec.last_updated_by, fnd_global.user_id);
786:

Line 799: fnd_message.SET_NAME('PV', 'PV_DEBUG_MESSAGE');

795: l_oppty_routing_log_rec.vendor_user_id := NULL;
796: l_oppty_routing_log_rec.pt_contact_user_id := l_user_id;
797: END IF;
798: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
799: fnd_message.SET_NAME('PV', 'PV_DEBUG_MESSAGE');
800: fnd_message.Set_token('TEXT', 'Logging in routing history 2');
801: fnd_msg_pub.Add;
802: END IF;
803:

Line 800: fnd_message.Set_token('TEXT', 'Logging in routing history 2');

796: l_oppty_routing_log_rec.pt_contact_user_id := l_user_id;
797: END IF;
798: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
799: fnd_message.SET_NAME('PV', 'PV_DEBUG_MESSAGE');
800: fnd_message.Set_token('TEXT', 'Logging in routing history 2');
801: fnd_msg_pub.Add;
802: END IF;
803:
804: l_oppty_routing_log_rec.event := 'ASSIGN_FAIL';

Line 817: fnd_message.SET_NAME('PV', 'PV_DEBUG_MESSAGE');

813: l_oppty_routing_log_rec.reason_code := p_workflow_rec.failure_code;
814: l_oppty_routing_log_rec.user_type := 'LAM';
815:
816: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
817: fnd_message.SET_NAME('PV', 'PV_DEBUG_MESSAGE');
818: fnd_message.Set_token('TEXT', 'Logging in routing history 3');
819: fnd_msg_pub.Add;
820: END IF;
821: pv_assignment_pvt.Create_Oppty_Routing_Log_Row (

Line 818: fnd_message.Set_token('TEXT', 'Logging in routing history 3');

814: l_oppty_routing_log_rec.user_type := 'LAM';
815:
816: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
817: fnd_message.SET_NAME('PV', 'PV_DEBUG_MESSAGE');
818: fnd_message.Set_token('TEXT', 'Logging in routing history 3');
819: fnd_msg_pub.Add;
820: END IF;
821: pv_assignment_pvt.Create_Oppty_Routing_Log_Row (
822: p_api_version_number => 1.0,

Line 898: fnd_message.SET_NAME('PV', 'PV_DEBUG_MESSAGE');

894: END IF;
895:
896: -- Debug Message
897: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
898: fnd_message.SET_NAME('PV', 'PV_DEBUG_MESSAGE');
899: fnd_message.Set_token('TEXT', 'In ' || l_api_name);
900: fnd_msg_pub.Add;
901: END IF;
902:

Line 899: fnd_message.Set_token('TEXT', 'In ' || l_api_name);

895:
896: -- Debug Message
897: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
898: fnd_message.SET_NAME('PV', 'PV_DEBUG_MESSAGE');
899: fnd_message.Set_token('TEXT', 'In ' || l_api_name);
900: fnd_msg_pub.Add;
901: END IF;
902:
903: x_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 915: fnd_message.SET_NAME('PV', 'PV_DEBUG_MESSAGE');

911: -- routing completed and this API
912: -- was called to delete the saved partner list before invoking the createAssignment API
913: -- Do not raise an exception in this case. Bug 3088598
914:
915: fnd_message.SET_NAME('PV', 'PV_DEBUG_MESSAGE');
916: fnd_message.SET_token('TEXT', 'Deleted ' || sql%rowcount || ' rows. Should have deleted 1 row');
917: fnd_msg_pub.ADD;
918:
919: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 916: fnd_message.SET_token('TEXT', 'Deleted ' || sql%rowcount || ' rows. Should have deleted 1 row');

912: -- was called to delete the saved partner list before invoking the createAssignment API
913: -- Do not raise an exception in this case. Bug 3088598
914:
915: fnd_message.SET_NAME('PV', 'PV_DEBUG_MESSAGE');
916: fnd_message.SET_token('TEXT', 'Deleted ' || sql%rowcount || ' rows. Should have deleted 1 row');
917: fnd_msg_pub.ADD;
918:
919: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
920:

Line 1208: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

1204: END IF;
1205:
1206: -- Debug Message
1207: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1208: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1209: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || '. Partner id: ' || p_partner_id || '. Mode: ' || p_mode);
1210: fnd_msg_pub.Add;
1211: END IF;
1212:

Line 1209: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || '. Partner id: ' || p_partner_id || '. Mode: ' || p_mode);

1205:
1206: -- Debug Message
1207: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1208: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1209: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || '. Partner id: ' || p_partner_id || '. Mode: ' || p_mode);
1210: fnd_msg_pub.Add;
1211: END IF;
1212:
1213: -- Initialize API return status to success

Line 1225: fnd_message.SET_NAME('PV', 'PV_BAD_ID');

1221: close lc_id_type;
1222:
1223: if l_id_name is null then
1224:
1225: fnd_message.SET_NAME('PV', 'PV_BAD_ID');
1226: fnd_message.SET_TOKEN('ID' ,p_partner_id);
1227:
1228: fnd_msg_pub.ADD;
1229: raise FND_API.G_EXC_ERROR;

Line 1226: fnd_message.SET_TOKEN('ID' ,p_partner_id);

1222:
1223: if l_id_name is null then
1224:
1225: fnd_message.SET_NAME('PV', 'PV_BAD_ID');
1226: fnd_message.SET_TOKEN('ID' ,p_partner_id);
1227:
1228: fnd_msg_pub.ADD;
1229: raise FND_API.G_EXC_ERROR;
1230:

Line 1239: fnd_message.SET_NAME('PV', 'PV_INVALID_PARTY_TYPE');

1235: -- this means that you cannot match a partner who is not PARTNER_OF
1236: -- every indirectly managed partner will have a PARTNER_OF directly with the vendor
1237: -- the user is only allowed to pick the PARTNER_OF instead of the CUSTOMER_INDIRECTLY_MANAGED_BY relationship
1238:
1239: fnd_message.SET_NAME('PV', 'PV_INVALID_PARTY_TYPE');
1240: fnd_message.SET_TOKEN('PARTY_NAME', l_id_name);
1241: fnd_message.SET_TOKEN('RELATION_TYPE', l_id_type_meaning);
1242:
1243: fnd_msg_pub.ADD;

Line 1240: fnd_message.SET_TOKEN('PARTY_NAME', l_id_name);

1236: -- every indirectly managed partner will have a PARTNER_OF directly with the vendor
1237: -- the user is only allowed to pick the PARTNER_OF instead of the CUSTOMER_INDIRECTLY_MANAGED_BY relationship
1238:
1239: fnd_message.SET_NAME('PV', 'PV_INVALID_PARTY_TYPE');
1240: fnd_message.SET_TOKEN('PARTY_NAME', l_id_name);
1241: fnd_message.SET_TOKEN('RELATION_TYPE', l_id_type_meaning);
1242:
1243: fnd_msg_pub.ADD;
1244: raise FND_API.G_EXC_ERROR;

Line 1241: fnd_message.SET_TOKEN('RELATION_TYPE', l_id_type_meaning);

1237: -- the user is only allowed to pick the PARTNER_OF instead of the CUSTOMER_INDIRECTLY_MANAGED_BY relationship
1238:
1239: fnd_message.SET_NAME('PV', 'PV_INVALID_PARTY_TYPE');
1240: fnd_message.SET_TOKEN('PARTY_NAME', l_id_name);
1241: fnd_message.SET_TOKEN('RELATION_TYPE', l_id_type_meaning);
1242:
1243: fnd_msg_pub.ADD;
1244: raise FND_API.G_EXC_ERROR;
1245:

Line 1258: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

1254: for l_rs_rec in lc_get_ext_cms(pc_partner_id => p_partner_id, pc_vad_id => x_vad_id)
1255: loop
1256:
1257: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1258: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1259: fnd_message.Set_Token('TEXT', 'CM rs id: ' || l_rs_rec.rs_id || ' from ' || l_rs_rec .origin);
1260: fnd_msg_pub.Add;
1261: END IF;
1262:

Line 1259: fnd_message.Set_Token('TEXT', 'CM rs id: ' || l_rs_rec.rs_id || ' from ' || l_rs_rec .origin);

1255: loop
1256:
1257: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1258: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1259: fnd_message.Set_Token('TEXT', 'CM rs id: ' || l_rs_rec.rs_id || ' from ' || l_rs_rec .origin);
1260: fnd_msg_pub.Add;
1261: END IF;
1262:
1263: if instr(l_all_cm_rs_id, ' ' || l_rs_rec.rs_id || ' ') = 0 then

Line 1274: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

1270: l_cm_origin_tbl(l_cm_origin_tbl.last) := l_rs_rec.origin;
1271:
1272: else
1273: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1274: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1275: fnd_message.Set_Token('TEXT', 'cm resource id: ' || l_rs_rec.rs_id || ' already selected' );
1276: fnd_msg_pub.Add;
1277: END IF;
1278: end if;

Line 1275: fnd_message.Set_Token('TEXT', 'cm resource id: ' || l_rs_rec.rs_id || ' already selected' );

1271:
1272: else
1273: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1274: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1275: fnd_message.Set_Token('TEXT', 'cm resource id: ' || l_rs_rec.rs_id || ' already selected' );
1276: fnd_msg_pub.Add;
1277: END IF;
1278: end if;
1279:

Line 1288: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

1284: for l_rs_rec in lc_get_int_cms(pc_partner_id => p_partner_id)
1285: loop
1286:
1287: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1288: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1289: fnd_message.Set_Token('TEXT', 'CM rs id: ' || l_rs_rec.rs_id || ' from ' || l_rs_rec .origin);
1290: fnd_msg_pub.Add;
1291: END IF;
1292:

Line 1289: fnd_message.Set_Token('TEXT', 'CM rs id: ' || l_rs_rec.rs_id || ' from ' || l_rs_rec .origin);

1285: loop
1286:
1287: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1288: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1289: fnd_message.Set_Token('TEXT', 'CM rs id: ' || l_rs_rec.rs_id || ' from ' || l_rs_rec .origin);
1290: fnd_msg_pub.Add;
1291: END IF;
1292:
1293: if instr(l_all_cm_rs_id, ' ' || l_rs_rec.rs_id || ' ') = 0 then

Line 1304: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

1300: l_cm_origin_tbl(l_cm_origin_tbl.last) := l_rs_rec.origin;
1301:
1302: else
1303: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1304: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1305: fnd_message.Set_Token('TEXT', 'cm resource id: ' || l_rs_rec.rs_id || ' already selected' );
1306: fnd_msg_pub.Add;
1307: END IF;
1308: end if;

Line 1305: fnd_message.Set_Token('TEXT', 'cm resource id: ' || l_rs_rec.rs_id || ' already selected' );

1301:
1302: else
1303: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1304: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1305: fnd_message.Set_Token('TEXT', 'cm resource id: ' || l_rs_rec.rs_id || ' already selected' );
1306: fnd_msg_pub.Add;
1307: END IF;
1308: end if;
1309:

Line 1316: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

1312:
1313: if l_cm_rs_id_tbl.count = 0 then
1314:
1315: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1316: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1317: fnd_message.Set_Token('TEXT', 'No CM found in PARTNER TEAM, Trying PV_DEFAULT_CM');
1318: fnd_msg_pub.Add;
1319: END IF;
1320:

Line 1317: fnd_message.Set_Token('TEXT', 'No CM found in PARTNER TEAM, Trying PV_DEFAULT_CM');

1313: if l_cm_rs_id_tbl.count = 0 then
1314:
1315: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1316: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1317: fnd_message.Set_Token('TEXT', 'No CM found in PARTNER TEAM, Trying PV_DEFAULT_CM');
1318: fnd_msg_pub.Add;
1319: END IF;
1320:
1321: -- no cm found. Look for default cm from profile

Line 1331: fnd_message.SET_NAME('PV', 'PV_NO_CM_FOR_PT');

1327: close lc_get_default_cm;
1328:
1329: if l_rs_id is null then
1330:
1331: fnd_message.SET_NAME('PV', 'PV_NO_CM_FOR_PT');
1332: fnd_message.SET_TOKEN('P_PARTNER' ,l_id_name);
1333:
1334: fnd_msg_pub.ADD;
1335: raise FND_API.G_EXC_ERROR;

Line 1332: fnd_message.SET_TOKEN('P_PARTNER' ,l_id_name);

1328:
1329: if l_rs_id is null then
1330:
1331: fnd_message.SET_NAME('PV', 'PV_NO_CM_FOR_PT');
1332: fnd_message.SET_TOKEN('P_PARTNER' ,l_id_name);
1333:
1334: fnd_msg_pub.ADD;
1335: raise FND_API.G_EXC_ERROR;
1336:

Line 1351: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

1347:
1348: for i in 1 .. l_cm_rs_id_tbl.count loop
1349:
1350: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1351: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1352: fnd_message.Set_Token('TEXT', 'Validating cm rs id: ' || l_cm_rs_id_tbl(i));
1353: fnd_msg_pub.Add;
1354: END IF;
1355:

Line 1352: fnd_message.Set_Token('TEXT', 'Validating cm rs id: ' || l_cm_rs_id_tbl(i));

1348: for i in 1 .. l_cm_rs_id_tbl.count loop
1349:
1350: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1351: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1352: fnd_message.Set_Token('TEXT', 'Validating cm rs id: ' || l_cm_rs_id_tbl(i));
1353: fnd_msg_pub.Add;
1354: END IF;
1355:
1356: l_rs_id := null;

Line 1364: fnd_message.SET_NAME('PV', 'PV_CM_INVALID_RESOURCE_ID');

1360: close lc_get_person_details;
1361:
1362: if l_rs_id is null then
1363:
1364: fnd_message.SET_NAME('PV', 'PV_CM_INVALID_RESOURCE_ID');
1365: fnd_message.SET_TOKEN('P_RESOURCE_ID' ,l_cm_rs_id_tbl(i));
1366: fnd_msg_pub.ADD;
1367: l_pt_ok_flag := false;
1368:

Line 1365: fnd_message.SET_TOKEN('P_RESOURCE_ID' ,l_cm_rs_id_tbl(i));

1361:
1362: if l_rs_id is null then
1363:
1364: fnd_message.SET_NAME('PV', 'PV_CM_INVALID_RESOURCE_ID');
1365: fnd_message.SET_TOKEN('P_RESOURCE_ID' ,l_cm_rs_id_tbl(i));
1366: fnd_msg_pub.ADD;
1367: l_pt_ok_flag := false;
1368:
1369: elsif l_fnd_username is null then

Line 1371: fnd_message.SET_NAME('PV', 'PV_NO_LOGON_ACCT');

1367: l_pt_ok_flag := false;
1368:
1369: elsif l_fnd_username is null then
1370:
1371: fnd_message.SET_NAME('PV', 'PV_NO_LOGON_ACCT');
1372: fnd_message.SET_TOKEN('P_USER' ,l_person_name);
1373: fnd_msg_pub.ADD;
1374: l_pt_ok_flag := false;
1375:

Line 1372: fnd_message.SET_TOKEN('P_USER' ,l_person_name);

1368:
1369: elsif l_fnd_username is null then
1370:
1371: fnd_message.SET_NAME('PV', 'PV_NO_LOGON_ACCT');
1372: fnd_message.SET_TOKEN('P_USER' ,l_person_name);
1373: fnd_msg_pub.ADD;
1374: l_pt_ok_flag := false;
1375:
1376: end if;

Line 1414: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

1410:
1411: end loop;
1412:
1413: if p_retrieve_mode in ('BOTH','CM') and fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1414: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1415: fnd_message.Set_Token('TEXT', 'CMs found: ' || l_cm_rs_id_tbl.count);
1416: fnd_msg_pub.Add;
1417: END IF;
1418:

Line 1415: fnd_message.Set_Token('TEXT', 'CMs found: ' || l_cm_rs_id_tbl.count);

1411: end loop;
1412:
1413: if p_retrieve_mode in ('BOTH','CM') and fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1414: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1415: fnd_message.Set_Token('TEXT', 'CMs found: ' || l_cm_rs_id_tbl.count);
1416: fnd_msg_pub.Add;
1417: END IF;
1418:
1419: if p_entity in ('LEAD','OPPORTUNITY') then

Line 1437: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

1433: end loop;
1434: close lc_preferred_pt_contact;
1435:
1436: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1437: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1438: fnd_message.Set_Token('TEXT', 'No. of pt contacts found in oppty salesteam: ' || l_pt_user_rs_id_tbl.count);
1439: fnd_msg_pub.Add;
1440: END IF;
1441:

Line 1438: fnd_message.Set_Token('TEXT', 'No. of pt contacts found in oppty salesteam: ' || l_pt_user_rs_id_tbl.count);

1434: close lc_preferred_pt_contact;
1435:
1436: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1437: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1438: fnd_message.Set_Token('TEXT', 'No. of pt contacts found in oppty salesteam: ' || l_pt_user_rs_id_tbl.count);
1439: fnd_msg_pub.Add;
1440: END IF;
1441:
1442: for i in 1 .. l_pt_user_rs_id_tbl.count loop

Line 1458: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

1454: end loop;
1455: close lc_get_default_pt_contact;
1456:
1457: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1458: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1459: fnd_message.Set_Token('TEXT', 'No. of pt contacts with PV_OPPTY_CONTACT permission that has resource and' ||
1460: ' Valid login : ' || l_pt_default_rs_id_tbl.count);
1461: fnd_msg_pub.Add;
1462: END IF;

Line 1459: fnd_message.Set_Token('TEXT', 'No. of pt contacts with PV_OPPTY_CONTACT permission that has resource and' ||

1455: close lc_get_default_pt_contact;
1456:
1457: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1458: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1459: fnd_message.Set_Token('TEXT', 'No. of pt contacts with PV_OPPTY_CONTACT permission that has resource and' ||
1460: ' Valid login : ' || l_pt_default_rs_id_tbl.count);
1461: fnd_msg_pub.Add;
1462: END IF;
1463:

Line 1468: fnd_message.SET_NAME('PV', 'PV_NO_CNTCT_FOR_PT');

1464: if l_pt_user_rs_id_tbl.count = 0 and l_pt_default_rs_id_tbl.count = 0 then
1465:
1466: -- no partner contacts found
1467:
1468: fnd_message.SET_NAME('PV', 'PV_NO_CNTCT_FOR_PT');
1469: fnd_message.SET_TOKEN('P_PARTNER' , l_id_name);
1470: fnd_msg_pub.ADD;
1471: l_pt_ok_flag := false;
1472:

Line 1469: fnd_message.SET_TOKEN('P_PARTNER' , l_id_name);

1465:
1466: -- no partner contacts found
1467:
1468: fnd_message.SET_NAME('PV', 'PV_NO_CNTCT_FOR_PT');
1469: fnd_message.SET_TOKEN('P_PARTNER' , l_id_name);
1470: fnd_msg_pub.ADD;
1471: l_pt_ok_flag := false;
1472:
1473: end if;

Line 1487: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

1483:
1484: else
1485:
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', 'Default contact: resource id already there: '||l_pt_default_rs_id_tbl(i));
1489: fnd_msg_pub.Add;
1490: END IF;
1491:

Line 1488: fnd_message.Set_Token('TEXT', 'Default contact: resource id already there: '||l_pt_default_rs_id_tbl(i));

1484: else
1485:
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', 'Default contact: resource id already there: '||l_pt_default_rs_id_tbl(i));
1489: fnd_msg_pub.Add;
1490: END IF;
1491:
1492: end if;

Line 1501: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

1497:
1498: l_rs_id := null;
1499:
1500: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1501: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1502: fnd_message.Set_Token('TEXT', 'before retrieving the person details '|| l_pt_user_rs_id_tbl(i));
1503: fnd_msg_pub.Add;
1504: END IF;
1505:

Line 1502: fnd_message.Set_Token('TEXT', 'before retrieving the person details '|| l_pt_user_rs_id_tbl(i));

1498: l_rs_id := null;
1499:
1500: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1501: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1502: fnd_message.Set_Token('TEXT', 'before retrieving the person details '|| l_pt_user_rs_id_tbl(i));
1503: fnd_msg_pub.Add;
1504: END IF;
1505:
1506: open lc_get_person_details (pc_rs_id => l_pt_user_rs_id_tbl(i) );

Line 1511: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

1507: fetch lc_get_person_details into l_rs_id, l_usertype, l_person_id, l_person_name, l_fnd_user_id, l_fnd_username;
1508: close lc_get_person_details;
1509:
1510: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1511: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1512: fnd_message.Set_Token('TEXT', 'Resource ID '||l_rs_id ||' '||l_person_name||' '|| l_fnd_username );
1513: fnd_msg_pub.Add;
1514: END IF;
1515: if l_fnd_username is null then

Line 1512: fnd_message.Set_Token('TEXT', 'Resource ID '||l_rs_id ||' '||l_person_name||' '|| l_fnd_username );

1508: close lc_get_person_details;
1509:
1510: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1511: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1512: fnd_message.Set_Token('TEXT', 'Resource ID '||l_rs_id ||' '||l_person_name||' '|| l_fnd_username );
1513: fnd_msg_pub.Add;
1514: END IF;
1515: if l_fnd_username is null then
1516:

Line 1517: fnd_message.SET_NAME('PV', 'PV_PT_CONTACT_NO_LOGON');

1513: fnd_msg_pub.Add;
1514: END IF;
1515: if l_fnd_username is null then
1516:
1517: fnd_message.SET_NAME('PV', 'PV_PT_CONTACT_NO_LOGON');
1518: fnd_message.SET_TOKEN('P_PT_RESOURCE_ID' ,l_pt_user_rs_id_tbl(i));
1519: fnd_msg_pub.ADD;
1520: -- l_pt_ok_flag := false;
1521:

Line 1518: fnd_message.SET_TOKEN('P_PT_RESOURCE_ID' ,l_pt_user_rs_id_tbl(i));

1514: END IF;
1515: if l_fnd_username is null then
1516:
1517: fnd_message.SET_NAME('PV', 'PV_PT_CONTACT_NO_LOGON');
1518: fnd_message.SET_TOKEN('P_PT_RESOURCE_ID' ,l_pt_user_rs_id_tbl(i));
1519: fnd_msg_pub.ADD;
1520: -- l_pt_ok_flag := false;
1521:
1522: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

Line 1523: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

1519: fnd_msg_pub.ADD;
1520: -- l_pt_ok_flag := false;
1521:
1522: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1523: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1524: fnd_message.Set_Token('TEXT', 'Resource ID '||l_pt_user_rs_id_tbl(i) ||
1525: ' set to zero since the partner contact does not have login' );
1526: fnd_msg_pub.Add;
1527: END IF;

Line 1524: fnd_message.Set_Token('TEXT', 'Resource ID '||l_pt_user_rs_id_tbl(i) ||

1520: -- l_pt_ok_flag := false;
1521:
1522: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1523: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1524: fnd_message.Set_Token('TEXT', 'Resource ID '||l_pt_user_rs_id_tbl(i) ||
1525: ' set to zero since the partner contact does not have login' );
1526: fnd_msg_pub.Add;
1527: END IF;
1528:

Line 1555: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

1551: end loop;
1552:
1553: IF l_pt_user_rs_id_tbl.count > 0 THEN
1554: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1555: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1556: fnd_message.Set_Token('TEXT', 'There are '||l_pt_user_rs_id_tbl.count || ' contacts found for partner '||
1557: l_id_name);
1558: fnd_msg_pub.Add;
1559: END IF;

Line 1556: fnd_message.Set_Token('TEXT', 'There are '||l_pt_user_rs_id_tbl.count || ' contacts found for partner '||

1552:
1553: IF l_pt_user_rs_id_tbl.count > 0 THEN
1554: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1555: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1556: fnd_message.Set_Token('TEXT', 'There are '||l_pt_user_rs_id_tbl.count || ' contacts found for partner '||
1557: l_id_name);
1558: fnd_msg_pub.Add;
1559: END IF;
1560: ELSE

Line 1562: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

1558: fnd_msg_pub.Add;
1559: END IF;
1560: ELSE
1561: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1562: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1563: fnd_message.Set_Token('TEXT', 'No contacts found for partner '||l_id_name);
1564: fnd_msg_pub.Add;
1565: END IF;
1566: END IF;

Line 1563: fnd_message.Set_Token('TEXT', 'No contacts found for partner '||l_id_name);

1559: END IF;
1560: ELSE
1561: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1562: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1563: fnd_message.Set_Token('TEXT', 'No contacts found for partner '||l_id_name);
1564: fnd_msg_pub.Add;
1565: END IF;
1566: END IF;
1567:

Line 1839: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

1835:
1836: -- Debug Message
1837: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1838:
1839: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1840: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || ' for Lead id = ' || p_lead_id || '. Resource ID: ' || p_resource_id);
1841: fnd_msg_pub.Add;
1842:
1843: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

Line 1840: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || ' for Lead id = ' || p_lead_id || '. Resource ID: ' || p_resource_id);

1836: -- Debug Message
1837: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1838:
1839: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1840: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || ' for Lead id = ' || p_lead_id || '. Resource ID: ' || p_resource_id);
1841: fnd_msg_pub.Add;
1842:
1843: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1844: fnd_message.Set_Token('TEXT', 'p_access_type is: ' || p_access_type || ': p_access_action is :' || p_access_action || ' :');

Line 1843: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

1839: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1840: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || ' for Lead id = ' || p_lead_id || '. Resource ID: ' || p_resource_id);
1841: fnd_msg_pub.Add;
1842:
1843: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1844: fnd_message.Set_Token('TEXT', 'p_access_type is: ' || p_access_type || ': p_access_action is :' || p_access_action || ' :');
1845: fnd_msg_pub.Add;
1846:
1847:

Line 1844: fnd_message.Set_Token('TEXT', 'p_access_type is: ' || p_access_type || ': p_access_action is :' || p_access_action || ' :');

1840: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || ' for Lead id = ' || p_lead_id || '. Resource ID: ' || p_resource_id);
1841: fnd_msg_pub.Add;
1842:
1843: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1844: fnd_message.Set_Token('TEXT', 'p_access_type is: ' || p_access_type || ': p_access_action is :' || p_access_action || ' :');
1845: fnd_msg_pub.Add;
1846:
1847:
1848: select 'Access Type: '||decode(p_access_type, 1, 'CM', 2, 'PT', 3, 'PT ORG') ||

Line 1851: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

1847:
1848: select 'Access Type: '||decode(p_access_type, 1, 'CM', 2, 'PT', 3, 'PT ORG') ||
1849: ' Access Action: '||decode(p_access_action, 1, 'ADD', 2, 'REMOVE') into l_debug_string from dual;
1850:
1851: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1852: fnd_message.Set_Token('TEXT', l_debug_string);
1853: fnd_msg_pub.Add;
1854:
1855: END IF;

Line 1852: fnd_message.Set_Token('TEXT', l_debug_string);

1848: select 'Access Type: '||decode(p_access_type, 1, 'CM', 2, 'PT', 3, 'PT ORG') ||
1849: ' Access Action: '||decode(p_access_action, 1, 'ADD', 2, 'REMOVE') into l_debug_string from dual;
1850:
1851: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1852: fnd_message.Set_Token('TEXT', l_debug_string);
1853: fnd_msg_pub.Add;
1854:
1855: END IF;
1856:

Line 1889: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

1885: end if;
1886:
1887: -- Debug Message
1888: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1889: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1890:
1891: if l_access_exists_flag then
1892: fnd_message.Set_Token('TEXT', 'Access exist for ' || p_resource_id);
1893: else

Line 1892: fnd_message.Set_Token('TEXT', 'Access exist for ' || p_resource_id);

1888: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1889: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1890:
1891: if l_access_exists_flag then
1892: fnd_message.Set_Token('TEXT', 'Access exist for ' || p_resource_id);
1893: else
1894: fnd_message.Set_Token('TEXT', 'Access does not exist for ' || p_resource_id);
1895: end if;
1896:

Line 1894: fnd_message.Set_Token('TEXT', 'Access does not exist for ' || p_resource_id);

1890:
1891: if l_access_exists_flag then
1892: fnd_message.Set_Token('TEXT', 'Access exist for ' || p_resource_id);
1893: else
1894: fnd_message.Set_Token('TEXT', 'Access does not exist for ' || p_resource_id);
1895: end if;
1896:
1897: fnd_msg_pub.Add;
1898:

Line 1915: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

1911: elsif l_person_category = pv_assignment_pub.g_resource_party then
1912: l_pt_party_id := l_person_id;
1913:
1914: else
1915: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1916: fnd_message.SET_TOKEN('TEXT', 'Does not recognize person type: ' || l_person_category);
1917: fnd_msg_pub.ADD;
1918:
1919: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1916: fnd_message.SET_TOKEN('TEXT', 'Does not recognize person type: ' || l_person_category);

1912: l_pt_party_id := l_person_id;
1913:
1914: else
1915: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1916: fnd_message.SET_TOKEN('TEXT', 'Does not recognize person type: ' || l_person_category);
1917: fnd_msg_pub.ADD;
1918:
1919: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1920:

Line 1924: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

1920:
1921: end if;
1922:
1923: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1924: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1925: fnd_message.Set_token('TEXT', 'Person is a ' || l_person_category);
1926: fnd_msg_pub.Add;
1927: end if;
1928:

Line 1925: fnd_message.Set_token('TEXT', 'Person is a ' || l_person_category);

1921: end if;
1922:
1923: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1924: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1925: fnd_message.Set_token('TEXT', 'Person is a ' || l_person_category);
1926: fnd_msg_pub.Add;
1927: end if;
1928:
1929: elsif p_access_type = pv_assignment_pub.G_PT_ORG_ACCESS then

Line 1938: fnd_message.SET_NAME ('PV', 'PV_RESOURCE_NOT_FOUND');

1934: end if;
1935:
1936: if lc_cursor%NOTFOUND then
1937:
1938: fnd_message.SET_NAME ('PV', 'PV_RESOURCE_NOT_FOUND');
1939: fnd_message.SET_TOKEN ('P_RESOURCE_ID' , p_resource_id);
1940: fnd_msg_pub.ADD;
1941:
1942: RAISE fnd_api.g_exc_error;

Line 1939: fnd_message.SET_TOKEN ('P_RESOURCE_ID' , p_resource_id);

1935:
1936: if lc_cursor%NOTFOUND then
1937:
1938: fnd_message.SET_NAME ('PV', 'PV_RESOURCE_NOT_FOUND');
1939: fnd_message.SET_TOKEN ('P_RESOURCE_ID' , p_resource_id);
1940: fnd_msg_pub.ADD;
1941:
1942: RAISE fnd_api.g_exc_error;
1943:

Line 1965: fnd_message.SET_NAME ('PV', 'PV_NO_DEFAULT_SALESGROUP');

1961:
1962: if l_sales_group_id is NULL and p_access_type <> pv_assignment_pub.G_PT_ORG_ACCESS then
1963:
1964: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1965: fnd_message.SET_NAME ('PV', 'PV_NO_DEFAULT_SALESGROUP');
1966: fnd_message.SET_TOKEN ('P_USER' , l_username);
1967: fnd_msg_pub.ADD;
1968: end if;
1969: -- RAISE fnd_api.g_exc_error;

Line 1966: fnd_message.SET_TOKEN ('P_USER' , l_username);

1962: if l_sales_group_id is NULL and p_access_type <> pv_assignment_pub.G_PT_ORG_ACCESS then
1963:
1964: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1965: fnd_message.SET_NAME ('PV', 'PV_NO_DEFAULT_SALESGROUP');
1966: fnd_message.SET_TOKEN ('P_USER' , l_username);
1967: fnd_msg_pub.ADD;
1968: end if;
1969: -- RAISE fnd_api.g_exc_error;
1970:

Line 1994: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

1990: fetch lc_get_am_and_owner into l_am_rs_id, l_ld_owner_rs_id;
1991: close lc_get_am_and_owner;
1992:
1993: if l_am_rs_id is null then
1994: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1995: fnd_message.SET_TOKEN('TEXT', 'Cannot identify Assignment manager or Opportunity creator');
1996: fnd_msg_pub.ADD;
1997: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1998: end if;

Line 1995: fnd_message.SET_TOKEN('TEXT', 'Cannot identify Assignment manager or Opportunity creator');

1991: close lc_get_am_and_owner;
1992:
1993: if l_am_rs_id is null then
1994: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1995: fnd_message.SET_TOKEN('TEXT', 'Cannot identify Assignment manager or Opportunity creator');
1996: fnd_msg_pub.ADD;
1997: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1998: end if;
1999:

Line 2017: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

2013: (l_resoucre_nature= 'PART_OR_CONT')
2014: then -- means added by WF
2015:
2016: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2017: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2018: fnd_message.Set_token('TEXT', 'Removing Access for: ' || l_temp);
2019: fnd_msg_pub.Add;
2020: end if;
2021:

Line 2018: fnd_message.Set_token('TEXT', 'Removing Access for: ' || l_temp);

2014: then -- means added by WF
2015:
2016: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2017: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2018: fnd_message.Set_token('TEXT', 'Removing Access for: ' || l_temp);
2019: fnd_msg_pub.Add;
2020: end if;
2021:
2022: -- -------------------------------------------------------------------------------

Line 2104: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

2100: ELSE
2101: Debug('l_sales_credit_count is not 0');
2102:
2103: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2104: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2105: fnd_message.Set_token('TEXT', 'Do not remove for: ' || l_temp ||
2106: '. It still has some sales credits associated with it.');
2107: fnd_msg_pub.Add;
2108: END IF;

Line 2105: fnd_message.Set_token('TEXT', 'Do not remove for: ' || l_temp ||

2101: Debug('l_sales_credit_count is not 0');
2102:
2103: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2104: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2105: fnd_message.Set_token('TEXT', 'Do not remove for: ' || l_temp ||
2106: '. It still has some sales credits associated with it.');
2107: fnd_msg_pub.Add;
2108: END IF;
2109: END IF;

Line 2114: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

2110:
2111: else
2112: Debug('l_prm_keep_flag_tbl(i) is not Y') ;
2113: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2114: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2115: fnd_message.Set_token('TEXT', 'Do not remove for: ' || l_temp || '. Prm_keep_flag is not Y');
2116: fnd_msg_pub.Add;
2117: end if;
2118:

Line 2115: fnd_message.Set_token('TEXT', 'Do not remove for: ' || l_temp || '. Prm_keep_flag is not Y');

2111: else
2112: Debug('l_prm_keep_flag_tbl(i) is not Y') ;
2113: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2114: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2115: fnd_message.Set_token('TEXT', 'Do not remove for: ' || l_temp || '. Prm_keep_flag is not Y');
2116: fnd_msg_pub.Add;
2117: end if;
2118:
2119: end if;

Line 2138: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

2134: fetch lc_get_sql_text_attr_7 into l_sql_text_attr_7;
2135: close lc_get_sql_text_attr_7;
2136:
2137: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2138: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2139: fnd_message.Set_token('TEXT', ' SQL Text for attribute 7'|| l_sql_text_attr_7);
2140: fnd_msg_pub.Add;
2141: end if;
2142:

Line 2139: fnd_message.Set_token('TEXT', ' SQL Text for attribute 7'|| l_sql_text_attr_7);

2135: close lc_get_sql_text_attr_7;
2136:
2137: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2138: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2139: fnd_message.Set_token('TEXT', ' SQL Text for attribute 7'|| l_sql_text_attr_7);
2140: fnd_msg_pub.Add;
2141: end if;
2142:
2143:

Line 2147: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

2143:
2144: for i in 1 .. l_access_id_tbl.count loop
2145:
2146: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2147: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2148: fnd_message.Set_token('TEXT', ' l_pt_ess_opp'|| l_pt_full_access_opp);
2149: fnd_msg_pub.Add;
2150: end if;
2151:

Line 2148: fnd_message.Set_token('TEXT', ' l_pt_ess_opp'|| l_pt_full_access_opp);

2144: for i in 1 .. l_access_id_tbl.count loop
2145:
2146: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2147: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2148: fnd_message.Set_token('TEXT', ' l_pt_ess_opp'|| l_pt_full_access_opp);
2149: fnd_msg_pub.Add;
2150: end if;
2151:
2152:

Line 2156: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

2152:
2153: IF p_access_type in (pv_assignment_pub.G_CM_ACCESS) THEN
2154:
2155: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2156: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2157: fnd_message.Set_token('TEXT', 'action type is G_CM_ACCESS and setting the Team_leader_flag, prm_keep_flag to Y for resource id: ' || p_resource_id );
2158: fnd_msg_pub.Add;
2159: end if;
2160:

Line 2157: fnd_message.Set_token('TEXT', 'action type is G_CM_ACCESS and setting the Team_leader_flag, prm_keep_flag to Y for resource id: ' || p_resource_id );

2153: IF p_access_type in (pv_assignment_pub.G_CM_ACCESS) THEN
2154:
2155: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2156: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2157: fnd_message.Set_token('TEXT', 'action type is G_CM_ACCESS and setting the Team_leader_flag, prm_keep_flag to Y for resource id: ' || p_resource_id );
2158: fnd_msg_pub.Add;
2159: end if;
2160:
2161: update as_accesses_all set prm_keep_flag = 'Y', freeze_flag = 'Y', team_leader_flag = 'Y', open_flag = l_open_flag

Line 2168: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

2164:
2165: ELSIF p_access_type in (pv_assignment_pub.G_PT_ACCESS,pv_assignment_pub.G_PT_ORG_ACCESS) THEN
2166:
2167: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2168: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2169: fnd_message.Set_token('TEXT', 'action type is G_PT_ACCESS or G_PT_ORG_ACCESS for resource id: ' || p_resource_id );
2170: fnd_msg_pub.Add;
2171: end if;
2172:

Line 2169: fnd_message.Set_token('TEXT', 'action type is G_PT_ACCESS or G_PT_ORG_ACCESS for resource id: ' || p_resource_id );

2165: ELSIF p_access_type in (pv_assignment_pub.G_PT_ACCESS,pv_assignment_pub.G_PT_ORG_ACCESS) THEN
2166:
2167: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2168: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2169: fnd_message.Set_token('TEXT', 'action type is G_PT_ACCESS or G_PT_ORG_ACCESS for resource id: ' || p_resource_id );
2170: fnd_msg_pub.Add;
2171: end if;
2172:
2173: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

Line 2174: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

2170: fnd_msg_pub.Add;
2171: end if;
2172:
2173: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2174: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2175: fnd_message.Set_token('TEXT', 'Find the partner id of the resource with resource_id ' || p_resource_id );
2176: fnd_msg_pub.Add;
2177: end if;
2178:

Line 2175: fnd_message.Set_token('TEXT', 'Find the partner id of the resource with resource_id ' || p_resource_id );

2171: end if;
2172:
2173: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2174: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2175: fnd_message.Set_token('TEXT', 'Find the partner id of the resource with resource_id ' || p_resource_id );
2176: fnd_msg_pub.Add;
2177: end if;
2178:
2179:

Line 2183: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

2179:
2180: IF p_access_type = pv_assignment_pub.G_PT_ORG_ACCESS THEN
2181:
2182: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2183: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2184: fnd_message.Set_token('TEXT', 'p_access_type is G_PT_ORG_ACCESS and executing lc_get_partner_id_org cursor');
2185: fnd_msg_pub.Add;
2186: end if;
2187:

Line 2184: fnd_message.Set_token('TEXT', 'p_access_type is G_PT_ORG_ACCESS and executing lc_get_partner_id_org cursor');

2180: IF p_access_type = pv_assignment_pub.G_PT_ORG_ACCESS THEN
2181:
2182: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2183: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2184: fnd_message.Set_token('TEXT', 'p_access_type is G_PT_ORG_ACCESS and executing lc_get_partner_id_org cursor');
2185: fnd_msg_pub.Add;
2186: end if;
2187:
2188: open lc_get_partner_id_org(p_resource_id);

Line 2197: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

2193:
2194: ELSIF p_access_type = pv_assignment_pub.G_PT_ACCESS THEN
2195:
2196: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2197: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2198: fnd_message.Set_token('TEXT', 'p_access_type is G_PT_ACCESS and executing lc_get_partner_id_org_contact cursor');
2199: fnd_msg_pub.Add;
2200: end if;
2201:

Line 2198: fnd_message.Set_token('TEXT', 'p_access_type is G_PT_ACCESS and executing lc_get_partner_id_org_contact cursor');

2194: ELSIF p_access_type = pv_assignment_pub.G_PT_ACCESS THEN
2195:
2196: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2197: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2198: fnd_message.Set_token('TEXT', 'p_access_type is G_PT_ACCESS and executing lc_get_partner_id_org_contact cursor');
2199: fnd_msg_pub.Add;
2200: end if;
2201:
2202: open lc_get_partner_id_org_contact(p_resource_id);

Line 2210: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

2206:
2207: END IF;
2208:
2209: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2210: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2211: fnd_message.Set_token('TEXT', ' the partner id of the resource with resource_id ' || p_resource_id || ' is ' || l_current_partnerid_of_rel);
2212: fnd_msg_pub.Add;
2213: end if;
2214:

Line 2211: fnd_message.Set_token('TEXT', ' the partner id of the resource with resource_id ' || p_resource_id || ' is ' || l_current_partnerid_of_rel);

2207: END IF;
2208:
2209: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2210: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2211: fnd_message.Set_token('TEXT', ' the partner id of the resource with resource_id ' || p_resource_id || ' is ' || l_current_partnerid_of_rel);
2212: fnd_msg_pub.Add;
2213: end if;
2214:
2215:

Line 2218: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

2214:
2215:
2216:
2217: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2218: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2219: fnd_message.Set_token('TEXT', ' Executing the sql_text to get Allow Access Profile value for partner ' || l_current_partnerid_of_rel);
2220: fnd_msg_pub.Add;
2221: end if;
2222:

Line 2219: fnd_message.Set_token('TEXT', ' Executing the sql_text to get Allow Access Profile value for partner ' || l_current_partnerid_of_rel);

2215:
2216:
2217: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2218: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2219: fnd_message.Set_token('TEXT', ' Executing the sql_text to get Allow Access Profile value for partner ' || l_current_partnerid_of_rel);
2220: fnd_msg_pub.Add;
2221: end if;
2222:
2223: BEGIN

Line 2229: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

2225: USING 7, 'PARTNER', l_current_partnerid_of_rel;
2226: EXCEPTION
2227: WHEN NO_DATA_FOUND THEN
2228: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2229: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2230: fnd_message.SET_TOKEN('TEXT', 'No Data found executing the sql_text for attribute id 7 ' || l_sql_text_attr_7);
2231: fnd_msg_pub.ADD;
2232: end if;
2233: END;

Line 2230: fnd_message.SET_TOKEN('TEXT', 'No Data found executing the sql_text for attribute id 7 ' || l_sql_text_attr_7);

2226: EXCEPTION
2227: WHEN NO_DATA_FOUND THEN
2228: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2229: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2230: fnd_message.SET_TOKEN('TEXT', 'No Data found executing the sql_text for attribute id 7 ' || l_sql_text_attr_7);
2231: fnd_msg_pub.ADD;
2232: end if;
2233: END;
2234:

Line 2236: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

2232: end if;
2233: END;
2234:
2235: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2236: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2237: fnd_message.Set_token('TEXT', ' Value of Allow Access Profile value for partner ' || l_current_partnerid_of_rel || ' is ' || l_enable_full_access_value);
2238: fnd_msg_pub.Add;
2239: end if;
2240:

Line 2237: fnd_message.Set_token('TEXT', ' Value of Allow Access Profile value for partner ' || l_current_partnerid_of_rel || ' is ' || l_enable_full_access_value);

2233: END;
2234:
2235: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2236: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2237: fnd_message.Set_token('TEXT', ' Value of Allow Access Profile value for partner ' || l_current_partnerid_of_rel || ' is ' || l_enable_full_access_value);
2238: fnd_msg_pub.Add;
2239: end if;
2240:
2241:

Line 2245: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

2241:
2242: IF(l_enable_full_access_value = 'Y') then
2243:
2244: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2245: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2246: fnd_message.Set_token('TEXT', ' l_enable_full_access_value is Y');
2247: fnd_msg_pub.Add;
2248: end if;
2249:

Line 2246: fnd_message.Set_token('TEXT', ' l_enable_full_access_value is Y');

2242: IF(l_enable_full_access_value = 'Y') then
2243:
2244: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2245: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2246: fnd_message.Set_token('TEXT', ' l_enable_full_access_value is Y');
2247: fnd_msg_pub.Add;
2248: end if;
2249:
2250:

Line 2254: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

2250:
2251: IF p_access_type in (pv_assignment_pub.G_PT_ORG_ACCESS) THEN
2252:
2253: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2254: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2255: fnd_message.Set_token('TEXT', 'p_access_type is G_PT_ORG_ACCESS and updating team_leader_flag to Y');
2256: fnd_msg_pub.Add;
2257: end if;
2258:

Line 2255: fnd_message.Set_token('TEXT', 'p_access_type is G_PT_ORG_ACCESS and updating team_leader_flag to Y');

2251: IF p_access_type in (pv_assignment_pub.G_PT_ORG_ACCESS) THEN
2252:
2253: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2254: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2255: fnd_message.Set_token('TEXT', 'p_access_type is G_PT_ORG_ACCESS and updating team_leader_flag to Y');
2256: fnd_msg_pub.Add;
2257: end if;
2258:
2259: update as_accesses_all set prm_keep_flag = 'Y', freeze_flag = 'Y', team_leader_flag = 'Y', open_flag = l_open_flag

Line 2264: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

2260: where access_id = l_access_id_tbl(i);
2261:
2262: ELSIF p_access_type in (pv_assignment_pub.G_PT_ACCESS) THEN
2263: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2264: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2265: fnd_message.Set_token('TEXT', 'p_access_type is G_PT_ACCESS and updating team_leader_flag to Y for all partner contact levels');
2266: fnd_msg_pub.Add;
2267: end if;
2268:

Line 2265: fnd_message.Set_token('TEXT', 'p_access_type is G_PT_ACCESS and updating team_leader_flag to Y for all partner contact levels');

2261:
2262: ELSIF p_access_type in (pv_assignment_pub.G_PT_ACCESS) THEN
2263: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2264: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2265: fnd_message.Set_token('TEXT', 'p_access_type is G_PT_ACCESS and updating team_leader_flag to Y for all partner contact levels');
2266: fnd_msg_pub.Add;
2267: end if;
2268:
2269: open lc_get_pt_access (p_lead_id);

Line 2275: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

2271: fetch lc_get_pt_access into l_pt_resource_id;
2272: exit when lc_get_pt_access%notfound;
2273:
2274: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2275: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2276: fnd_message.Set_token('TEXT', ' resource ID ' || l_pt_resource_id);
2277: fnd_msg_pub.Add;
2278: END IF;
2279:

Line 2276: fnd_message.Set_token('TEXT', ' resource ID ' || l_pt_resource_id);

2272: exit when lc_get_pt_access%notfound;
2273:
2274: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2275: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2276: fnd_message.Set_token('TEXT', ' resource ID ' || l_pt_resource_id);
2277: fnd_msg_pub.Add;
2278: END IF;
2279:
2280:

Line 2298: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

2294:
2295: ELSIF(l_enable_full_access_value = 'N') then
2296:
2297: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2298: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2299: fnd_message.Set_token('TEXT', ' l_enable_full_access_value is N');
2300: fnd_msg_pub.Add;
2301: end if;
2302:

Line 2299: fnd_message.Set_token('TEXT', ' l_enable_full_access_value is N');

2295: ELSIF(l_enable_full_access_value = 'N') then
2296:
2297: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2298: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2299: fnd_message.Set_token('TEXT', ' l_enable_full_access_value is N');
2300: fnd_msg_pub.Add;
2301: end if;
2302:
2303: IF p_access_type in (pv_assignment_pub.G_PT_ORG_ACCESS) THEN

Line 2306: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

2302:
2303: IF p_access_type in (pv_assignment_pub.G_PT_ORG_ACCESS) THEN
2304:
2305: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2306: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2307: fnd_message.Set_token('TEXT', 'p_access_type is G_PT_ORG_ACCESS and updating team_leader_flag to N');
2308: fnd_msg_pub.Add;
2309: end if;
2310:

Line 2307: fnd_message.Set_token('TEXT', 'p_access_type is G_PT_ORG_ACCESS and updating team_leader_flag to N');

2303: IF p_access_type in (pv_assignment_pub.G_PT_ORG_ACCESS) THEN
2304:
2305: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2306: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2307: fnd_message.Set_token('TEXT', 'p_access_type is G_PT_ORG_ACCESS and updating team_leader_flag to N');
2308: fnd_msg_pub.Add;
2309: end if;
2310:
2311: update as_accesses_all set prm_keep_flag = 'Y', freeze_flag = 'Y', team_leader_flag = 'N', open_flag = l_open_flag

Line 2317: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

2313:
2314: ELSIF p_access_type in (pv_assignment_pub.G_PT_ACCESS) THEN
2315:
2316: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2317: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2318: fnd_message.Set_token('TEXT', 'p_access_type is G_PT_ACCESS and updating team_leader_flag to N for all partner contact levels');
2319: fnd_msg_pub.Add;
2320: end if;
2321:

Line 2318: fnd_message.Set_token('TEXT', 'p_access_type is G_PT_ACCESS and updating team_leader_flag to N for all partner contact levels');

2314: ELSIF p_access_type in (pv_assignment_pub.G_PT_ACCESS) THEN
2315:
2316: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2317: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2318: fnd_message.Set_token('TEXT', 'p_access_type is G_PT_ACCESS and updating team_leader_flag to N for all partner contact levels');
2319: fnd_msg_pub.Add;
2320: end if;
2321:
2322: open lc_get_pt_access (p_lead_id);

Line 2328: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

2324: fetch lc_get_pt_access into l_pt_resource_id;
2325: exit when lc_get_pt_access%notfound;
2326:
2327: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2328: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2329: fnd_message.Set_token('TEXT', ' resource ID ' || l_pt_resource_id);
2330: fnd_msg_pub.Add;
2331: END IF;
2332:

Line 2329: fnd_message.Set_token('TEXT', ' resource ID ' || l_pt_resource_id);

2325: exit when lc_get_pt_access%notfound;
2326:
2327: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2328: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2329: fnd_message.Set_token('TEXT', ' resource ID ' || l_pt_resource_id);
2330: fnd_msg_pub.Add;
2331: END IF;
2332:
2333:

Line 2350: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

2346:
2347:
2348: ELSE -- FOr null value and othewr values
2349: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2350: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2351: fnd_message.Set_token('TEXT', ' l_enable_full_access_value is null or other values');
2352: fnd_msg_pub.Add;
2353: end if;
2354:

Line 2351: fnd_message.Set_token('TEXT', ' l_enable_full_access_value is null or other values');

2347:
2348: ELSE -- FOr null value and othewr values
2349: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2350: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2351: fnd_message.Set_token('TEXT', ' l_enable_full_access_value is null or other values');
2352: fnd_msg_pub.Add;
2353: end if;
2354:
2355: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

Line 2356: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

2352: fnd_msg_pub.Add;
2353: end if;
2354:
2355: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2356: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2357: fnd_message.Set_token('TEXT', ' Now the next level of security which is the profile options value would come into picture.');
2358: fnd_msg_pub.Add;
2359: end if;
2360:

Line 2357: fnd_message.Set_token('TEXT', ' Now the next level of security which is the profile options value would come into picture.');

2353: end if;
2354:
2355: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2356: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2357: fnd_message.Set_token('TEXT', ' Now the next level of security which is the profile options value would come into picture.');
2358: fnd_msg_pub.Add;
2359: end if;
2360:
2361: IF l_pt_full_access_opp = 'Y' THEN

Line 2364: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

2360:
2361: IF l_pt_full_access_opp = 'Y' THEN
2362:
2363: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2364: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2365: fnd_message.Set_token('TEXT', 'l_pt_full_access_opp is Y and Setting prm_keep_flag to Y for resource id: ' || p_resource_id || ' if not lead owner');
2366: fnd_msg_pub.Add;
2367: end if;
2368:

Line 2365: fnd_message.Set_token('TEXT', 'l_pt_full_access_opp is Y and Setting prm_keep_flag to Y for resource id: ' || p_resource_id || ' if not lead owner');

2361: IF l_pt_full_access_opp = 'Y' THEN
2362:
2363: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2364: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2365: fnd_message.Set_token('TEXT', 'l_pt_full_access_opp is Y and Setting prm_keep_flag to Y for resource id: ' || p_resource_id || ' if not lead owner');
2366: fnd_msg_pub.Add;
2367: end if;
2368:
2369: IF p_access_type in (pv_assignment_pub.G_PT_ORG_ACCESS) THEN

Line 2372: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

2368:
2369: IF p_access_type in (pv_assignment_pub.G_PT_ORG_ACCESS) THEN
2370:
2371: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2372: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2373: fnd_message.Set_token('TEXT', 'l_pt_full_access_opp is N and making team_leader_flag to Y of PT ORG: ' || p_resource_id || ' if not lead owner');
2374: fnd_msg_pub.Add;
2375: end if;
2376:

Line 2373: fnd_message.Set_token('TEXT', 'l_pt_full_access_opp is N and making team_leader_flag to Y of PT ORG: ' || p_resource_id || ' if not lead owner');

2369: IF p_access_type in (pv_assignment_pub.G_PT_ORG_ACCESS) THEN
2370:
2371: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2372: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2373: fnd_message.Set_token('TEXT', 'l_pt_full_access_opp is N and making team_leader_flag to Y of PT ORG: ' || p_resource_id || ' if not lead owner');
2374: fnd_msg_pub.Add;
2375: end if;
2376:
2377: update as_accesses_all set prm_keep_flag = 'Y', freeze_flag = 'Y', open_flag = l_open_flag, team_leader_flag = 'Y'

Line 2383: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

2379:
2380: ELSIF p_access_type = pv_assignment_pub.G_PT_ACCESS THEN
2381:
2382: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2383: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2384: fnd_message.Set_token('TEXT', 'action type is G_PT_ACCESS , l_pt_full_access_opp is Y and not touching the team leader flag of Partner resource ID ' || l_pt_resource_id);
2385: fnd_msg_pub.Add;
2386: END IF;
2387:

Line 2384: fnd_message.Set_token('TEXT', 'action type is G_PT_ACCESS , l_pt_full_access_opp is Y and not touching the team leader flag of Partner resource ID ' || l_pt_resource_id);

2380: ELSIF p_access_type = pv_assignment_pub.G_PT_ACCESS THEN
2381:
2382: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2383: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2384: fnd_message.Set_token('TEXT', 'action type is G_PT_ACCESS , l_pt_full_access_opp is Y and not touching the team leader flag of Partner resource ID ' || l_pt_resource_id);
2385: fnd_msg_pub.Add;
2386: END IF;
2387:
2388: --For exisitng contatcs, we do nto need to update the team leader flag.

Line 2405: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

2401: IF p_access_type in (pv_assignment_pub.G_PT_ORG_ACCESS) THEN
2402:
2403:
2404: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2405: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2406: fnd_message.Set_token('TEXT', 'l_pt_full_access_opp is N and making team_leader_flag to N PT ORG: ' || p_resource_id || ' if not lead owner');
2407: fnd_msg_pub.Add;
2408: end if;
2409:

Line 2406: fnd_message.Set_token('TEXT', 'l_pt_full_access_opp is N and making team_leader_flag to N PT ORG: ' || p_resource_id || ' if not lead owner');

2402:
2403:
2404: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2405: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2406: fnd_message.Set_token('TEXT', 'l_pt_full_access_opp is N and making team_leader_flag to N PT ORG: ' || p_resource_id || ' if not lead owner');
2407: fnd_msg_pub.Add;
2408: end if;
2409:
2410: update as_accesses_all set prm_keep_flag = 'Y', freeze_flag = 'Y', team_leader_flag = 'N', open_flag = l_open_flag

Line 2422: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

2418: fetch lc_get_pt_access into l_pt_resource_id;
2419: exit when lc_get_pt_access%notfound;
2420:
2421: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2422: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2423: fnd_message.Set_token('TEXT', 'action type is G_PT_ACCESS , l_pt_full_access_opp is N and not touching the team leader flag of Partner resource ID ' || l_pt_resource_id);
2424: fnd_msg_pub.Add;
2425: END IF;
2426:

Line 2423: fnd_message.Set_token('TEXT', 'action type is G_PT_ACCESS , l_pt_full_access_opp is N and not touching the team leader flag of Partner resource ID ' || l_pt_resource_id);

2419: exit when lc_get_pt_access%notfound;
2420:
2421: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2422: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2423: fnd_message.Set_token('TEXT', 'action type is G_PT_ACCESS , l_pt_full_access_opp is N and not touching the team leader flag of Partner resource ID ' || l_pt_resource_id);
2424: fnd_msg_pub.Add;
2425: END IF;
2426:
2427:

Line 2466: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

2462: fetch lc_get_sql_text_attr_7 into l_sql_text_attr_7;
2463: close lc_get_sql_text_attr_7;
2464:
2465: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2466: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2467: fnd_message.Set_token('TEXT', ' SQL Text for attribute 7'|| l_sql_text_attr_7);
2468: fnd_msg_pub.Add;
2469: end if;
2470:

Line 2467: fnd_message.Set_token('TEXT', ' SQL Text for attribute 7'|| l_sql_text_attr_7);

2463: close lc_get_sql_text_attr_7;
2464:
2465: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2466: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2467: fnd_message.Set_token('TEXT', ' SQL Text for attribute 7'|| l_sql_text_attr_7);
2468: fnd_msg_pub.Add;
2469: end if;
2470:
2471:

Line 2476: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

2472:
2473: IF p_access_type in (pv_assignment_pub.G_CM_ACCESS) THEN
2474:
2475: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2476: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2477: fnd_message.Set_token('TEXT', 'action type is G_CM_ACCESS and setting the Team_leader_flag to Y for resource id: ' || p_resource_id );
2478: fnd_msg_pub.Add;
2479: end if;
2480:

Line 2477: fnd_message.Set_token('TEXT', 'action type is G_CM_ACCESS and setting the Team_leader_flag to Y for resource id: ' || p_resource_id );

2473: IF p_access_type in (pv_assignment_pub.G_CM_ACCESS) THEN
2474:
2475: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2476: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2477: fnd_message.Set_token('TEXT', 'action type is G_CM_ACCESS and setting the Team_leader_flag to Y for resource id: ' || p_resource_id );
2478: fnd_msg_pub.Add;
2479: end if;
2480:
2481: l_sales_team_rec.Team_Leader_Flag := 'Y';

Line 2486: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

2482:
2483: ELSIF p_access_type in (pv_assignment_pub.G_PT_ACCESS,pv_assignment_pub.G_PT_ORG_ACCESS) THEN
2484:
2485: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2486: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2487: fnd_message.Set_token('TEXT', 'action type is ' || p_access_type || ' for resource id: ' || p_resource_id );
2488: fnd_msg_pub.Add;
2489: end if;
2490:

Line 2487: fnd_message.Set_token('TEXT', 'action type is ' || p_access_type || ' for resource id: ' || p_resource_id );

2483: ELSIF p_access_type in (pv_assignment_pub.G_PT_ACCESS,pv_assignment_pub.G_PT_ORG_ACCESS) THEN
2484:
2485: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2486: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2487: fnd_message.Set_token('TEXT', 'action type is ' || p_access_type || ' for resource id: ' || p_resource_id );
2488: fnd_msg_pub.Add;
2489: end if;
2490:
2491: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

Line 2492: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

2488: fnd_msg_pub.Add;
2489: end if;
2490:
2491: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2492: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2493: fnd_message.Set_token('TEXT', 'Find the partner id of the resource with resource_id ' || p_resource_id );
2494: fnd_msg_pub.Add;
2495: end if;
2496:

Line 2493: fnd_message.Set_token('TEXT', 'Find the partner id of the resource with resource_id ' || p_resource_id );

2489: end if;
2490:
2491: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2492: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2493: fnd_message.Set_token('TEXT', 'Find the partner id of the resource with resource_id ' || p_resource_id );
2494: fnd_msg_pub.Add;
2495: end if;
2496:
2497: IF p_access_type in (pv_assignment_pub.G_PT_ORG_ACCESS) THEN

Line 2500: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

2496:
2497: IF p_access_type in (pv_assignment_pub.G_PT_ORG_ACCESS) THEN
2498:
2499: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2500: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2501: fnd_message.Set_token('TEXT', 'p_access_type is G_PT_ORG_ACCESS and executing lc_get_partner_id_org cursor');
2502: fnd_msg_pub.Add;
2503: end if;
2504:

Line 2501: fnd_message.Set_token('TEXT', 'p_access_type is G_PT_ORG_ACCESS and executing lc_get_partner_id_org cursor');

2497: IF p_access_type in (pv_assignment_pub.G_PT_ORG_ACCESS) THEN
2498:
2499: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2500: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2501: fnd_message.Set_token('TEXT', 'p_access_type is G_PT_ORG_ACCESS and executing lc_get_partner_id_org cursor');
2502: fnd_msg_pub.Add;
2503: end if;
2504:
2505: open lc_get_partner_id_org(p_resource_id);

Line 2511: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

2507: close lc_get_partner_id_org;
2508:
2509: ELSIF p_access_type in (pv_assignment_pub.G_PT_ACCESS) THEN
2510: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2511: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2512: fnd_message.Set_token('TEXT', 'p_access_type is G_PT_ACCESS and executing lc_get_partner_id_org_contact cursor');
2513: fnd_msg_pub.Add;
2514: end if;
2515:

Line 2512: fnd_message.Set_token('TEXT', 'p_access_type is G_PT_ACCESS and executing lc_get_partner_id_org_contact cursor');

2508:
2509: ELSIF p_access_type in (pv_assignment_pub.G_PT_ACCESS) THEN
2510: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2511: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2512: fnd_message.Set_token('TEXT', 'p_access_type is G_PT_ACCESS and executing lc_get_partner_id_org_contact cursor');
2513: fnd_msg_pub.Add;
2514: end if;
2515:
2516: open lc_get_partner_id_org_contact(p_resource_id);

Line 2522: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

2518: close lc_get_partner_id_org_contact;
2519: END IF;
2520:
2521: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2522: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2523: fnd_message.Set_token('TEXT', ' the partner id of the resource with resource_id ' || p_resource_id || ' is ' || l_current_partnerid_of_rel);
2524: fnd_msg_pub.Add;
2525: end if;
2526:

Line 2523: fnd_message.Set_token('TEXT', ' the partner id of the resource with resource_id ' || p_resource_id || ' is ' || l_current_partnerid_of_rel);

2519: END IF;
2520:
2521: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2522: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2523: fnd_message.Set_token('TEXT', ' the partner id of the resource with resource_id ' || p_resource_id || ' is ' || l_current_partnerid_of_rel);
2524: fnd_msg_pub.Add;
2525: end if;
2526:
2527: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

Line 2528: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

2524: fnd_msg_pub.Add;
2525: end if;
2526:
2527: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2528: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2529: fnd_message.Set_token('TEXT', ' Executing the sql_text to get Allow Access Profile value for partner ' || l_current_partnerid_of_rel);
2530: fnd_msg_pub.Add;
2531: end if;
2532:

Line 2529: fnd_message.Set_token('TEXT', ' Executing the sql_text to get Allow Access Profile value for partner ' || l_current_partnerid_of_rel);

2525: end if;
2526:
2527: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2528: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2529: fnd_message.Set_token('TEXT', ' Executing the sql_text to get Allow Access Profile value for partner ' || l_current_partnerid_of_rel);
2530: fnd_msg_pub.Add;
2531: end if;
2532:
2533: BEGIN

Line 2539: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

2535: USING 7, 'PARTNER', l_current_partnerid_of_rel;
2536: EXCEPTION
2537: WHEN NO_DATA_FOUND THEN
2538: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2539: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2540: fnd_message.SET_TOKEN('TEXT', 'No Data found executing sql_text for attribute id 7 ' || l_sql_text_attr_7);
2541: fnd_msg_pub.ADD;
2542: end if;
2543: END;

Line 2540: fnd_message.SET_TOKEN('TEXT', 'No Data found executing sql_text for attribute id 7 ' || l_sql_text_attr_7);

2536: EXCEPTION
2537: WHEN NO_DATA_FOUND THEN
2538: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2539: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2540: fnd_message.SET_TOKEN('TEXT', 'No Data found executing sql_text for attribute id 7 ' || l_sql_text_attr_7);
2541: fnd_msg_pub.ADD;
2542: end if;
2543: END;
2544:

Line 2546: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

2542: end if;
2543: END;
2544:
2545: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2546: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2547: fnd_message.Set_token('TEXT', ' Value of Allow Access Profile value for partner ' || l_current_partnerid_of_rel || ' is ' || l_enable_full_access_value);
2548: fnd_msg_pub.Add;
2549: end if;
2550:

Line 2547: fnd_message.Set_token('TEXT', ' Value of Allow Access Profile value for partner ' || l_current_partnerid_of_rel || ' is ' || l_enable_full_access_value);

2543: END;
2544:
2545: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2546: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2547: fnd_message.Set_token('TEXT', ' Value of Allow Access Profile value for partner ' || l_current_partnerid_of_rel || ' is ' || l_enable_full_access_value);
2548: fnd_msg_pub.Add;
2549: end if;
2550:
2551:

Line 2555: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

2551:
2552: IF(l_enable_full_access_value = 'Y') then
2553:
2554: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2555: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2556: fnd_message.Set_token('TEXT', ' l_enable_full_access_value is Y and updatign team_leader_flag to Y');
2557: fnd_msg_pub.Add;
2558: end if;
2559:

Line 2556: fnd_message.Set_token('TEXT', ' l_enable_full_access_value is Y and updatign team_leader_flag to Y');

2552: IF(l_enable_full_access_value = 'Y') then
2553:
2554: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2555: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2556: fnd_message.Set_token('TEXT', ' l_enable_full_access_value is Y and updatign team_leader_flag to Y');
2557: fnd_msg_pub.Add;
2558: end if;
2559:
2560: l_sales_team_rec.Team_Leader_Flag := 'Y';

Line 2565: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

2561:
2562: ELSIF(l_enable_full_access_value = 'N') then
2563:
2564: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2565: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2566: fnd_message.Set_token('TEXT', ' l_enable_full_access_value is N and updating team leader flkag to N');
2567: fnd_msg_pub.Add;
2568: end if;
2569:

Line 2566: fnd_message.Set_token('TEXT', ' l_enable_full_access_value is N and updating team leader flkag to N');

2562: ELSIF(l_enable_full_access_value = 'N') then
2563:
2564: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2565: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2566: fnd_message.Set_token('TEXT', ' l_enable_full_access_value is N and updating team leader flkag to N');
2567: fnd_msg_pub.Add;
2568: end if;
2569:
2570: l_sales_team_rec.Team_Leader_Flag := 'N';

Line 2574: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

2570: l_sales_team_rec.Team_Leader_Flag := 'N';
2571:
2572: ELSE -- FOr null value and othewr values
2573: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2574: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2575: fnd_message.Set_token('TEXT', ' l_enable_full_access_value is null or other values');
2576: fnd_msg_pub.Add;
2577: end if;
2578:

Line 2575: fnd_message.Set_token('TEXT', ' l_enable_full_access_value is null or other values');

2571:
2572: ELSE -- FOr null value and othewr values
2573: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2574: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2575: fnd_message.Set_token('TEXT', ' l_enable_full_access_value is null or other values');
2576: fnd_msg_pub.Add;
2577: end if;
2578:
2579: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

Line 2580: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

2576: fnd_msg_pub.Add;
2577: end if;
2578:
2579: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2580: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2581: fnd_message.Set_token('TEXT', ' Now the next level of security which is the profile options value would come into picture.');
2582: fnd_msg_pub.Add;
2583: end if;
2584:

Line 2581: fnd_message.Set_token('TEXT', ' Now the next level of security which is the profile options value would come into picture.');

2577: end if;
2578:
2579: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2580: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2581: fnd_message.Set_token('TEXT', ' Now the next level of security which is the profile options value would come into picture.');
2582: fnd_msg_pub.Add;
2583: end if;
2584:
2585: IF l_pt_full_access_opp = 'Y' THEN

Line 2588: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

2584:
2585: IF l_pt_full_access_opp = 'Y' THEN
2586:
2587: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2588: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2589: fnd_message.Set_token('TEXT', 'l_pt_full_access_opp is Y and Setting team_leader_flag to Y');
2590: fnd_msg_pub.Add;
2591: end if;
2592:

Line 2589: fnd_message.Set_token('TEXT', 'l_pt_full_access_opp is Y and Setting team_leader_flag to Y');

2585: IF l_pt_full_access_opp = 'Y' THEN
2586:
2587: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2588: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2589: fnd_message.Set_token('TEXT', 'l_pt_full_access_opp is Y and Setting team_leader_flag to Y');
2590: fnd_msg_pub.Add;
2591: end if;
2592:
2593: l_sales_team_rec.Team_Leader_Flag := 'Y';

Line 2598: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

2594:
2595: ELSE
2596:
2597: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2598: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2599: fnd_message.Set_token('TEXT', 'l_pt_full_access_opp is Y and Setting team_leader_flag to N');
2600: fnd_msg_pub.Add;
2601: end if;
2602:

Line 2599: fnd_message.Set_token('TEXT', 'l_pt_full_access_opp is Y and Setting team_leader_flag to N');

2595: ELSE
2596:
2597: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2598: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2599: fnd_message.Set_token('TEXT', 'l_pt_full_access_opp is Y and Setting team_leader_flag to N');
2600: fnd_msg_pub.Add;
2601: end if;
2602:
2603: l_sales_team_rec.Team_Leader_Flag := 'N';

Line 2715: fnd_message.Set_Name('PV', 'API:' || l_api_name || ': End');

2711: END IF;
2712:
2713: -- Debug Message
2714: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2715: fnd_message.Set_Name('PV', 'API:' || l_api_name || ': End');
2716: fnd_msg_pub.Add;
2717: END IF;
2718:
2719: -- Standard call to get message count and if count is 1, get message info.

Line 2790: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

2786: END IF;
2787:
2788: -- Debug Message
2789: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2790: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2791: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || '. Lead id: ' || p_Lead_id);
2792: fnd_msg_pub.Add;
2793: END IF;
2794:

Line 2791: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || '. Lead id: ' || p_Lead_id);

2787:
2788: -- Debug Message
2789: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2790: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2791: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || '. Lead id: ' || p_Lead_id);
2792: fnd_msg_pub.Add;
2793: END IF;
2794:
2795: -- Initialize API return status to success

Line 2810: fnd_message.Set_Name('PV', 'PV_INVALID_ROUTING_ROW');

2806:
2807: exception
2808: when TOO_MANY_ROWS then
2809:
2810: fnd_message.Set_Name('PV', 'PV_INVALID_ROUTING_ROW');
2811: fnd_message.Set_Token('P_LEAD_ID', p_lead_id);
2812: fnd_msg_pub.Add;
2813:
2814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2811: fnd_message.Set_Token('P_LEAD_ID', p_lead_id);

2807: exception
2808: when TOO_MANY_ROWS then
2809:
2810: fnd_message.Set_Name('PV', 'PV_INVALID_ROUTING_ROW');
2811: fnd_message.Set_Token('P_LEAD_ID', p_lead_id);
2812: fnd_msg_pub.Add;
2813:
2814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2815:

Line 2832: fnd_message.Set_Name('PV', 'PV_UNKNOWN_ROUTING_STAGE');

2828: pv_assignment_pub.g_r_status_abandoned,
2829: pv_assignment_pub.g_r_status_failed_auto,
2830: pv_assignment_pub.g_r_status_withdrawn) then
2831:
2832: fnd_message.Set_Name('PV', 'PV_UNKNOWN_ROUTING_STAGE');
2833: fnd_message.SET_TOKEN('P_ROUTING', x_routing_status);
2834: fnd_msg_pub.ADD;
2835:
2836: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2833: fnd_message.SET_TOKEN('P_ROUTING', x_routing_status);

2829: pv_assignment_pub.g_r_status_failed_auto,
2830: pv_assignment_pub.g_r_status_withdrawn) then
2831:
2832: fnd_message.Set_Name('PV', 'PV_UNKNOWN_ROUTING_STAGE');
2833: fnd_message.SET_TOKEN('P_ROUTING', x_routing_status);
2834: fnd_msg_pub.ADD;
2835:
2836: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2837:

Line 2840: fnd_message.Set_Name('PV', 'PV_INVALID_WF_STATUS');

2836: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2837:
2838: elsif x_wf_status not in (pv_assignment_pub.g_wf_status_open, pv_assignment_pub.g_wf_status_closed) then
2839:
2840: fnd_message.Set_Name('PV', 'PV_INVALID_WF_STATUS');
2841: fnd_message.SET_TOKEN('P_WF_STATUS', x_wf_status);
2842: fnd_message.Set_Token('P_LEAD_ID', p_lead_id);
2843: fnd_msg_pub.ADD;
2844:

Line 2841: fnd_message.SET_TOKEN('P_WF_STATUS', x_wf_status);

2837:
2838: elsif x_wf_status not in (pv_assignment_pub.g_wf_status_open, pv_assignment_pub.g_wf_status_closed) then
2839:
2840: fnd_message.Set_Name('PV', 'PV_INVALID_WF_STATUS');
2841: fnd_message.SET_TOKEN('P_WF_STATUS', x_wf_status);
2842: fnd_message.Set_Token('P_LEAD_ID', p_lead_id);
2843: fnd_msg_pub.ADD;
2844:
2845: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2842: fnd_message.Set_Token('P_LEAD_ID', p_lead_id);

2838: elsif x_wf_status not in (pv_assignment_pub.g_wf_status_open, pv_assignment_pub.g_wf_status_closed) then
2839:
2840: fnd_message.Set_Name('PV', 'PV_INVALID_WF_STATUS');
2841: fnd_message.SET_TOKEN('P_WF_STATUS', x_wf_status);
2842: fnd_message.Set_Token('P_LEAD_ID', p_lead_id);
2843: fnd_msg_pub.ADD;
2844:
2845: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2846:

Line 3027: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

3023: fnd_msg_pub.initialize;
3024: END IF;
3025:
3026: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
3027: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
3028: fnd_message.Set_Token('TEXT', 'In ' || l_api_name);
3029: fnd_msg_pub.Add;
3030: END IF;
3031:

Line 3028: fnd_message.Set_Token('TEXT', 'In ' || l_api_name);

3024: END IF;
3025:
3026: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
3027: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
3028: fnd_message.Set_Token('TEXT', 'In ' || l_api_name);
3029: fnd_msg_pub.Add;
3030: END IF;
3031:
3032: x_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 3040: fnd_message.SET_NAME('PV', 'PV_DEBUG_MESSAGE');

3036: close lc_wf_error_message;
3037:
3038: if l_wf_error_msg is not null then
3039:
3040: fnd_message.SET_NAME('PV', 'PV_DEBUG_MESSAGE');
3041: fnd_message.SET_TOKEN('TEXT' ,l_wf_error_msg);
3042: fnd_msg_pub.ADD;
3043:
3044: fnd_message.SET_NAME('PV', 'PV_MSG_FRM_CHK_FOR_ERR');

Line 3041: fnd_message.SET_TOKEN('TEXT' ,l_wf_error_msg);

3037:
3038: if l_wf_error_msg is not null then
3039:
3040: fnd_message.SET_NAME('PV', 'PV_DEBUG_MESSAGE');
3041: fnd_message.SET_TOKEN('TEXT' ,l_wf_error_msg);
3042: fnd_msg_pub.ADD;
3043:
3044: fnd_message.SET_NAME('PV', 'PV_MSG_FRM_CHK_FOR_ERR');
3045: fnd_message.SET_TOKEN('P_ITEM_TYPE' ,p_itemtype);

Line 3044: fnd_message.SET_NAME('PV', 'PV_MSG_FRM_CHK_FOR_ERR');

3040: fnd_message.SET_NAME('PV', 'PV_DEBUG_MESSAGE');
3041: fnd_message.SET_TOKEN('TEXT' ,l_wf_error_msg);
3042: fnd_msg_pub.ADD;
3043:
3044: fnd_message.SET_NAME('PV', 'PV_MSG_FRM_CHK_FOR_ERR');
3045: fnd_message.SET_TOKEN('P_ITEM_TYPE' ,p_itemtype);
3046: fnd_message.SET_TOKEN('P_ITEM_KEY' ,p_itemkey);
3047:
3048: if fnd_profile.value('ASF_PROFILE_DEBUG_MSG_ON') = 'Y' then

Line 3045: fnd_message.SET_TOKEN('P_ITEM_TYPE' ,p_itemtype);

3041: fnd_message.SET_TOKEN('TEXT' ,l_wf_error_msg);
3042: fnd_msg_pub.ADD;
3043:
3044: fnd_message.SET_NAME('PV', 'PV_MSG_FRM_CHK_FOR_ERR');
3045: fnd_message.SET_TOKEN('P_ITEM_TYPE' ,p_itemtype);
3046: fnd_message.SET_TOKEN('P_ITEM_KEY' ,p_itemkey);
3047:
3048: if fnd_profile.value('ASF_PROFILE_DEBUG_MSG_ON') = 'Y' then
3049:

Line 3046: fnd_message.SET_TOKEN('P_ITEM_KEY' ,p_itemkey);

3042: fnd_msg_pub.ADD;
3043:
3044: fnd_message.SET_NAME('PV', 'PV_MSG_FRM_CHK_FOR_ERR');
3045: fnd_message.SET_TOKEN('P_ITEM_TYPE' ,p_itemtype);
3046: fnd_message.SET_TOKEN('P_ITEM_KEY' ,p_itemkey);
3047:
3048: if fnd_profile.value('ASF_PROFILE_DEBUG_MSG_ON') = 'Y' then
3049:
3050: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

Line 3050: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

3046: fnd_message.SET_TOKEN('P_ITEM_KEY' ,p_itemkey);
3047:
3048: if fnd_profile.value('ASF_PROFILE_DEBUG_MSG_ON') = 'Y' then
3049:
3050: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
3051: fnd_message.Set_Token('TEXT', l_wf_error_stack);
3052: fnd_msg_pub.Add;
3053:
3054: end if;

Line 3051: fnd_message.Set_Token('TEXT', l_wf_error_stack);

3047:
3048: if fnd_profile.value('ASF_PROFILE_DEBUG_MSG_ON') = 'Y' then
3049:
3050: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
3051: fnd_message.Set_Token('TEXT', l_wf_error_stack);
3052: fnd_msg_pub.Add;
3053:
3054: end if;
3055:

Line 3118: FND_MESSAGE.Set_Name('PV', 'PV_DEBUG_MESSAGE');

3114: IS
3115:
3116: BEGIN
3117: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
3118: FND_MESSAGE.Set_Name('PV', 'PV_DEBUG_MESSAGE');
3119: FND_MESSAGE.Set_Token('TEXT', p_msg_string);
3120: FND_MSG_PUB.Add;
3121: END IF;
3122: END Debug;

Line 3119: FND_MESSAGE.Set_Token('TEXT', p_msg_string);

3115:
3116: BEGIN
3117: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
3118: FND_MESSAGE.Set_Name('PV', 'PV_DEBUG_MESSAGE');
3119: FND_MESSAGE.Set_Token('TEXT', p_msg_string);
3120: FND_MSG_PUB.Add;
3121: END IF;
3122: END Debug;
3123: -- =================================End of Debug================================

Line 3155: FND_MESSAGE.Set_Name('PV', p_msg_name);

3151: )
3152: IS
3153: BEGIN
3154: IF FND_MSG_PUB.Check_Msg_Level(p_msg_level) THEN
3155: FND_MESSAGE.Set_Name('PV', p_msg_name);
3156: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
3157:
3158: IF (p_token2 IS NOT NULL) THEN
3159: FND_MESSAGE.Set_Token(p_token2, p_token2_value);

Line 3156: FND_MESSAGE.Set_Token(p_token1, p_token1_value);

3152: IS
3153: BEGIN
3154: IF FND_MSG_PUB.Check_Msg_Level(p_msg_level) THEN
3155: FND_MESSAGE.Set_Name('PV', p_msg_name);
3156: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
3157:
3158: IF (p_token2 IS NOT NULL) THEN
3159: FND_MESSAGE.Set_Token(p_token2, p_token2_value);
3160: END IF;

Line 3159: FND_MESSAGE.Set_Token(p_token2, p_token2_value);

3155: FND_MESSAGE.Set_Name('PV', p_msg_name);
3156: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
3157:
3158: IF (p_token2 IS NOT NULL) THEN
3159: FND_MESSAGE.Set_Token(p_token2, p_token2_value);
3160: END IF;
3161:
3162: IF (p_token3 IS NOT NULL) THEN
3163: FND_MESSAGE.Set_Token(p_token3, p_token3_value);

Line 3163: FND_MESSAGE.Set_Token(p_token3, p_token3_value);

3159: FND_MESSAGE.Set_Token(p_token2, p_token2_value);
3160: END IF;
3161:
3162: IF (p_token3 IS NOT NULL) THEN
3163: FND_MESSAGE.Set_Token(p_token3, p_token3_value);
3164: END IF;
3165:
3166: FND_MSG_PUB.Add;
3167: END IF;