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

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

44:
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;

Line 51: fnd_msg_pub.Add;

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
55:

Line 65: fnd_msg_pub.Add;

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;
69:

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

66: raise FND_API.G_EXC_ERROR;
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;

Line 73: fnd_msg_pub.Add;

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
77:

Line 130: fnd_msg_pub.Count_And_Get(

126:
127: EXCEPTION
128: WHEN FND_API.G_EXC_ERROR THEN
129:
130: fnd_msg_pub.Count_And_Get(
131: p_encoded => FND_API.G_TRUE
132: ,p_count => l_msg_count
133: ,p_data => l_msg_data);
134:

Line 140: fnd_msg_pub.Count_And_Get(

136: raise;
137:
138: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
139:
140: fnd_msg_pub.Count_And_Get(
141: p_encoded => FND_API.G_TRUE
142: ,p_count => l_msg_count
143: ,p_data => l_msg_data);
144:

Line 150: fnd_msg_pub.Count_And_Get(

146: raise;
147:
148: WHEN OTHERS THEN
149:
150: fnd_msg_pub.Count_And_Get(
151: p_encoded => FND_API.G_TRUE
152: ,p_count => l_msg_count
153: ,p_data => l_msg_data);
154:

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

175: l_msg_data varchar2(2000);
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;

Line 182: fnd_msg_pub.Add;

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
186:

Line 226: fnd_msg_pub.Count_And_Get(

222:
223: EXCEPTION
224: WHEN FND_API.G_EXC_ERROR THEN
225:
226: fnd_msg_pub.Count_And_Get(
227: p_encoded => FND_API.G_TRUE
228: ,p_count => l_msg_count
229: ,p_data => l_msg_data);
230:

Line 236: fnd_msg_pub.Count_And_Get(

232: raise;
233:
234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
235:
236: fnd_msg_pub.Count_And_Get(
237: p_encoded => FND_API.G_TRUE
238: ,p_count => l_msg_count
239: ,p_data => l_msg_data);
240:

Line 246: fnd_msg_pub.Count_And_Get(

242: raise;
243:
244: WHEN OTHERS THEN
245:
246: fnd_msg_pub.Count_And_Get(
247: p_encoded => FND_API.G_TRUE
248: ,p_count => l_msg_count
249: ,p_data => l_msg_data);
250:

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

286: and a.wf_item_key = pc_itemkey;
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;

Line 293: fnd_msg_pub.Add;

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
297:

Line 397: fnd_msg_pub.Count_And_Get(

393:
394: EXCEPTION
395: WHEN FND_API.G_EXC_ERROR THEN
396:
397: fnd_msg_pub.Count_And_Get(
398: p_encoded => FND_API.G_TRUE
399: ,p_count => l_msg_count
400: ,p_data => l_msg_data);
401:

Line 407: fnd_msg_pub.Count_And_Get(

403: raise;
404:
405: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
406:
407: fnd_msg_pub.Count_And_Get(
408: p_encoded => FND_API.G_TRUE
409: ,p_count => l_msg_count
410: ,p_data => l_msg_data);
411:

Line 417: fnd_msg_pub.Count_And_Get(

413: raise;
414:
415: WHEN OTHERS THEN
416:
417: fnd_msg_pub.Count_And_Get(
418: p_encoded => FND_API.G_TRUE
419: ,p_count => l_msg_count
420: ,p_data => l_msg_data);
421:

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

443: l_msg_data varchar2(2000);
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;

Line 450: fnd_msg_pub.Add;

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
454:

Line 496: fnd_msg_pub.Count_And_Get(

492:
493: EXCEPTION
494: WHEN FND_API.G_EXC_ERROR THEN
495:
496: fnd_msg_pub.Count_And_Get(
497: p_encoded => FND_API.G_TRUE
498: ,p_count => l_msg_count
499: ,p_data => l_msg_data);
500:

Line 506: fnd_msg_pub.Count_And_Get(

502: raise;
503:
504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
505:
506: fnd_msg_pub.Count_And_Get(
507: p_encoded => FND_API.G_TRUE
508: ,p_count => l_msg_count
509: ,p_data => l_msg_data);
510:

Line 516: fnd_msg_pub.Count_And_Get(

512: raise;
513:
514: WHEN OTHERS THEN
515:
516: fnd_msg_pub.Count_And_Get(
517: p_encoded => FND_API.G_TRUE
518: ,p_count => l_msg_count
519: ,p_data => l_msg_data);
520:

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

556: order by assign_sequence;
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;

Line 563: fnd_msg_pub.Add;

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
567:

Line 616: fnd_msg_pub.ADD;

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;
620:

Line 628: fnd_msg_pub.ADD;

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;
632:

Line 660: fnd_msg_pub.ADD;

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;
664:

Line 713: fnd_msg_pub.ADD;

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;
717:

Line 736: fnd_msg_pub.Count_And_Get(

732:
733: EXCEPTION
734: WHEN FND_API.G_EXC_ERROR THEN
735:
736: fnd_msg_pub.Count_And_Get(
737: p_encoded => FND_API.G_TRUE
738: ,p_count => l_msg_count
739: ,p_data => l_msg_data);
740:

Line 746: fnd_msg_pub.Count_And_Get(

742: raise;
743:
744: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
745:
746: fnd_msg_pub.Count_And_Get(
747: p_encoded => FND_API.G_TRUE
748: ,p_count => l_msg_count
749: ,p_data => l_msg_data);
750:

Line 756: fnd_msg_pub.Count_And_Get(

752: raise;
753:
754: WHEN OTHERS THEN
755:
756: fnd_msg_pub.Count_And_Get(
757: p_encoded => FND_API.G_TRUE
758: ,p_count => l_msg_count
759: ,p_data => l_msg_data);
760:

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

808: and la.wf_item_key = a.wf_item_key
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;

Line 815: fnd_msg_pub.Add;

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
819:

Line 915: fnd_msg_pub.Count_And_Get(

911:
912: EXCEPTION
913: WHEN FND_API.G_EXC_ERROR THEN
914:
915: fnd_msg_pub.Count_And_Get(
916: p_encoded => FND_API.G_TRUE
917: ,p_count => l_msg_count
918: ,p_data => l_msg_data);
919:

Line 925: fnd_msg_pub.Count_And_Get(

921: raise;
922:
923: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
924:
925: fnd_msg_pub.Count_And_Get(
926: p_encoded => FND_API.G_TRUE
927: ,p_count => l_msg_count
928: ,p_data => l_msg_data);
929:

Line 935: fnd_msg_pub.Count_And_Get(

931: raise;
932:
933: WHEN OTHERS THEN
934:
935: fnd_msg_pub.Count_And_Get(
936: p_encoded => FND_API.G_TRUE
937: ,p_count => l_msg_count
938: ,p_data => l_msg_data);
939:

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

981: and b.category = 'PARTNER';
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;

Line 988: fnd_msg_pub.Add;

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
992:

Line 1113: fnd_msg_pub.Count_And_Get(

1109:
1110: EXCEPTION
1111: WHEN FND_API.G_EXC_ERROR THEN
1112:
1113: fnd_msg_pub.Count_And_Get(
1114: p_encoded => FND_API.G_TRUE
1115: ,p_count => l_msg_count
1116: ,p_data => l_msg_data);
1117:

Line 1123: fnd_msg_pub.Count_And_Get(

1119: raise;
1120:
1121: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1122:
1123: fnd_msg_pub.Count_And_Get(
1124: p_encoded => FND_API.G_TRUE
1125: ,p_count => l_msg_count
1126: ,p_data => l_msg_data);
1127:

Line 1133: fnd_msg_pub.Count_And_Get(

1129: raise;
1130:
1131: WHEN OTHERS THEN
1132:
1133: fnd_msg_pub.Count_And_Get(
1134: p_encoded => FND_API.G_TRUE
1135: ,p_count => l_msg_count
1136: ,p_data => l_msg_data);
1137:

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

1312: pv_assignment_pub.g_la_status_cm_app_for_pt,
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;

Line 1319: fnd_msg_pub.Add;

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
1323:

Line 1409: fnd_msg_pub.Add;

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:
1413: end if;

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

1547: loop
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;

Line 1554: fnd_msg_pub.Add;

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(
1558: p_api_version_number => 1.0,

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

1758: loop
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;

Line 1765: fnd_msg_pub.Add;

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(
1769: p_api_version_number => 1.0,

Line 1895: fnd_msg_pub.Count_And_Get(

1891:
1892: EXCEPTION
1893: WHEN FND_API.G_EXC_ERROR THEN
1894:
1895: fnd_msg_pub.Count_And_Get(
1896: p_encoded => FND_API.G_TRUE
1897: ,p_count => l_msg_count
1898: ,p_data => l_msg_data);
1899:

Line 1905: fnd_msg_pub.Count_And_Get(

1901: raise;
1902:
1903: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1904:
1905: fnd_msg_pub.Count_And_Get(
1906: p_encoded => FND_API.G_TRUE
1907: ,p_count => l_msg_count
1908: ,p_data => l_msg_data);
1909:

Line 1915: fnd_msg_pub.Count_And_Get(

1911: raise;
1912:
1913: WHEN OTHERS THEN
1914:
1915: fnd_msg_pub.Count_And_Get(
1916: p_encoded => FND_API.G_TRUE
1917: ,p_count => l_msg_count
1918: ,p_data => l_msg_data);
1919:

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

1961:
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;

Line 1968: fnd_msg_pub.Add;

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
1972:

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

1985: open lc_bypass_pt_ok_chk (pc_itemtype => itemtype, pc_itemkey => itemkey, pc_partner_id => l_partner_id);
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;

Line 1992: fnd_msg_pub.Add;

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
1996:

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

1997: open lc_any_bypass_pt_ok_chk (pc_itemtype => itemtype, pc_itemkey => itemkey);
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;

Line 2004: fnd_msg_pub.Add;

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
2008:

Line 2013: fnd_msg_pub.Add;

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
2017:

Line 2020: fnd_msg_pub.ADD;

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;
2024:

Line 2048: fnd_msg_pub.Count_And_Get(

2044:
2045: EXCEPTION
2046: WHEN FND_API.G_EXC_ERROR THEN
2047:
2048: fnd_msg_pub.Count_And_Get(
2049: p_encoded => FND_API.G_TRUE
2050: ,p_count => l_msg_count
2051: ,p_data => l_msg_data);
2052:

Line 2058: fnd_msg_pub.Count_And_Get(

2054: raise;
2055:
2056: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2057:
2058: fnd_msg_pub.Count_And_Get(
2059: p_encoded => FND_API.G_TRUE
2060: ,p_count => l_msg_count
2061: ,p_data => l_msg_data);
2062:

Line 2068: fnd_msg_pub.Count_And_Get(

2064: raise;
2065:
2066: WHEN OTHERS THEN
2067:
2068: fnd_msg_pub.Count_And_Get(
2069: p_encoded => FND_API.G_TRUE
2070: ,p_count => l_msg_count
2071: ,p_data => l_msg_data);
2072:

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

2106: pv_assignment_pub.g_la_status_cm_bypassed,
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;

Line 2113: fnd_msg_pub.Add;

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
2117:

Line 2126: fnd_msg_pub.Add;

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
2130:

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

2131: open lc_any_need_pt_ok_chk (pc_itemtype => itemtype, pc_itemkey => itemkey);
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;

Line 2138: fnd_msg_pub.Add;

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
2142:

Line 2145: fnd_msg_pub.ADD;

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;
2149:

Line 2172: fnd_msg_pub.Count_And_Get(

2168:
2169: EXCEPTION
2170: WHEN FND_API.G_EXC_ERROR THEN
2171:
2172: fnd_msg_pub.Count_And_Get(
2173: p_encoded => FND_API.G_TRUE
2174: ,p_count => l_msg_count
2175: ,p_data => l_msg_data);
2176:

Line 2182: fnd_msg_pub.Count_And_Get(

2178: raise;
2179:
2180: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2181:
2182: fnd_msg_pub.Count_And_Get(
2183: p_encoded => FND_API.G_TRUE
2184: ,p_count => l_msg_count
2185: ,p_data => l_msg_data);
2186:

Line 2192: fnd_msg_pub.Count_And_Get(

2188: raise;
2189:
2190: WHEN OTHERS THEN
2191:
2192: fnd_msg_pub.Count_And_Get(
2193: p_encoded => FND_API.G_TRUE
2194: ,p_count => l_msg_count
2195: ,p_data => l_msg_data);
2196:

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

2234: lc_ref_cursor pv_assignment_pub.g_ref_cursor_type;
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;

Line 2241: fnd_msg_pub.Add;

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
2245:

Line 2309: fnd_msg_pub.Add;

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:
2313: END IF;

Line 2322: fnd_msg_pub.ADD;

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;
2326: IF l_routing_stage <> pv_assignment_pub.g_r_status_active THEN

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

2323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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;

Line 2330: fnd_msg_pub.Add;

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
2334: (

Line 2407: fnd_msg_pub.Count_And_Get(

2403:
2404: EXCEPTION
2405: WHEN FND_API.G_EXC_ERROR THEN
2406:
2407: fnd_msg_pub.Count_And_Get(
2408: p_encoded => FND_API.G_TRUE
2409: ,p_count => l_msg_count
2410: ,p_data => l_msg_data);
2411:

Line 2417: fnd_msg_pub.Count_And_Get(

2413: raise;
2414:
2415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2416:
2417: fnd_msg_pub.Count_And_Get(
2418: p_encoded => FND_API.G_TRUE
2419: ,p_count => l_msg_count
2420: ,p_data => l_msg_data);
2421:

Line 2427: fnd_msg_pub.Count_And_Get(

2423: raise;
2424:
2425: WHEN OTHERS THEN
2426:
2427: fnd_msg_pub.Count_And_Get(
2428: p_encoded => FND_API.G_TRUE
2429: ,p_count => l_msg_count
2430: ,p_data => l_msg_data);
2431:

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

2454:
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;

Line 2461: fnd_msg_pub.Add;

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
2465:

Line 2505: fnd_msg_pub.Count_And_Get(

2501:
2502: EXCEPTION
2503: WHEN FND_API.G_EXC_ERROR THEN
2504:
2505: fnd_msg_pub.Count_And_Get(
2506: p_encoded => FND_API.G_TRUE
2507: ,p_count => l_msg_count
2508: ,p_data => l_msg_data);
2509:

Line 2515: fnd_msg_pub.Count_And_Get(

2511: raise;
2512:
2513: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2514:
2515: fnd_msg_pub.Count_And_Get(
2516: p_encoded => FND_API.G_TRUE
2517: ,p_count => l_msg_count
2518: ,p_data => l_msg_data);
2519:

Line 2525: fnd_msg_pub.Count_And_Get(

2521: raise;
2522:
2523: WHEN OTHERS THEN
2524:
2525: fnd_msg_pub.Count_And_Get(
2526: p_encoded => FND_API.G_TRUE
2527: ,p_count => l_msg_count
2528: ,p_data => l_msg_data);
2529:

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

2552:
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;

Line 2559: fnd_msg_pub.Add;

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
2563:

Line 2599: fnd_msg_pub.Count_And_Get(

2595:
2596: EXCEPTION
2597: WHEN FND_API.G_EXC_ERROR THEN
2598:
2599: fnd_msg_pub.Count_And_Get(
2600: p_encoded => FND_API.G_TRUE
2601: ,p_count => l_msg_count
2602: ,p_data => l_msg_data);
2603:

Line 2609: fnd_msg_pub.Count_And_Get(

2605: raise;
2606:
2607: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2608:
2609: fnd_msg_pub.Count_And_Get(
2610: p_encoded => FND_API.G_TRUE
2611: ,p_count => l_msg_count
2612: ,p_data => l_msg_data);
2613:

Line 2619: fnd_msg_pub.Count_And_Get(

2615: raise;
2616:
2617: WHEN OTHERS THEN
2618:
2619: fnd_msg_pub.Count_And_Get(
2620: p_encoded => FND_API.G_TRUE
2621: ,p_count => l_msg_count
2622: ,p_data => l_msg_data);
2623: