eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PV_ASSIGNMENT_PUB dependencies on PV_WORKFLOW_PUB

Line 265: (p_assignment_type NOT IN (pv_workflow_pub.g_wf_lkup_single,

261: -- Initialize API return status to success
262: x_return_status := FND_API.G_RET_STS_SUCCESS;
263:
264: if (p_assignment_type is NULL) or
265: (p_assignment_type NOT IN (pv_workflow_pub.g_wf_lkup_single,
266: pv_workflow_pub.g_wf_lkup_serial,
267: pv_workflow_pub.g_wf_lkup_joint,
268: pv_workflow_pub.g_wf_lkup_broadcast)) then
269:

Line 266: pv_workflow_pub.g_wf_lkup_serial,

262: x_return_status := FND_API.G_RET_STS_SUCCESS;
263:
264: if (p_assignment_type is NULL) or
265: (p_assignment_type NOT IN (pv_workflow_pub.g_wf_lkup_single,
266: pv_workflow_pub.g_wf_lkup_serial,
267: pv_workflow_pub.g_wf_lkup_joint,
268: pv_workflow_pub.g_wf_lkup_broadcast)) then
269:
270: fnd_message.SET_NAME('PV', 'PV_INVALID_ASSIGN_TYPE');

Line 267: pv_workflow_pub.g_wf_lkup_joint,

263:
264: if (p_assignment_type is NULL) or
265: (p_assignment_type NOT IN (pv_workflow_pub.g_wf_lkup_single,
266: pv_workflow_pub.g_wf_lkup_serial,
267: pv_workflow_pub.g_wf_lkup_joint,
268: pv_workflow_pub.g_wf_lkup_broadcast)) then
269:
270: fnd_message.SET_NAME('PV', 'PV_INVALID_ASSIGN_TYPE');
271: fnd_message.SET_TOKEN('TYPE' , p_assignment_type);

Line 268: pv_workflow_pub.g_wf_lkup_broadcast)) then

264: if (p_assignment_type is NULL) or
265: (p_assignment_type NOT IN (pv_workflow_pub.g_wf_lkup_single,
266: pv_workflow_pub.g_wf_lkup_serial,
267: pv_workflow_pub.g_wf_lkup_joint,
268: pv_workflow_pub.g_wf_lkup_broadcast)) then
269:
270: fnd_message.SET_NAME('PV', 'PV_INVALID_ASSIGN_TYPE');
271: fnd_message.SET_TOKEN('TYPE' , p_assignment_type);
272: fnd_msg_pub.ADD;

Line 494: if l_vad_id = p_partner_id_tbl(i) and p_assignment_type <> pv_workflow_pub.g_wf_lkup_joint then

490: close lc_validate_vad_pt;
491:
492: if l_pt_org_name is null then
493:
494: if l_vad_id = p_partner_id_tbl(i) and p_assignment_type <> pv_workflow_pub.g_wf_lkup_joint then
495:
496: fnd_message.SET_NAME('PV', 'PV_SELF_ADD_JOINT_ONLY');
497: fnd_msg_pub.ADD;
498: raise FND_API.G_EXC_ERROR;

Line 500: elsif l_vad_id = p_partner_id_tbl(i) and p_assignment_type = pv_workflow_pub.g_wf_lkup_joint then

496: fnd_message.SET_NAME('PV', 'PV_SELF_ADD_JOINT_ONLY');
497: fnd_msg_pub.ADD;
498: raise FND_API.G_EXC_ERROR;
499:
500: elsif l_vad_id = p_partner_id_tbl(i) and p_assignment_type = pv_workflow_pub.g_wf_lkup_joint then
501: null;
502: else
503:
504: open lc_get_pt_org_name (pc_partner_id => l_partner_id_tbl(i));

Line 525: if p_assignment_type = pv_workflow_pub.g_wf_lkup_serial then

521: fnd_msg_pub.ADD;
522: raise FND_API.G_EXC_ERROR;
523: end if; -- l_user_category = g_resource_party
524:
525: if p_assignment_type = pv_workflow_pub.g_wf_lkup_serial then
526: for v_count IN 1..l_partner_id_tbl.count loop
527:
528: if p_rank_tbl(v_count) IS NULL THEN
529: fnd_message.SET_NAME('PV', 'PV_DEBUG_MESSAGE');

Line 536: end if; -- p_assignment_type = pv_workflow_pub.g_wf_lkup_serial

532:
533: raise FND_API.G_EXC_ERROR;
534: end if;
535: end loop;
536: end if; -- p_assignment_type = pv_workflow_pub.g_wf_lkup_serial
537:
538: if (p_assignment_type = pv_workflow_pub.g_wf_lkup_single and p_partner_id_tbl.count > 1) then
539:
540: for v_count IN 1..l_partner_id_tbl.count loop

Line 538: if (p_assignment_type = pv_workflow_pub.g_wf_lkup_single and p_partner_id_tbl.count > 1) then

534: end if;
535: end loop;
536: end if; -- p_assignment_type = pv_workflow_pub.g_wf_lkup_serial
537:
538: if (p_assignment_type = pv_workflow_pub.g_wf_lkup_single and p_partner_id_tbl.count > 1) then
539:
540: for v_count IN 1..l_partner_id_tbl.count loop
541:
542: if p_rank_tbl(v_count) IS NULL THEN

Line 745: l_itemtype := pv_workflow_pub.g_wf_itemtype_pvasgnmt;

741: end if;
742:
743: -- the following is executed for new, recycled and abandoned workflows only
744:
745: l_itemtype := pv_workflow_pub.g_wf_itemtype_pvasgnmt;
746:
747: l_lead_workflow_rec.created_by := l_user_id;
748: l_lead_workflow_rec.last_updated_by := l_user_id;
749: l_lead_workflow_rec.lead_id := p_lead_id;

Line 1128: l_attrib_values_rec.process_name := pv_workflow_pub.g_wf_pcs_initiate_assignment;

1124: l_attrib_values_rec.customer_name := l_customer_name;
1125: l_attrib_values_rec.assignment_type := p_assignment_type;
1126: l_attrib_values_rec.bypass_cm_ok_flag := p_bypass_cm_ok_flag;
1127: l_attrib_values_rec.process_rule_id := p_process_rule_id;
1128: l_attrib_values_rec.process_name := pv_workflow_pub.g_wf_pcs_initiate_assignment;
1129:
1130: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1131: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1132: fnd_message.Set_Token('TEXT', 'before calling startworkflow Entity Amount'||l_entity_amount);

Line 1361: if l_assignment_type = pv_workflow_pub.g_wf_lkup_serial then

1357: open lc_get_assignment_type (pc_lead_id => p_lead_id, pc_entity => p_entity);
1358: fetch lc_get_assignment_type into l_assignment_type;
1359: close lc_get_assignment_type;
1360:
1361: if l_assignment_type = pv_workflow_pub.g_wf_lkup_serial then
1362:
1363: for i in 1 .. p_rank_tbl.count loop
1364:
1365: for j in 1+i .. p_rank_tbl.count loop

Line 1379: if l_assignment_type = pv_workflow_pub.g_wf_lkup_single then

1375: end loop;
1376:
1377: end if;
1378:
1379: if l_assignment_type = pv_workflow_pub.g_wf_lkup_single then
1380:
1381: if p_partyTbl.count > 1 then
1382:
1383: for i in 1 .. p_statusTbl.count loop

Line 1585: aname => pv_workflow_pub.g_wf_attr_organization_type);

1581: -- check for new partners
1582: -- Obsoleted for 11.5.10
1583: l_mode := wf_engine.GetItemAttrText( itemtype => l_itemtype,
1584: itemkey => l_itemkey,
1585: aname => pv_workflow_pub.g_wf_attr_organization_type);
1586:
1587: for i in 1 .. p_partyTbl.last loop
1588:
1589: if p_statusTbl(i) in (g_la_status_cm_added,g_la_status_cm_add_app_for_pt) then

Line 1783: l_match_outcome := pv_workflow_pub.g_wf_lkup_match_approved;

1779: -- every decision maker has responded
1780:
1781: if l_approve_flag then
1782:
1783: l_match_outcome := pv_workflow_pub.g_wf_lkup_match_approved;
1784:
1785: elsif l_reject_flag then
1786:
1787: l_match_outcome := pv_workflow_pub.g_wf_lkup_match_rejected;

Line 1787: l_match_outcome := pv_workflow_pub.g_wf_lkup_match_rejected;

1783: l_match_outcome := pv_workflow_pub.g_wf_lkup_match_approved;
1784:
1785: elsif l_reject_flag then
1786:
1787: l_match_outcome := pv_workflow_pub.g_wf_lkup_match_rejected;
1788:
1789: end if;
1790:
1791: wf_engine.SetItemAttrText (itemtype => l_itemType,

Line 1793: aname => pv_workflow_pub.g_wf_attr_routing_outcome,

1789: end if;
1790:
1791: wf_engine.SetItemAttrText (itemtype => l_itemType,
1792: itemkey => l_itemKey,
1793: aname => pv_workflow_pub.g_wf_attr_routing_outcome,
1794: avalue => l_match_outcome);
1795:
1796: wf_engine.CompleteActivity( itemtype => l_itemtype,
1797: itemkey => l_itemkey,

Line 1798: activity => pv_workflow_pub.g_wf_fn_cm_response_block,

1794: avalue => l_match_outcome);
1795:
1796: wf_engine.CompleteActivity( itemtype => l_itemtype,
1797: itemkey => l_itemkey,
1798: activity => pv_workflow_pub.g_wf_fn_cm_response_block,
1799: result => l_match_outcome);
1800:
1801: -- For RUN mode errors, you need to check wf_item_activity_statuses
1802:

Line 2145: aname => pv_workflow_pub.g_wf_attr_assignment_type);

2141: end if;
2142:
2143: l_assignment_type := wf_engine.GetItemAttrText( itemtype => l_itemtype,
2144: itemkey => l_itemkey,
2145: aname => pv_workflow_pub.g_wf_attr_assignment_type);
2146:
2147: if l_assignment_type not in (pv_workflow_pub.g_wf_lkup_single,
2148: pv_workflow_pub.g_wf_lkup_serial,
2149: pv_workflow_pub.g_wf_lkup_joint,

Line 2147: if l_assignment_type not in (pv_workflow_pub.g_wf_lkup_single,

2143: l_assignment_type := wf_engine.GetItemAttrText( itemtype => l_itemtype,
2144: itemkey => l_itemkey,
2145: aname => pv_workflow_pub.g_wf_attr_assignment_type);
2146:
2147: if l_assignment_type not in (pv_workflow_pub.g_wf_lkup_single,
2148: pv_workflow_pub.g_wf_lkup_serial,
2149: pv_workflow_pub.g_wf_lkup_joint,
2150: pv_workflow_pub.g_wf_lkup_broadcast) then
2151:

Line 2148: pv_workflow_pub.g_wf_lkup_serial,

2144: itemkey => l_itemkey,
2145: aname => pv_workflow_pub.g_wf_attr_assignment_type);
2146:
2147: if l_assignment_type not in (pv_workflow_pub.g_wf_lkup_single,
2148: pv_workflow_pub.g_wf_lkup_serial,
2149: pv_workflow_pub.g_wf_lkup_joint,
2150: pv_workflow_pub.g_wf_lkup_broadcast) then
2151:
2152: fnd_message.Set_Name('PV', 'PV_NOT_VALID_ASGNMENT_TYPE');

Line 2149: pv_workflow_pub.g_wf_lkup_joint,

2145: aname => pv_workflow_pub.g_wf_attr_assignment_type);
2146:
2147: if l_assignment_type not in (pv_workflow_pub.g_wf_lkup_single,
2148: pv_workflow_pub.g_wf_lkup_serial,
2149: pv_workflow_pub.g_wf_lkup_joint,
2150: pv_workflow_pub.g_wf_lkup_broadcast) then
2151:
2152: fnd_message.Set_Name('PV', 'PV_NOT_VALID_ASGNMENT_TYPE');
2153: fnd_message.set_Token('P_ASGNMENT_TYPE', l_assignment_type);

Line 2150: pv_workflow_pub.g_wf_lkup_broadcast) then

2146:
2147: if l_assignment_type not in (pv_workflow_pub.g_wf_lkup_single,
2148: pv_workflow_pub.g_wf_lkup_serial,
2149: pv_workflow_pub.g_wf_lkup_joint,
2150: pv_workflow_pub.g_wf_lkup_broadcast) then
2151:
2152: fnd_message.Set_Name('PV', 'PV_NOT_VALID_ASGNMENT_TYPE');
2153: fnd_message.set_Token('P_ASGNMENT_TYPE', l_assignment_type);
2154: fnd_msg_pub.ADD;

Line 2173: if l_assignment_type = pv_workflow_pub.g_wf_lkup_serial then

2169: END IF;
2170:
2171:
2172:
2173: if l_assignment_type = pv_workflow_pub.g_wf_lkup_serial then
2174:
2175: l_current_rank := wf_engine.GetItemAttrNumber( itemtype => l_itemtype,
2176: itemkey => l_itemkey,
2177: aname => pv_workflow_pub.g_wf_attr_current_serial_rank);

Line 2177: aname => pv_workflow_pub.g_wf_attr_current_serial_rank);

2173: if l_assignment_type = pv_workflow_pub.g_wf_lkup_serial then
2174:
2175: l_current_rank := wf_engine.GetItemAttrNumber( itemtype => l_itemtype,
2176: itemkey => l_itemkey,
2177: aname => pv_workflow_pub.g_wf_attr_current_serial_rank);
2178: if l_rank <> l_current_rank then
2179: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2180: fnd_message.set_Token('TEXT', 'Not partner''s turn yet. Partner rank is ' || l_rank ||
2181: '. Current rank is ' || l_current_rank);

Line 2188: if l_assignment_type = pv_workflow_pub.g_wf_lkup_joint then

2184: end if;
2185:
2186: end if;
2187:
2188: if l_assignment_type = pv_workflow_pub.g_wf_lkup_joint then
2189:
2190: -- this should only happen in joint and if the user has used the browser back button as
2191: -- detailed in bug 3258485
2192:

Line 2350: aname => pv_workflow_pub.g_wf_attr_customer_id);

2346: end if;
2347:
2348: l_customer_id := wf_engine.GetItemAttrNumber( itemtype => l_itemtype,
2349: itemkey => l_itemkey,
2350: aname => pv_workflow_pub.g_wf_attr_customer_id);
2351:
2352: if p_pt_response in (g_la_status_pt_approved, g_la_status_cm_app_for_pt) then
2353:
2354: if l_assignment_type = pv_workflow_pub.g_wf_lkup_joint then

Line 2354: if l_assignment_type = pv_workflow_pub.g_wf_lkup_joint then

2350: aname => pv_workflow_pub.g_wf_attr_customer_id);
2351:
2352: if p_pt_response in (g_la_status_pt_approved, g_la_status_cm_app_for_pt) then
2353:
2354: if l_assignment_type = pv_workflow_pub.g_wf_lkup_joint then
2355:
2356: -- someone else may have already accepted
2357:
2358: if l_routing_status <> pv_assignment_pub.g_r_status_active then

Line 2396: if l_assignment_type in (pv_workflow_pub.g_wf_lkup_single,

2392: end if;
2393:
2394: end if; -- l_assignment_type
2395:
2396: if l_assignment_type in (pv_workflow_pub.g_wf_lkup_single,
2397: pv_workflow_pub.g_wf_lkup_serial,
2398: pv_workflow_pub.g_wf_lkup_broadcast) then
2399:
2400: wf_engine.CompleteActivity( itemtype => l_itemtype,

Line 2397: pv_workflow_pub.g_wf_lkup_serial,

2393:
2394: end if; -- l_assignment_type
2395:
2396: if l_assignment_type in (pv_workflow_pub.g_wf_lkup_single,
2397: pv_workflow_pub.g_wf_lkup_serial,
2398: pv_workflow_pub.g_wf_lkup_broadcast) then
2399:
2400: wf_engine.CompleteActivity( itemtype => l_itemtype,
2401: itemkey => l_itemkey,

Line 2398: pv_workflow_pub.g_wf_lkup_broadcast) then

2394: end if; -- l_assignment_type
2395:
2396: if l_assignment_type in (pv_workflow_pub.g_wf_lkup_single,
2397: pv_workflow_pub.g_wf_lkup_serial,
2398: pv_workflow_pub.g_wf_lkup_broadcast) then
2399:
2400: wf_engine.CompleteActivity( itemtype => l_itemtype,
2401: itemkey => l_itemkey,
2402: activity => pv_workflow_pub.g_wf_fn_pt_response_block,

Line 2402: activity => pv_workflow_pub.g_wf_fn_pt_response_block,

2398: pv_workflow_pub.g_wf_lkup_broadcast) then
2399:
2400: wf_engine.CompleteActivity( itemtype => l_itemtype,
2401: itemkey => l_itemkey,
2402: activity => pv_workflow_pub.g_wf_fn_pt_response_block,
2403: result => pv_workflow_pub.g_wf_lkup_offer_approved );
2404:
2405: elsif l_assignment_type = pv_workflow_pub.g_wf_lkup_joint then
2406:

Line 2403: result => pv_workflow_pub.g_wf_lkup_offer_approved );

2399:
2400: wf_engine.CompleteActivity( itemtype => l_itemtype,
2401: itemkey => l_itemkey,
2402: activity => pv_workflow_pub.g_wf_fn_pt_response_block,
2403: result => pv_workflow_pub.g_wf_lkup_offer_approved );
2404:
2405: elsif l_assignment_type = pv_workflow_pub.g_wf_lkup_joint then
2406:
2407: open lc_any_pt_not_respond_chk( pc_itemtype => l_itemtype,

Line 2405: elsif l_assignment_type = pv_workflow_pub.g_wf_lkup_joint then

2401: itemkey => l_itemkey,
2402: activity => pv_workflow_pub.g_wf_fn_pt_response_block,
2403: result => pv_workflow_pub.g_wf_lkup_offer_approved );
2404:
2405: elsif l_assignment_type = pv_workflow_pub.g_wf_lkup_joint then
2406:
2407: open lc_any_pt_not_respond_chk( pc_itemtype => l_itemtype,
2408: pc_itemkey => l_itemkey);
2409:

Line 2418: activity => pv_workflow_pub.g_wf_fn_pt_response_block,

2414: if l_notify_rowid is null then
2415:
2416: wf_engine.CompleteActivity( itemtype => l_itemtype,
2417: itemkey => l_itemkey,
2418: activity => pv_workflow_pub.g_wf_fn_pt_response_block,
2419: result => pv_workflow_pub.g_wf_lkup_offer_approved );
2420: end if;
2421:
2422: end if;

Line 2419: result => pv_workflow_pub.g_wf_lkup_offer_approved );

2415:
2416: wf_engine.CompleteActivity( itemtype => l_itemtype,
2417: itemkey => l_itemkey,
2418: activity => pv_workflow_pub.g_wf_fn_pt_response_block,
2419: result => pv_workflow_pub.g_wf_lkup_offer_approved );
2420: end if;
2421:
2422: end if;
2423:

Line 2597: if l_assignment_type in (pv_workflow_pub.g_wf_lkup_single,

2593: end if;
2594:
2595: end loop;
2596:
2597: if l_assignment_type in (pv_workflow_pub.g_wf_lkup_single,
2598: pv_workflow_pub.g_wf_lkup_serial) then
2599:
2600: wf_engine.CompleteActivity( itemtype => l_itemtype,
2601: itemkey => l_itemkey,

Line 2598: pv_workflow_pub.g_wf_lkup_serial) then

2594:
2595: end loop;
2596:
2597: if l_assignment_type in (pv_workflow_pub.g_wf_lkup_single,
2598: pv_workflow_pub.g_wf_lkup_serial) then
2599:
2600: wf_engine.CompleteActivity( itemtype => l_itemtype,
2601: itemkey => l_itemkey,
2602: activity => pv_workflow_pub.g_wf_fn_pt_response_block,

Line 2602: activity => pv_workflow_pub.g_wf_fn_pt_response_block,

2598: pv_workflow_pub.g_wf_lkup_serial) then
2599:
2600: wf_engine.CompleteActivity( itemtype => l_itemtype,
2601: itemkey => l_itemkey,
2602: activity => pv_workflow_pub.g_wf_fn_pt_response_block,
2603: result => pv_workflow_pub.g_wf_lkup_offer_rejected );
2604:
2605: elsif l_assignment_type = pv_workflow_pub.g_wf_lkup_broadcast then
2606:

Line 2603: result => pv_workflow_pub.g_wf_lkup_offer_rejected );

2599:
2600: wf_engine.CompleteActivity( itemtype => l_itemtype,
2601: itemkey => l_itemkey,
2602: activity => pv_workflow_pub.g_wf_fn_pt_response_block,
2603: result => pv_workflow_pub.g_wf_lkup_offer_rejected );
2604:
2605: elsif l_assignment_type = pv_workflow_pub.g_wf_lkup_broadcast then
2606:
2607:

Line 2605: elsif l_assignment_type = pv_workflow_pub.g_wf_lkup_broadcast then

2601: itemkey => l_itemkey,
2602: activity => pv_workflow_pub.g_wf_fn_pt_response_block,
2603: result => pv_workflow_pub.g_wf_lkup_offer_rejected );
2604:
2605: elsif l_assignment_type = pv_workflow_pub.g_wf_lkup_broadcast then
2606:
2607:
2608: open lc_any_pt_not_respond_chk( pc_itemtype => l_itemtype,
2609: pc_itemkey => l_itemkey);

Line 2619: activity => pv_workflow_pub.g_wf_fn_pt_response_block,

2615: if l_notify_rowid is null then
2616:
2617: wf_engine.CompleteActivity( itemtype => l_itemtype,
2618: itemkey => l_itemkey,
2619: activity => pv_workflow_pub.g_wf_fn_pt_response_block,
2620: result => pv_workflow_pub.g_wf_lkup_offer_rejected);
2621: end if;
2622:
2623: elsif l_assignment_type = pv_workflow_pub.g_wf_lkup_joint then

Line 2620: result => pv_workflow_pub.g_wf_lkup_offer_rejected);

2616:
2617: wf_engine.CompleteActivity( itemtype => l_itemtype,
2618: itemkey => l_itemkey,
2619: activity => pv_workflow_pub.g_wf_fn_pt_response_block,
2620: result => pv_workflow_pub.g_wf_lkup_offer_rejected);
2621: end if;
2622:
2623: elsif l_assignment_type = pv_workflow_pub.g_wf_lkup_joint then
2624:

Line 2623: elsif l_assignment_type = pv_workflow_pub.g_wf_lkup_joint then

2619: activity => pv_workflow_pub.g_wf_fn_pt_response_block,
2620: result => pv_workflow_pub.g_wf_lkup_offer_rejected);
2621: end if;
2622:
2623: elsif l_assignment_type = pv_workflow_pub.g_wf_lkup_joint then
2624:
2625:
2626: open lc_any_pt_not_respond_chk( pc_itemtype => l_itemtype,
2627: pc_itemkey => l_itemkey);

Line 2646: activity => pv_workflow_pub.g_wf_fn_pt_response_block,

2642: if l_notify_rowid is null then
2643:
2644: wf_engine.CompleteActivity( itemtype => l_itemtype,
2645: itemkey => l_itemkey,
2646: activity => pv_workflow_pub.g_wf_fn_pt_response_block,
2647: result => pv_workflow_pub.g_wf_lkup_offer_rejected);
2648: else
2649:
2650: wf_engine.CompleteActivity( itemtype => l_itemtype,

Line 2647: result => pv_workflow_pub.g_wf_lkup_offer_rejected);

2643:
2644: wf_engine.CompleteActivity( itemtype => l_itemtype,
2645: itemkey => l_itemkey,
2646: activity => pv_workflow_pub.g_wf_fn_pt_response_block,
2647: result => pv_workflow_pub.g_wf_lkup_offer_rejected);
2648: else
2649:
2650: wf_engine.CompleteActivity( itemtype => l_itemtype,
2651: itemkey => l_itemkey,

Line 2652: activity => pv_workflow_pub.g_wf_fn_pt_response_block,

2648: else
2649:
2650: wf_engine.CompleteActivity( itemtype => l_itemtype,
2651: itemkey => l_itemkey,
2652: activity => pv_workflow_pub.g_wf_fn_pt_response_block,
2653: result => pv_workflow_pub.g_wf_lkup_offer_approved);
2654: end if;
2655:
2656: end if;

Line 2653: result => pv_workflow_pub.g_wf_lkup_offer_approved);

2649:
2650: wf_engine.CompleteActivity( itemtype => l_itemtype,
2651: itemkey => l_itemkey,
2652: activity => pv_workflow_pub.g_wf_fn_pt_response_block,
2653: result => pv_workflow_pub.g_wf_lkup_offer_approved);
2654: end if;
2655:
2656: end if;
2657: end if;

Line 2663: aname => pv_workflow_pub.g_wf_attr_wf_activity_id);

2659: end if; -- partner response
2660:
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

Line 2978: aname => pv_workflow_pub.g_wf_attr_current_serial_rank);

2974: elsif l_routing_stage in (g_r_status_matched, g_r_status_offered) then
2975:
2976: l_rank := wf_engine.GetItemAttrNumber( itemtype => l_itemtype,
2977: itemkey => l_itemkey,
2978: aname => pv_workflow_pub.g_wf_attr_current_serial_rank);
2979:
2980: open lc_get_assignment (pc_lead_id => p_lead_id, pc_entity => p_entity);
2981: loop
2982: fetch lc_get_assignment into l_assignment_id, l_assign_sequence, l_status;

Line 2985: IF l_assignment_type = pv_workflow_pub.g_wf_lkup_serial

2981: loop
2982: fetch lc_get_assignment into l_assignment_id, l_assign_sequence, l_status;
2983: exit when lc_get_assignment%notfound;
2984:
2985: IF l_assignment_type = pv_workflow_pub.g_wf_lkup_serial
2986: AND ( l_assign_sequence < l_rank OR l_status = g_la_status_cm_rejected ) THEN
2987:
2988: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2989: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

Line 2994: ELSIF l_assignment_type in (pv_workflow_pub.g_wf_lkup_broadcast, pv_workflow_pub.g_wf_lkup_joint)

2990: fnd_message.Set_Token('TEXT','Partner is not a current partner or the oppty to this partner might have been rejetced by CM');
2991: fnd_msg_pub.Add;
2992: END IF;
2993:
2994: ELSIF l_assignment_type in (pv_workflow_pub.g_wf_lkup_broadcast, pv_workflow_pub.g_wf_lkup_joint)
2995: AND l_status not in (pv_assignment_pub.g_la_status_cm_added,
2996: pv_assignment_pub.g_la_status_cm_approved,
2997: pv_assignment_pub.g_la_status_cm_bypassed,
2998: pv_assignment_pub.g_la_status_assigned,

Line 3028: IF l_assignment_type = pv_workflow_pub.g_wf_lkup_serial

3024: if l_routing_stage = g_r_status_matched then
3025:
3026: for i in 1 .. l_assignment_id_tbl.count loop
3027:
3028: IF l_assignment_type = pv_workflow_pub.g_wf_lkup_serial
3029: AND l_status_tbl(i) = g_la_status_cm_rejected THEN
3030:
3031: NULL;
3032:

Line 3036: l_activity := pv_workflow_pub.g_wf_fn_cm_response_block;

3032:
3033: ELSE
3034:
3035: l_assignment_status := g_la_status_match_withdrawn;
3036: l_activity := pv_workflow_pub.g_wf_fn_cm_response_block;
3037: l_result := pv_workflow_pub.g_wf_lkup_match_withdrawn;
3038:
3039: END IF;
3040: end loop;

Line 3037: l_result := pv_workflow_pub.g_wf_lkup_match_withdrawn;

3033: ELSE
3034:
3035: l_assignment_status := g_la_status_match_withdrawn;
3036: l_activity := pv_workflow_pub.g_wf_fn_cm_response_block;
3037: l_result := pv_workflow_pub.g_wf_lkup_match_withdrawn;
3038:
3039: END IF;
3040: end loop;
3041: -- offer withdrawn

Line 3046: IF l_assignment_type = pv_workflow_pub.g_wf_lkup_serial AND l_rank_tbl(i) < l_rank THEN

3042: elsif l_routing_stage = g_r_status_offered then
3043:
3044: for i in 1 .. l_assignment_id_tbl.count loop
3045:
3046: IF l_assignment_type = pv_workflow_pub.g_wf_lkup_serial AND l_rank_tbl(i) < l_rank THEN
3047:
3048: null;
3049:
3050: ELSIF l_assignment_type in (pv_workflow_pub.g_wf_lkup_broadcast, pv_workflow_pub.g_wf_lkup_joint)

Line 3050: ELSIF l_assignment_type in (pv_workflow_pub.g_wf_lkup_broadcast, pv_workflow_pub.g_wf_lkup_joint)

3046: IF l_assignment_type = pv_workflow_pub.g_wf_lkup_serial AND l_rank_tbl(i) < l_rank THEN
3047:
3048: null;
3049:
3050: ELSIF l_assignment_type in (pv_workflow_pub.g_wf_lkup_broadcast, pv_workflow_pub.g_wf_lkup_joint)
3051: AND l_status_tbl(i) in (pv_assignment_pub.g_la_status_pt_rejected,
3052: pv_assignment_pub.g_la_status_cm_rejected,
3053: pv_assignment_pub.g_la_status_lost_chance)
3054: THEN

Line 3061: l_activity := pv_workflow_pub.g_wf_fn_pt_response_block;

3057:
3058: ELSE
3059:
3060: l_assignment_status := g_la_status_offer_withdrawn;
3061: l_activity := pv_workflow_pub.g_wf_fn_pt_response_block;
3062:
3063: l_result := pv_workflow_pub.g_wf_lkup_offer_withdrawn;
3064: END IF;
3065:

Line 3063: l_result := pv_workflow_pub.g_wf_lkup_offer_withdrawn;

3059:
3060: l_assignment_status := g_la_status_offer_withdrawn;
3061: l_activity := pv_workflow_pub.g_wf_fn_pt_response_block;
3062:
3063: l_result := pv_workflow_pub.g_wf_lkup_offer_withdrawn;
3064: END IF;
3065:
3066: end loop;
3067:

Line 3072: aname => pv_workflow_pub.g_wf_attr_routing_outcome,

3068: end if; -- 2: l_routing_stage
3069:
3070: wf_engine.SetItemAttrText (itemtype => l_itemType,
3071: itemkey => l_itemKey,
3072: aname => pv_workflow_pub.g_wf_attr_routing_outcome,
3073: avalue => l_result);
3074:
3075: for i in 1 .. l_assignment_id_tbl.count loop
3076:

Line 3291: l_attrib_values_rec.process_name := pv_workflow_pub.g_wf_pcs_withdraw_fyi;

3287: l_attrib_values_rec.entity_amount := l_opp_amt;
3288: l_attrib_values_rec.customer_name := l_customer_name;
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,