DBA Data[Home] [Help]

APPS.PV_ASSIGNMENT_PUB dependencies on PV_ASSIGNMENT_PVT

Line 86: l_attrib_values_rec pv_assignment_pvt.attrib_values_rec_type;

82:
83: l_has_cm_decision_maker varchar2(1);
84: l_has_pt_decision_maker varchar2(1);
85:
86: l_attrib_values_rec pv_assignment_pvt.attrib_values_rec_type;
87: l_partner_id_tbl JTF_NUMBER_TABLE;
88:
89: l_party_notify_rec_tbl pv_assignment_pvt.party_notify_rec_tbl_type;
90: l_rs_details_tbl pv_assign_util_pvt.resource_details_tbl_type := pv_assign_util_pvt.resource_details_tbl_type();

Line 89: l_party_notify_rec_tbl pv_assignment_pvt.party_notify_rec_tbl_type;

85:
86: l_attrib_values_rec pv_assignment_pvt.attrib_values_rec_type;
87: l_partner_id_tbl JTF_NUMBER_TABLE;
88:
89: l_party_notify_rec_tbl pv_assignment_pvt.party_notify_rec_tbl_type;
90: l_rs_details_tbl pv_assign_util_pvt.resource_details_tbl_type := pv_assign_util_pvt.resource_details_tbl_type();
91: l_lead_workflow_rec pv_assign_util_pvt.lead_workflow_rec_type;
92: l_ENTYRLS_rec PV_RULE_RECTYPE_PUB.ENTYRLS_Rec_Type := PV_RULE_RECTYPE_PUB.G_MISS_ENTYRLS_REC;
93: x_entity_rule_applied_id NUMBER;

Line 95: l_oppty_routing_log_rec PV_ASSIGNMENT_PVT.oppty_routing_log_rec_type;

91: l_lead_workflow_rec pv_assign_util_pvt.lead_workflow_rec_type;
92: l_ENTYRLS_rec PV_RULE_RECTYPE_PUB.ENTYRLS_Rec_Type := PV_RULE_RECTYPE_PUB.G_MISS_ENTYRLS_REC;
93: x_entity_rule_applied_id NUMBER;
94:
95: l_oppty_routing_log_rec PV_ASSIGNMENT_PVT.oppty_routing_log_rec_type;
96:
97:
98: -- --------------------------------------------------------------------------------
99: -- Checks if the opportunity is "open".

Line 452: fnd_message.Set_token('TEXT', 'Calling pv_assignment_pvt.update_routing_stage' );

448: end if;
449:
450: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
451: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
452: fnd_message.Set_token('TEXT', 'Calling pv_assignment_pvt.update_routing_stage' );
453: fnd_msg_pub.Add;
454: end if;
455:
456: pv_assignment_pvt.update_routing_stage (

Line 456: pv_assignment_pvt.update_routing_stage (

452: fnd_message.Set_token('TEXT', 'Calling pv_assignment_pvt.update_routing_stage' );
453: fnd_msg_pub.Add;
454: end if;
455:
456: pv_assignment_pvt.update_routing_stage (
457: p_api_version_number => 1.0,
458: p_init_msg_list => FND_API.G_FALSE,
459: p_commit => FND_API.G_FALSE,
460: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 781: fnd_message.Set_token('TEXT', 'Calling pv_assignment_pvt.set_current_routing_flag' );

777: end if;
778:
779: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
780: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
781: fnd_message.Set_token('TEXT', 'Calling pv_assignment_pvt.set_current_routing_flag' );
782: fnd_msg_pub.Add;
783: end if;
784: pv_assignment_pvt.set_current_routing_flag (
785: p_api_version_number => 1.0,

Line 784: pv_assignment_pvt.set_current_routing_flag (

780: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
781: fnd_message.Set_token('TEXT', 'Calling pv_assignment_pvt.set_current_routing_flag' );
782: fnd_msg_pub.Add;
783: end if;
784: pv_assignment_pvt.set_current_routing_flag (
785: p_api_version_number => 1.0,
786: p_init_msg_list => FND_API.G_FALSE,
787: p_commit => FND_API.G_FALSE,
788: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 828: fnd_message.Set_token('TEXT', 'Calling pv_assignment_pvt.Create_Oppty_Routing_Log_Row' );

824: l_oppty_routing_log_rec.user_type := 'LAM';
825:
826: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
827: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
828: fnd_message.Set_token('TEXT', 'Calling pv_assignment_pvt.Create_Oppty_Routing_Log_Row' );
829: fnd_msg_pub.Add;
830: end if;
831:
832: pv_assignment_pvt.Create_Oppty_Routing_Log_Row (

Line 832: pv_assignment_pvt.Create_Oppty_Routing_Log_Row (

828: fnd_message.Set_token('TEXT', 'Calling pv_assignment_pvt.Create_Oppty_Routing_Log_Row' );
829: fnd_msg_pub.Add;
830: end if;
831:
832: pv_assignment_pvt.Create_Oppty_Routing_Log_Row (
833: p_api_version_number => 1.0,
834: p_init_msg_list => FND_API.G_FALSE,
835: p_commit => FND_API.G_FALSE,
836: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 1042: fnd_message.Set_token('TEXT', 'Calling pv_assignment_pvt.bulk_cr_party_notification' );

1038: end loop; -- l_partner_id_tbl(count)
1039:
1040: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1041: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1042: fnd_message.Set_token('TEXT', 'Calling pv_assignment_pvt.bulk_cr_party_notification' );
1043: fnd_msg_pub.Add;
1044: end if;
1045:
1046: pv_assignment_pvt.bulk_cr_party_notification(

Line 1046: pv_assignment_pvt.bulk_cr_party_notification(

1042: fnd_message.Set_token('TEXT', 'Calling pv_assignment_pvt.bulk_cr_party_notification' );
1043: fnd_msg_pub.Add;
1044: end if;
1045:
1046: pv_assignment_pvt.bulk_cr_party_notification(
1047: p_api_version_number => 1.0
1048: ,p_init_msg_list => FND_API.G_FALSE
1049: ,p_commit => FND_API.G_FALSE
1050: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 1139: fnd_message.Set_token('TEXT', 'Calling pv_assignment_pvt.StartWorkflow' );

1135:
1136:
1137: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1138: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1139: fnd_message.Set_token('TEXT', 'Calling pv_assignment_pvt.StartWorkflow' );
1140: fnd_msg_pub.Add;
1141: end if;
1142:
1143: pv_assignment_pvt.StartWorkflow( p_api_version_number => 1.0,

Line 1143: pv_assignment_pvt.StartWorkflow( p_api_version_number => 1.0,

1139: fnd_message.Set_token('TEXT', 'Calling pv_assignment_pvt.StartWorkflow' );
1140: fnd_msg_pub.Add;
1141: end if;
1142:
1143: pv_assignment_pvt.StartWorkflow( p_api_version_number => 1.0,
1144: p_init_msg_list => FND_API.G_FALSE,
1145: p_commit => FND_API.G_FALSE,
1146: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1147: p_itemKey => l_itemKey,

Line 1283: l_party_notify_rec_tbl pv_assignment_pvt.party_notify_rec_tbl_type;

1279: l_match_outcome varchar2(30);
1280: l_pt_response varchar2(30);
1281:
1282: l_assignment_rec pv_assign_util_pvt.ASSIGNMENT_REC_TYPE;
1283: l_party_notify_rec_tbl pv_assignment_pvt.party_notify_rec_tbl_type;
1284: l_rs_details_tbl pv_assign_util_pvt.resource_details_tbl_type := pv_assign_util_pvt.resource_details_tbl_type();
1285: l_pt_response_tbl g_varchar_table_type := g_varchar_table_type();
1286:
1287: cursor lc_get_assignment_type (pc_lead_id number, pc_entity varchar2) is

Line 1440: fnd_message.Set_Token('TEXT', 'Calling pv_assignment_pvt.validateResponse' );

1436:
1437: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW)
1438: THEN
1439: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1440: fnd_message.Set_Token('TEXT', 'Calling pv_assignment_pvt.validateResponse' );
1441: fnd_msg_pub.Add;
1442: END IF;
1443:
1444: pv_assignment_pvt.validateResponse (

Line 1444: pv_assignment_pvt.validateResponse (

1440: fnd_message.Set_Token('TEXT', 'Calling pv_assignment_pvt.validateResponse' );
1441: fnd_msg_pub.Add;
1442: END IF;
1443:
1444: pv_assignment_pvt.validateResponse (
1445: p_api_version_number => 1.0
1446: ,p_init_msg_list => FND_API.G_FALSE
1447: ,p_commit => FND_API.G_FALSE
1448: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 1466: fnd_message.Set_Token('TEXT', 'pv_Assignment_pvt.update_party_response' );

1462:
1463: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW)
1464: THEN
1465: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1466: fnd_message.Set_Token('TEXT', 'pv_Assignment_pvt.update_party_response' );
1467: fnd_msg_pub.Add;
1468: END IF;
1469:
1470: pv_assignment_pvt.update_party_response (

Line 1470: pv_assignment_pvt.update_party_response (

1466: fnd_message.Set_Token('TEXT', 'pv_Assignment_pvt.update_party_response' );
1467: fnd_msg_pub.Add;
1468: END IF;
1469:
1470: pv_assignment_pvt.update_party_response (
1471: p_api_version_number => 1.0
1472: ,p_init_msg_list => FND_API.G_FALSE
1473: ,p_commit => FND_API.G_FALSE
1474: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 1533: fnd_message.Set_Token('TEXT', 'Calling pv_assignment_pvt.UpdateAssignment' );

1529:
1530: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW)
1531: THEN
1532: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1533: fnd_message.Set_Token('TEXT', 'Calling pv_assignment_pvt.UpdateAssignment' );
1534: fnd_msg_pub.Add;
1535: END IF;
1536:
1537:

Line 1538: pv_assignment_pvt.UpdateAssignment (

1534: fnd_msg_pub.Add;
1535: END IF;
1536:
1537:
1538: pv_assignment_pvt.UpdateAssignment (
1539: p_api_version_number => 1.0
1540: ,p_init_msg_list => FND_API.G_FALSE
1541: ,p_commit => FND_API.G_FALSE
1542: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 1722: pv_assignment_pvt.bulk_cr_party_notification(

1718: l_party_notify_rec_tbl.RESOURCE_RESPONSE (l_bulk_size) := p_statusTbl(i); -- CM_ADDED or CM_ADD_APP_FOR_PT
1719: l_party_notify_rec_tbl.RESPONSE_DATE (l_bulk_size) := sysdate;
1720: l_party_notify_rec_tbl.DECISION_MAKER_FLAG(l_bulk_size) := 'Y';
1721:
1722: pv_assignment_pvt.bulk_cr_party_notification(
1723: p_api_version_number => 1.0
1724: ,p_init_msg_list => FND_API.G_FALSE
1725: ,p_commit => FND_API.G_FALSE
1726: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 2204: fnd_message.Set_Token('TEXT', 'Calling pv_assignment_pvt.validateResponse');

2200:
2201: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW)
2202: THEN
2203: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2204: fnd_message.Set_Token('TEXT', 'Calling pv_assignment_pvt.validateResponse');
2205: fnd_msg_pub.Add;
2206: END IF;
2207:
2208:

Line 2209: pv_assignment_pvt.validateResponse (

2205: fnd_msg_pub.Add;
2206: END IF;
2207:
2208:
2209: pv_assignment_pvt.validateResponse (
2210: p_api_version_number => 1.0
2211: ,p_init_msg_list => FND_API.G_FALSE
2212: ,p_commit => FND_API.G_FALSE
2213: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 2296: fnd_message.Set_Token('TEXT', 'Calling pv_assignment_pvt.UpdateAssignment');

2292:
2293: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW)
2294: THEN
2295: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2296: fnd_message.Set_Token('TEXT', 'Calling pv_assignment_pvt.UpdateAssignment');
2297: fnd_msg_pub.Add;
2298: END IF;
2299:
2300: pv_assignment_pvt.UpdateAssignment (

Line 2300: pv_assignment_pvt.UpdateAssignment (

2296: fnd_message.Set_Token('TEXT', 'Calling pv_assignment_pvt.UpdateAssignment');
2297: fnd_msg_pub.Add;
2298: END IF;
2299:
2300: pv_assignment_pvt.UpdateAssignment (
2301: p_api_version_number => 1.0
2302: ,p_init_msg_list => FND_API.G_FALSE
2303: ,p_commit => FND_API.G_FALSE
2304: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 2324: fnd_message.Set_Token('TEXT', 'Calling pv_assignment_pvt.update_party_response');

2320:
2321: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW)
2322: THEN
2323: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2324: fnd_message.Set_Token('TEXT', 'Calling pv_assignment_pvt.update_party_response');
2325: fnd_msg_pub.Add;
2326: END IF;
2327:
2328: pv_assignment_pvt.update_party_response (

Line 2328: pv_assignment_pvt.update_party_response (

2324: fnd_message.Set_Token('TEXT', 'Calling pv_assignment_pvt.update_party_response');
2325: fnd_msg_pub.Add;
2326: END IF;
2327:
2328: pv_assignment_pvt.update_party_response (
2329: p_api_version_number => 1.0
2330: ,p_init_msg_list => FND_API.G_FALSE
2331: ,p_commit => FND_API.G_FALSE
2332: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 2371: fnd_message.Set_Token('TEXT', 'Calling pv_assignment_pvt.update_routing_stage');

2367:
2368: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW)
2369: THEN
2370: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2371: fnd_message.Set_Token('TEXT', 'Calling pv_assignment_pvt.update_routing_stage');
2372: fnd_msg_pub.Add;
2373: END IF;
2374:
2375: pv_assignment_pvt.update_routing_stage (

Line 2375: pv_assignment_pvt.update_routing_stage (

2371: fnd_message.Set_Token('TEXT', 'Calling pv_assignment_pvt.update_routing_stage');
2372: fnd_msg_pub.Add;
2373: END IF;
2374:
2375: pv_assignment_pvt.update_routing_stage (
2376: p_api_version_number => 1.0,
2377: p_init_msg_list => FND_API.G_FALSE,
2378: p_commit => FND_API.G_FALSE,
2379: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 2665: pv_assignment_pvt.send_notification (

2661: l_wf_activity_id := wf_engine.GetItemAttrNumber(itemtype => l_itemtype,
2662: itemkey => l_itemkey,
2663: aname => pv_workflow_pub.g_wf_attr_wf_activity_id);
2664:
2665: pv_assignment_pvt.send_notification (
2666: p_api_version_number => 1.0
2667: ,p_init_msg_list => FND_API.G_FALSE
2668: ,p_commit => FND_API.G_FALSE
2669: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 2807: l_attrib_values_rec pv_assignment_pvt.attrib_values_rec_type;

2803: l_opp_amt VARCHAR2(100);
2804: l_lead_number VARCHAR2(30);
2805:
2806: l_party_notify_rec pv_assign_util_pvt.party_notify_rec_type;
2807: l_attrib_values_rec pv_assignment_pvt.attrib_values_rec_type;
2808:
2809: cursor lc_get_routing_stage (pc_lead_id number, pc_entity varchar2) is
2810: select a.wf_item_type,
2811: a.wf_item_key,

Line 3079: fnd_message.Set_Token('TEXT','Calling pv_assignment_pvt.UpdateAssignment for assignment id:' || l_assignment_id_tbl(i));

3075: for i in 1 .. l_assignment_id_tbl.count loop
3076:
3077: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
3078: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
3079: fnd_message.Set_Token('TEXT','Calling pv_assignment_pvt.UpdateAssignment for assignment id:' || l_assignment_id_tbl(i));
3080: fnd_msg_pub.Add;
3081: END IF;
3082:
3083: pv_assignment_pvt.UpdateAssignment (

Line 3083: pv_assignment_pvt.UpdateAssignment (

3079: fnd_message.Set_Token('TEXT','Calling pv_assignment_pvt.UpdateAssignment for assignment id:' || l_assignment_id_tbl(i));
3080: fnd_msg_pub.Add;
3081: END IF;
3082:
3083: pv_assignment_pvt.UpdateAssignment (
3084: p_api_version_number => 1.0
3085: ,p_init_msg_list => FND_API.G_FALSE
3086: ,p_commit => FND_API.G_FALSE
3087: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 3167: fnd_message.Set_Token('TEXT','Calling pv_assignment_pvt.UpdateAssignment for assignment id:' || l_assignment_id_tbl(i));

3163: for i in 1 .. l_assignment_id_tbl.count loop
3164:
3165: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
3166: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
3167: fnd_message.Set_Token('TEXT','Calling pv_assignment_pvt.UpdateAssignment for assignment id:' || l_assignment_id_tbl(i));
3168: fnd_msg_pub.Add;
3169: END IF;
3170:
3171: pv_assignment_pvt.UpdateAssignment (

Line 3171: pv_assignment_pvt.UpdateAssignment (

3167: fnd_message.Set_Token('TEXT','Calling pv_assignment_pvt.UpdateAssignment for assignment id:' || l_assignment_id_tbl(i));
3168: fnd_msg_pub.Add;
3169: END IF;
3170:
3171: pv_assignment_pvt.UpdateAssignment (
3172: p_api_version_number => 1.0
3173: ,p_init_msg_list => FND_API.G_FALSE
3174: ,p_commit => FND_API.G_FALSE
3175: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 3194: fnd_message.Set_Token('TEXT','Removing rejected sales team by Calling pv_assignment_pvt.removeRejectedFromAccess' );

3190: end loop;
3191:
3192: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
3193: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
3194: fnd_message.Set_Token('TEXT','Removing rejected sales team by Calling pv_assignment_pvt.removeRejectedFromAccess' );
3195: fnd_msg_pub.Add;
3196: END IF;
3197:
3198: pv_assignment_pvt.removeRejectedFromAccess (

Line 3198: pv_assignment_pvt.removeRejectedFromAccess (

3194: fnd_message.Set_Token('TEXT','Removing rejected sales team by Calling pv_assignment_pvt.removeRejectedFromAccess' );
3195: fnd_msg_pub.Add;
3196: END IF;
3197:
3198: pv_assignment_pvt.removeRejectedFromAccess (
3199: p_api_version_number => 1.0,
3200: p_init_msg_list => FND_API.G_FALSE,
3201: p_commit => FND_API.G_FALSE,
3202: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 3240: fnd_message.Set_Token('TEXT','Update the routing stage by Calling pv_assignment_pvt.update_routing_stage' );

3236: end if;
3237:
3238: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
3239: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
3240: fnd_message.Set_Token('TEXT','Update the routing stage by Calling pv_assignment_pvt.update_routing_stage' );
3241: fnd_msg_pub.Add;
3242: END IF;
3243:
3244: pv_assignment_pvt.update_routing_stage (

Line 3244: pv_assignment_pvt.update_routing_stage (

3240: fnd_message.Set_Token('TEXT','Update the routing stage by Calling pv_assignment_pvt.update_routing_stage' );
3241: fnd_msg_pub.Add;
3242: END IF;
3243:
3244: pv_assignment_pvt.update_routing_stage (
3245: p_api_version_number => 1.0,
3246: p_init_msg_list => FND_API.G_FALSE,
3247: p_commit => FND_API.G_FALSE,
3248: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 3293: pv_assignment_pvt.StartWorkflow (

3289: l_attrib_values_rec.assignment_type := l_assignment_type;
3290: l_attrib_values_rec.assignment_type_mean := l_assign_type_mean;
3291: l_attrib_values_rec.process_name := pv_workflow_pub.g_wf_pcs_withdraw_fyi;
3292:
3293: pv_assignment_pvt.StartWorkflow (
3294: p_api_version_number => 1.0,
3295: p_init_msg_list => FND_API.G_FALSE,
3296: p_commit => FND_API.G_FALSE,
3297: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 3430: l_attrib_values_rec pv_assignment_pvt.attrib_values_rec_type;

3426: l_user_name_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
3427:
3428:
3429: l_party_notify_rec pv_assign_util_pvt.party_notify_rec_type;
3430: l_attrib_values_rec pv_assignment_pvt.attrib_values_rec_type;
3431:
3432:
3433: cursor lc_all_abandon_chk (pc_itemtype varchar2,
3434: pc_itemkey varchar2) is

Line 3650: fnd_message.Set_Token('TEXT', 'Updating assignment by calling pv_assignment_pvt.UpdateAssignment for assignment id:' || l_lead_assignment_id);

3646: end if;
3647:
3648: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
3649: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
3650: fnd_message.Set_Token('TEXT', 'Updating assignment by calling pv_assignment_pvt.UpdateAssignment for assignment id:' || l_lead_assignment_id);
3651: fnd_msg_pub.Add;
3652: END IF;
3653:
3654: pv_assignment_pvt.UpdateAssignment (

Line 3654: pv_assignment_pvt.UpdateAssignment (

3650: fnd_message.Set_Token('TEXT', 'Updating assignment by calling pv_assignment_pvt.UpdateAssignment for assignment id:' || l_lead_assignment_id);
3651: fnd_msg_pub.Add;
3652: END IF;
3653:
3654: pv_assignment_pvt.UpdateAssignment (
3655: p_api_version_number => 1.0
3656: ,p_init_msg_list => FND_API.G_FALSE
3657: ,p_commit => FND_API.G_FALSE
3658: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 3705: fnd_message.Set_Token('TEXT', 'Removing the rejected salkes team by calling pv_assignment_pvt.removeRejectedFromAccess ');

3701: END IF;
3702:
3703: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
3704: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
3705: fnd_message.Set_Token('TEXT', 'Removing the rejected salkes team by calling pv_assignment_pvt.removeRejectedFromAccess ');
3706: fnd_msg_pub.Add;
3707: END IF;
3708:
3709:

Line 3710: pv_assignment_pvt.removeRejectedFromAccess (

3706: fnd_msg_pub.Add;
3707: END IF;
3708:
3709:
3710: pv_assignment_pvt.removeRejectedFromAccess (
3711: p_api_version_number => 1.0,
3712: p_init_msg_list => FND_API.G_FALSE,
3713: p_commit => FND_API.G_FALSE,
3714: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 3741: fnd_message.Set_Token('TEXT', 'Updating the routing stage by calling pv_assignment_pvt.update_routing_stage ');

3737: fnd_msg_pub.Add;
3738: END IF;
3739: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
3740: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
3741: fnd_message.Set_Token('TEXT', 'Updating the routing stage by calling pv_assignment_pvt.update_routing_stage ');
3742: fnd_msg_pub.Add;
3743: END IF;
3744:
3745: pv_assignment_pvt.update_routing_stage (

Line 3745: pv_assignment_pvt.update_routing_stage (

3741: fnd_message.Set_Token('TEXT', 'Updating the routing stage by calling pv_assignment_pvt.update_routing_stage ');
3742: fnd_msg_pub.Add;
3743: END IF;
3744:
3745: pv_assignment_pvt.update_routing_stage (
3746: p_api_version_number => 1.0,
3747: p_init_msg_list => FND_API.G_FALSE,
3748: p_commit => FND_API.G_FALSE,
3749: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 3817: fnd_message.Set_Token('TEXT', 'Abandoning the workflow by calling pv_assignment_pvt.AbandonWorkflow ');

3813: l_attrib_values_rec.assignment_type_mean := l_assign_type_mean;
3814:
3815: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
3816: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
3817: fnd_message.Set_Token('TEXT', 'Abandoning the workflow by calling pv_assignment_pvt.AbandonWorkflow ');
3818: fnd_msg_pub.Add;
3819: END IF;
3820:
3821:

Line 3823: pv_assignment_pvt.AbandonWorkflow (

3819: END IF;
3820:
3821:
3822:
3823: pv_assignment_pvt.AbandonWorkflow (
3824: p_api_version_number => 1.0,
3825: p_init_msg_list => FND_API.G_FALSE,
3826: p_commit => FND_API.G_FALSE,
3827: p_validation_level => FND_API.G_VALID_LEVEL_FULL,