DBA Data[Home] [Help]

APPS.PV_WORKFLOW_PUB dependencies on FND_MESSAGE

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

45:
46: BEGIN
47:
48: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
49: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
50: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || ' Funcmode: ' || funcmode);
51: fnd_msg_pub.Add;
52: END IF;
53:

Line 50: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || ' Funcmode: ' || funcmode);

46: BEGIN
47:
48: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
49: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
50: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || ' Funcmode: ' || funcmode);
51: fnd_msg_pub.Add;
52: END IF;
53:
54: if (funcmode = 'RUN') then

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

59:
60: if l_temp not in (g_wf_lkup_yes,
61: g_wf_lkup_no) or l_temp is null then
62:
63: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
64: fnd_message.Set_token('TEXT', 'Invalid bypass CM Approval flag: ' || l_temp);
65: fnd_msg_pub.Add;
66: raise FND_API.G_EXC_ERROR;
67:

Line 64: fnd_message.Set_token('TEXT', 'Invalid bypass CM Approval flag: ' || l_temp);

60: if l_temp not in (g_wf_lkup_yes,
61: g_wf_lkup_no) or l_temp is null then
62:
63: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
64: fnd_message.Set_token('TEXT', 'Invalid bypass CM Approval flag: ' || l_temp);
65: fnd_msg_pub.Add;
66: raise FND_API.G_EXC_ERROR;
67:
68: end if;

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

67:
68: end if;
69:
70: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
71: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
72: fnd_message.Set_Token('TEXT', 'Bypass CM: ' || l_temp);
73: fnd_msg_pub.Add;
74: END IF;
75:

Line 72: fnd_message.Set_Token('TEXT', 'Bypass CM: ' || l_temp);

68: end if;
69:
70: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
71: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
72: fnd_message.Set_Token('TEXT', 'Bypass CM: ' || l_temp);
73: fnd_msg_pub.Add;
74: END IF;
75:
76: if l_temp = g_wf_lkup_yes then -- bypass CM OK

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

176:
177: BEGIN
178:
179: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
180: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
181: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || ' Funcmode: ' || funcmode);
182: fnd_msg_pub.Add;
183: END IF;
184:

Line 181: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || ' Funcmode: ' || funcmode);

177: BEGIN
178:
179: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
180: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
181: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || ' Funcmode: ' || funcmode);
182: fnd_msg_pub.Add;
183: END IF;
184:
185: if (funcmode = 'RUN') then

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

287:
288: BEGIN
289:
290: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
291: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
292: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || ' Funcmode: ' || funcmode);
293: fnd_msg_pub.Add;
294: END IF;
295:

Line 292: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || ' Funcmode: ' || funcmode);

288: BEGIN
289:
290: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
291: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
292: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || ' Funcmode: ' || funcmode);
293: fnd_msg_pub.Add;
294: END IF;
295:
296: if (funcmode = 'RUN') then

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

444:
445: BEGIN
446:
447: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
448: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
449: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || ' Funcmode: ' || funcmode);
450: fnd_msg_pub.Add;
451: END IF;
452:

Line 449: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || ' Funcmode: ' || funcmode);

445: BEGIN
446:
447: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
448: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
449: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || ' Funcmode: ' || funcmode);
450: fnd_msg_pub.Add;
451: END IF;
452:
453: if (funcmode = 'RUN') then

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

557:
558: BEGIN
559:
560: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
561: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
562: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || ' Funcmode: ' || funcmode);
563: fnd_msg_pub.Add;
564: END IF;
565:

Line 562: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || ' Funcmode: ' || funcmode);

558: BEGIN
559:
560: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
561: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
562: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || ' Funcmode: ' || funcmode);
563: fnd_msg_pub.Add;
564: END IF;
565:
566: if (funcmode = 'RUN') then

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

610: fetch lc_get_pt_id into l_partner_id, l_assign_sequence;
611:
612: if lc_get_pt_id%notfound then
613:
614: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
615: fnd_message.SET_TOKEN('TEXT', 'Cannot find Partner ID for itemkey: ' || itemkey );
616: fnd_msg_pub.ADD;
617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
618:

Line 615: fnd_message.SET_TOKEN('TEXT', 'Cannot find Partner ID for itemkey: ' || itemkey );

611:
612: if lc_get_pt_id%notfound then
613:
614: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
615: fnd_message.SET_TOKEN('TEXT', 'Cannot find Partner ID for itemkey: ' || itemkey );
616: fnd_msg_pub.ADD;
617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
618:
619: end if;

Line 627: fnd_message.Set_Name('PV', 'PV_MULTIPLE_PRTNR_SINGLE');

623: fetch lc_get_pt_id into l_partner_id, l_assign_sequence;
624:
625: if lc_get_pt_id%found then
626:
627: fnd_message.Set_Name('PV', 'PV_MULTIPLE_PRTNR_SINGLE');
628: fnd_msg_pub.ADD;
629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
630:
631: end if;

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

654: fetch lc_get_pt_id into l_partner_id, l_assign_sequence;
655:
656: if lc_get_pt_id%notfound then
657:
658: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
659: fnd_message.SET_TOKEN('TEXT', 'Cannot find Partner ID for itemkey: ' || itemkey );
660: fnd_msg_pub.ADD;
661: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
662:

Line 659: fnd_message.SET_TOKEN('TEXT', 'Cannot find Partner ID for itemkey: ' || itemkey );

655:
656: if lc_get_pt_id%notfound then
657:
658: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
659: fnd_message.SET_TOKEN('TEXT', 'Cannot find Partner ID for itemkey: ' || itemkey );
660: fnd_msg_pub.ADD;
661: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
662:
663: end if;

Line 711: fnd_message.Set_Name('PV', 'PV_INVALID_ASSIGN_TYPE');

707: end if;
708:
709: else
710:
711: fnd_message.Set_Name('PV', 'PV_INVALID_ASSIGN_TYPE');
712: fnd_message.SET_TOKEN('TYPE', l_assignment_type);
713: fnd_msg_pub.ADD;
714: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
715:

Line 712: fnd_message.SET_TOKEN('TYPE', l_assignment_type);

708:
709: else
710:
711: fnd_message.Set_Name('PV', 'PV_INVALID_ASSIGN_TYPE');
712: fnd_message.SET_TOKEN('TYPE', l_assignment_type);
713: fnd_msg_pub.ADD;
714: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
715:
716: end if;

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

809: order by assign_sequence;
810:
811: BEGIN
812: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
813: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
814: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || ' Funcmode: ' || funcmode);
815: fnd_msg_pub.Add;
816: END IF;
817:

Line 814: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || ' Funcmode: ' || funcmode);

810:
811: BEGIN
812: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
813: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
814: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || ' Funcmode: ' || funcmode);
815: fnd_msg_pub.Add;
816: END IF;
817:
818: if (funcmode = 'RUN') then

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

982:
983: BEGIN
984:
985: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
986: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
987: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || ' Funcmode: ' || funcmode);
988: fnd_msg_pub.Add;
989: END IF;
990:

Line 987: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || ' Funcmode: ' || funcmode);

983: BEGIN
984:
985: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
986: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
987: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || ' Funcmode: ' || funcmode);
988: fnd_msg_pub.Add;
989: END IF;
990:
991: if (funcmode = 'RUN') then

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

1313: pv_assignment_pub.g_la_status_cm_approved);
1314:
1315: BEGIN
1316: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1317: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1318: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || ' Funcmode: ' || funcmode);
1319: fnd_msg_pub.Add;
1320: END IF;
1321:

Line 1318: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || ' Funcmode: ' || funcmode);

1314:
1315: BEGIN
1316: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1317: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1318: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || ' Funcmode: ' || funcmode);
1319: fnd_msg_pub.Add;
1320: END IF;
1321:
1322: if (funcmode = 'RUN') then

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

1403: end if; -- assignment type check
1404:
1405: if l_response_tbl.count = 0 then
1406:
1407: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1408: fnd_message.Set_Token('TEXT', 'Cannot find assignment (itemkey): ' || itemkey);
1409: fnd_msg_pub.Add;
1410:
1411: raise FND_API.G_EXC_ERROR;

Line 1408: fnd_message.Set_Token('TEXT', 'Cannot find assignment (itemkey): ' || itemkey);

1404:
1405: if l_response_tbl.count = 0 then
1406:
1407: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1408: fnd_message.Set_Token('TEXT', 'Cannot find assignment (itemkey): ' || itemkey);
1409: fnd_msg_pub.Add;
1410:
1411: raise FND_API.G_EXC_ERROR;
1412:

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

1548: fetch lc_get_pt_org into l_partner_org_rs_id;
1549: exit when lc_get_pt_org%notfound;
1550:
1551: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1552: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1553: fnd_message.Set_Token('TEXT', 'partner org rs id for timeout '||l_partner_org_rs_id);
1554: fnd_msg_pub.Add;
1555: END IF;
1556:

Line 1553: fnd_message.Set_Token('TEXT', 'partner org rs id for timeout '||l_partner_org_rs_id);

1549: exit when lc_get_pt_org%notfound;
1550:
1551: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1552: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1553: fnd_message.Set_Token('TEXT', 'partner org rs id for timeout '||l_partner_org_rs_id);
1554: fnd_msg_pub.Add;
1555: END IF;
1556:
1557: pv_assign_util_pvt.updateaccess(

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

1759: fetch lc_get_pt_lc_org into l_lc_partner_rs_id;
1760: exit when lc_get_pt_lc_org%notfound;
1761:
1762: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1763: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1764: fnd_message.Set_Token('TEXT', 'partner org rs id for timeout '||l_partner_org_rs_id);
1765: fnd_msg_pub.Add;
1766: END IF;
1767:

Line 1764: fnd_message.Set_Token('TEXT', 'partner org rs id for timeout '||l_partner_org_rs_id);

1760: exit when lc_get_pt_lc_org%notfound;
1761:
1762: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1763: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1764: fnd_message.Set_Token('TEXT', 'partner org rs id for timeout '||l_partner_org_rs_id);
1765: fnd_msg_pub.Add;
1766: END IF;
1767:
1768: pv_assign_util_pvt.updateaccess(

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

1962:
1963: BEGIN
1964:
1965: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1966: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1967: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || ' Funcmode: ' || funcmode);
1968: fnd_msg_pub.Add;
1969: END IF;
1970:

Line 1967: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || ' Funcmode: ' || funcmode);

1963: BEGIN
1964:
1965: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1966: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1967: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || ' Funcmode: ' || funcmode);
1968: fnd_msg_pub.Add;
1969: END IF;
1970:
1971: if (funcmode = 'RUN') then

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

1986: fetch lc_bypass_pt_ok_chk into l_status;
1987: close lc_bypass_pt_ok_chk;
1988:
1989: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1990: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1991: fnd_message.Set_Token('TEXT', 'Bypass PT chk: ' || l_status);
1992: fnd_msg_pub.Add;
1993: END IF;
1994:

Line 1991: fnd_message.Set_Token('TEXT', 'Bypass PT chk: ' || l_status);

1987: close lc_bypass_pt_ok_chk;
1988:
1989: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1990: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1991: fnd_message.Set_Token('TEXT', 'Bypass PT chk: ' || l_status);
1992: fnd_msg_pub.Add;
1993: END IF;
1994:
1995: elsif l_assignment_type = g_wf_lkup_joint then

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

1998: fetch lc_any_bypass_pt_ok_chk into l_status;
1999: close lc_any_bypass_pt_ok_chk;
2000:
2001: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2002: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2003: fnd_message.Set_Token('TEXT', 'Bypass PT chk: ' || nvl(l_status, 'N'));
2004: fnd_msg_pub.Add;
2005: END IF;
2006:

Line 2003: fnd_message.Set_Token('TEXT', 'Bypass PT chk: ' || nvl(l_status, 'N'));

1999: close lc_any_bypass_pt_ok_chk;
2000:
2001: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2002: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2003: fnd_message.Set_Token('TEXT', 'Bypass PT chk: ' || nvl(l_status, 'N'));
2004: fnd_msg_pub.Add;
2005: END IF;
2006:
2007: elsif l_assignment_type = g_wf_lkup_broadcast then

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

2007: elsif l_assignment_type = g_wf_lkup_broadcast then
2008:
2009: -- not supported in broadcast
2010:
2011: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2012: fnd_message.Set_token('TEXT', 'Incorrect WF function usage for assignment type: ' || l_assignment_type);
2013: fnd_msg_pub.Add;
2014: raise FND_API.G_EXC_ERROR;
2015:

Line 2012: fnd_message.Set_token('TEXT', 'Incorrect WF function usage for assignment type: ' || l_assignment_type);

2008:
2009: -- not supported in broadcast
2010:
2011: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2012: fnd_message.Set_token('TEXT', 'Incorrect WF function usage for assignment type: ' || l_assignment_type);
2013: fnd_msg_pub.Add;
2014: raise FND_API.G_EXC_ERROR;
2015:
2016: else

Line 2018: fnd_message.Set_Name('PV', 'PV_INVALID_ASSIGN_TYPE');

2014: raise FND_API.G_EXC_ERROR;
2015:
2016: else
2017:
2018: fnd_message.Set_Name('PV', 'PV_INVALID_ASSIGN_TYPE');
2019: fnd_message.SET_TOKEN('TYPE', l_assignment_type);
2020: fnd_msg_pub.ADD;
2021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2022:

Line 2019: fnd_message.SET_TOKEN('TYPE', l_assignment_type);

2015:
2016: else
2017:
2018: fnd_message.Set_Name('PV', 'PV_INVALID_ASSIGN_TYPE');
2019: fnd_message.SET_TOKEN('TYPE', l_assignment_type);
2020: fnd_msg_pub.ADD;
2021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2022:
2023: end if;

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

2107: pv_assignment_pub.g_la_status_cm_timeout);
2108: BEGIN
2109:
2110: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2111: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2112: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || ' Funcmode: ' || funcmode);
2113: fnd_msg_pub.Add;
2114: END IF;
2115:

Line 2112: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || ' Funcmode: ' || funcmode);

2108: BEGIN
2109:
2110: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2111: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2112: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || ' Funcmode: ' || funcmode);
2113: fnd_msg_pub.Add;
2114: END IF;
2115:
2116: if (funcmode = 'RUN') then

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

2120: aname => g_wf_attr_assignment_type);
2121:
2122: if l_assignment_type in (g_wf_lkup_single, g_wf_lkup_serial, g_wf_lkup_broadcast) then
2123:
2124: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2125: fnd_message.Set_token('TEXT', 'Incorrect WF function usage for assignment type: ' || l_assignment_type);
2126: fnd_msg_pub.Add;
2127: raise FND_API.G_EXC_ERROR;
2128:

Line 2125: fnd_message.Set_token('TEXT', 'Incorrect WF function usage for assignment type: ' || l_assignment_type);

2121:
2122: if l_assignment_type in (g_wf_lkup_single, g_wf_lkup_serial, g_wf_lkup_broadcast) then
2123:
2124: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2125: fnd_message.Set_token('TEXT', 'Incorrect WF function usage for assignment type: ' || l_assignment_type);
2126: fnd_msg_pub.Add;
2127: raise FND_API.G_EXC_ERROR;
2128:
2129: elsif l_assignment_type = g_wf_lkup_joint then

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

2132: fetch lc_any_need_pt_ok_chk into l_status;
2133: close lc_any_need_pt_ok_chk;
2134:
2135: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2136: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2137: fnd_message.Set_Token('TEXT', 'Bypass PT chk: ' || nvl(l_status, 'N'));
2138: fnd_msg_pub.Add;
2139: END IF;
2140:

Line 2137: fnd_message.Set_Token('TEXT', 'Bypass PT chk: ' || nvl(l_status, 'N'));

2133: close lc_any_need_pt_ok_chk;
2134:
2135: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2136: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2137: fnd_message.Set_Token('TEXT', 'Bypass PT chk: ' || nvl(l_status, 'N'));
2138: fnd_msg_pub.Add;
2139: END IF;
2140:
2141: else

Line 2143: fnd_message.Set_Name('PV', 'PV_INVALID_ASSIGN_TYPE');

2139: END IF;
2140:
2141: else
2142:
2143: fnd_message.Set_Name('PV', 'PV_INVALID_ASSIGN_TYPE');
2144: fnd_message.SET_TOKEN('TYPE', l_assignment_type);
2145: fnd_msg_pub.ADD;
2146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2147:

Line 2144: fnd_message.SET_TOKEN('TYPE', l_assignment_type);

2140:
2141: else
2142:
2143: fnd_message.Set_Name('PV', 'PV_INVALID_ASSIGN_TYPE');
2144: fnd_message.SET_TOKEN('TYPE', l_assignment_type);
2145: fnd_msg_pub.ADD;
2146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2147:
2148: end if;

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

2235:
2236: BEGIN
2237:
2238: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2239: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2240: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || ' Funcmode: ' || funcmode);
2241: fnd_msg_pub.Add;
2242: END IF;
2243:

Line 2240: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || ' Funcmode: ' || funcmode);

2236: BEGIN
2237:
2238: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2239: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2240: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || ' Funcmode: ' || funcmode);
2241: fnd_msg_pub.Add;
2242: END IF;
2243:
2244: if (funcmode = 'RUN') then

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

2303: IF l_assignment_type = g_wf_lkup_serial THEN
2304: l_partner_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2305: itemkey => itemkey,
2306: aname => g_wf_attr_partner_id);
2307: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2308: fnd_message.Set_Token('TEXT', 'l_partner_id ' || l_partner_id);
2309: fnd_msg_pub.Add;
2310:
2311: END IF;

Line 2308: fnd_message.Set_Token('TEXT', 'l_partner_id ' || l_partner_id);

2304: l_partner_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2305: itemkey => itemkey,
2306: aname => g_wf_attr_partner_id);
2307: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2308: fnd_message.Set_Token('TEXT', 'l_partner_id ' || l_partner_id);
2309: fnd_msg_pub.Add;
2310:
2311: END IF;
2312:

Line 2321: fnd_message.SET_NAME('PV', 'Invalid routing outcome: ' || l_routing_outcome);

2317: l_routing_stage := pv_assignment_pub.g_r_status_active;
2318:
2319: else
2320:
2321: fnd_message.SET_NAME('PV', 'Invalid routing outcome: ' || l_routing_outcome);
2322: fnd_msg_pub.ADD;
2323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2324:
2325: end if;

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

2324:
2325: end if;
2326: IF l_routing_stage <> pv_assignment_pub.g_r_status_active THEN
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', 'checking and removing preferred partner');
2330: fnd_msg_pub.Add;
2331: END IF;
2332: IF l_lead_id IS NOT NULL THEN

Line 2329: fnd_message.Set_Token('TEXT', 'checking and removing preferred partner');

2325: end if;
2326: IF l_routing_stage <> pv_assignment_pub.g_r_status_active THEN
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', 'checking and removing preferred partner');
2330: fnd_msg_pub.Add;
2331: END IF;
2332: IF l_lead_id IS NOT NULL THEN
2333: PV_ASSIGN_UTIL_PVT.removePreferedPartner

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

2455:
2456: BEGIN
2457:
2458: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2459: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2460: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || ' Funcmode: ' || funcmode);
2461: fnd_msg_pub.Add;
2462: END IF;
2463:

Line 2460: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || ' Funcmode: ' || funcmode);

2456: BEGIN
2457:
2458: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2459: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2460: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || ' Funcmode: ' || funcmode);
2461: fnd_msg_pub.Add;
2462: END IF;
2463:
2464: if (funcmode = 'RUN') then

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

2553:
2554: BEGIN
2555:
2556: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2557: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2558: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || ' Funcmode: ' || funcmode);
2559: fnd_msg_pub.Add;
2560: END IF;
2561:

Line 2558: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || ' Funcmode: ' || funcmode);

2554: BEGIN
2555:
2556: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2557: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2558: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || ' Funcmode: ' || funcmode);
2559: fnd_msg_pub.Add;
2560: END IF;
2561:
2562: if (funcmode = 'RUN') then