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.BIS_PORTLET_PMREGION dependencies on FND_API

Line 329: l_return_sts VARCHAR2(100) := FND_API.G_RET_STS_SUCCESS;

325: l_rel_dim_lev_g_var varchar2(32000);
326: l_Z varchar2(32000);
327:
328: l_var number;
329: l_return_sts VARCHAR2(100) := FND_API.G_RET_STS_SUCCESS;
330: l_sob_id NUMBER;
331: l_plug_id pls_integer;
332:
333: begin

Line 368: if (p_coldata(l_pos1).link = FND_API.G_TRUE) then

364:
365: -- Set certain numbers and names
366: l_totalpossible := NVL(p_totalcount,l_totalcount);
367: for l_pos1 in p_coldata.FIRST .. p_coldata.COUNT loop
368: if (p_coldata(l_pos1).link = FND_API.G_TRUE) then
369: l_titlename := p_coldata(l_pos1).header;
370: exit;
371: end if;
372: end loop;

Line 912: l_col_object(1).value := FND_API.G_TRUE;

908:
909: -- (4)Build the plsql table to transfer column information
910: --
911: l_col_object(1).header := BIS_INTERMEDIATE_LOV_PVT.c_orgid;
912: l_col_object(1).value := FND_API.G_TRUE;
913: l_col_object(1).link := FND_API.G_FALSE;
914: l_col_object(1).display:= FND_API.G_FALSE;
915:
916: -- l_col_object(2).header := l_header;

Line 913: l_col_object(1).link := FND_API.G_FALSE;

909: -- (4)Build the plsql table to transfer column information
910: --
911: l_col_object(1).header := BIS_INTERMEDIATE_LOV_PVT.c_orgid;
912: l_col_object(1).value := FND_API.G_TRUE;
913: l_col_object(1).link := FND_API.G_FALSE;
914: l_col_object(1).display:= FND_API.G_FALSE;
915:
916: -- l_col_object(2).header := l_header;
917: --Bug 1797465

Line 914: l_col_object(1).display:= FND_API.G_FALSE;

910: --
911: l_col_object(1).header := BIS_INTERMEDIATE_LOV_PVT.c_orgid;
912: l_col_object(1).value := FND_API.G_TRUE;
913: l_col_object(1).link := FND_API.G_FALSE;
914: l_col_object(1).display:= FND_API.G_FALSE;
915:
916: -- l_col_object(2).header := l_header;
917: --Bug 1797465
918: -- l_col_object(2).header := c_organization;

Line 921: l_col_object(2).value := FND_API.G_FALSE;

917: --Bug 1797465
918: -- l_col_object(2).header := c_organization;
919: l_col_object(2).header := p_dim1_lbl;
920: --Bug 1797465
921: l_col_object(2).value := FND_API.G_FALSE;
922: l_col_object(2).link := FND_API.G_TRUE;
923: l_col_object(2).display:= FND_API.G_TRUE;
924:
925: --

Line 922: l_col_object(2).link := FND_API.G_TRUE;

918: -- l_col_object(2).header := c_organization;
919: l_col_object(2).header := p_dim1_lbl;
920: --Bug 1797465
921: l_col_object(2).value := FND_API.G_FALSE;
922: l_col_object(2).link := FND_API.G_TRUE;
923: l_col_object(2).display:= FND_API.G_TRUE;
924:
925: --
926: -- (5)Now call LOV utility procedure to run the query and paint the window

Line 923: l_col_object(2).display:= FND_API.G_TRUE;

919: l_col_object(2).header := p_dim1_lbl;
920: --Bug 1797465
921: l_col_object(2).value := FND_API.G_FALSE;
922: l_col_object(2).link := FND_API.G_TRUE;
923: l_col_object(2).display:= FND_API.G_TRUE;
924:
925: --
926: -- (5)Now call LOV utility procedure to run the query and paint the window
927: --

Line 1449: if (p_disp(l_col) = FND_API.G_TRUE) then

1445: htp.p('');
1446: htp.p('');
1447: htp.tablerowOpen(cattributes=>'BGCOLOR='||bis_lov_pub.c_fmbgcolor);
1448: for l_col in p_disp.FIRST..p_disp.COUNT loop
1449: if (p_disp(l_col) = FND_API.G_TRUE) then
1450: htp.tableheader(''||bis_utilities_pvt.escape_html(p_head(l_col))
1451: ||'');
1452: end if;
1453: end loop;
Line 1492: if (p_link(l_pos1) = FND_API.G_TRUE) then

1488: if (l_count >= l_startnum AND l_count < l_startnum + p_rowcount) then
1489: htp.tablerowOpen(cattributes=>'BGCOLOR='||bis_lov_pub.c_rowcolor);
1490: -- Start painting the column values
1491: for l_pos1 in p_head.FIRST .. p_head.COUNT loop
1492: if (p_link(l_pos1) = FND_API.G_TRUE) then
1493: l_linktext := l_colstore(l_pos1);
1494: for l_pos2 in p_head.FIRST..p_head.COUNT loop
1495: if (p_value(l_pos2) = FND_API.G_TRUE) then
1496: l_linkvalue := l_colstore(l_pos2);

Line 1495: if (p_value(l_pos2) = FND_API.G_TRUE) then

1491: for l_pos1 in p_head.FIRST .. p_head.COUNT loop
1492: if (p_link(l_pos1) = FND_API.G_TRUE) then
1493: l_linktext := l_colstore(l_pos1);
1494: for l_pos2 in p_head.FIRST..p_head.COUNT loop
1495: if (p_value(l_pos2) = FND_API.G_TRUE) then
1496: l_linkvalue := l_colstore(l_pos2);
1497: exit;
1498: end if;
1499: end loop;

Line 1505: elsif (p_disp(l_pos1) = FND_API.G_TRUE) AND

1501: ICX_UTIL.replace_onMouseOver_quotes(l_linktext)||''','''||l_linkvalue||''')',
1502: ctext=>l_linktext),
1503: cnowrap=>'YES',
1504: cattributes=>'HEIGHT=10');
1505: elsif (p_disp(l_pos1) = FND_API.G_TRUE) AND
1506: (p_link(l_pos1) = FND_API.G_FALSE) then
1507: htp.tableData(bis_utilities_pvt.escape_html(l_colstore(l_pos1)),cnowrap=>'YES');
1508: end if; -- to check type of column
1509: end loop; -- p_coldata loop to determine the context of each col

Line 1506: (p_link(l_pos1) = FND_API.G_FALSE) then

1502: ctext=>l_linktext),
1503: cnowrap=>'YES',
1504: cattributes=>'HEIGHT=10');
1505: elsif (p_disp(l_pos1) = FND_API.G_TRUE) AND
1506: (p_link(l_pos1) = FND_API.G_FALSE) then
1507: htp.tableData(bis_utilities_pvt.escape_html(l_colstore(l_pos1)),cnowrap=>'YES');
1508: end if; -- to check type of column
1509: end loop; -- p_coldata loop to determine the context of each col
1510:

Line 1646: , p_all_info => FND_API.G_FALSE

1642: -- Get all the Indicator Levels for this user
1643: -- ********************************************
1644: BIS_TARGET_LEVEL_PUB.Retrieve_User_Target_Levels
1645: ( p_api_version => 1.0
1646: , p_all_info => FND_API.G_FALSE
1647: , p_user_id => l_current_user_id
1648: , x_Target_Level_Tbl => l_indicators_tbl
1649: , x_return_status => l_return_status
1650: , x_Error_Tbl => l_error_tbl

Line 1659: , p_all_info => FND_API.G_TRUE

1655: -- bis_user_ind_selections table.
1656: BIS_INDICATOR_REGION_PUB.Retrieve_User_Ind_Selections
1657: ( p_api_version => 1.0
1658: , p_user_id => l_user_id
1659: , p_all_info => FND_API.G_TRUE
1660: , p_plug_id => l_plug_id
1661: , x_Indicator_Region_Tbl => l_selections_tbl
1662: , x_return_status => l_return_status
1663: , x_Error_Tbl => l_error_tbl

Line 1964: l_button_tbl(1).disabled := FND_API.G_FALSE;

1960: --icx_plug_utilities.buttonBoth(BIS_UTILITIES_PVT.getPrompt('BIS_DELETE')
1961: -- ,'Javascript:deleteTo()');
1962: l_button_tbl(1).left_edge := BIS_UTILITIES_PVT.G_ROUND_EDGE;
1963: l_button_tbl(1).right_edge := BIS_UTILITIES_PVT.G_ROUND_EDGE;
1964: l_button_tbl(1).disabled := FND_API.G_FALSE;
1965: l_button_tbl(1).label := BIS_UTILITIES_PVT.getPrompt('BIS_DELETE');
1966: l_button_tbl(1).href := 'Javascript:deleteTo()';
1967: BIS_UTILITIES_PVT.GetButtonString(l_button_tbl, l_button_str);
1968: htp.p(l_button_str);

Line 1983: l_button_tbl(1).disabled := FND_API.G_FALSE;

1979: --icx_plug_utilities.buttonLeft(BIS_UTILITIES_PVT.getPrompt('BIS_CONTINUE')
1980: -- ,'Javascript:savefavorites()');
1981: l_button_tbl(1).left_edge := BIS_UTILITIES_PVT.G_ROUND_EDGE;
1982: l_button_tbl(1).right_edge := BIS_UTILITIES_PVT.G_FLAT_EDGE;
1983: l_button_tbl(1).disabled := FND_API.G_FALSE;
1984: l_button_tbl(1).label := BIS_UTILITIES_PVT.getPrompt('BIS_CONTINUE');
1985: l_button_tbl(1).href := 'Javascript:savefavorites()';
1986: BIS_UTILITIES_PVT.GetButtonString(l_button_tbl, l_button_str);
1987: htp.p(l_button_str);

Line 1995: l_button_tbl(1).disabled := FND_API.G_FALSE;

1991: --icx_plug_utilities.buttonRight(BIS_UTILITIES_PVT.getPrompt('BIS_CANCEL')
1992: -- ,'JavaScript:history.go(-1)');
1993: l_button_tbl(1).left_edge := BIS_UTILITIES_PVT.G_FLAT_EDGE;
1994: l_button_tbl(1).right_edge := BIS_UTILITIES_PVT.G_ROUND_EDGE;
1995: l_button_tbl(1).disabled := FND_API.G_FALSE;
1996: l_button_tbl(1).label := BIS_UTILITIES_PVT.getPrompt('BIS_CANCEL');
1997: --l_button_tbl(1).href := 'JavaScript:history.go(-1)';
1998: l_button_tbl(1).href := p_back_url;
1999: BIS_UTILITIES_PVT.GetButtonString(l_button_tbl, l_button_str);

Line 2256: , p_all_info => FND_API.G_TRUE

2252:
2253: BIS_INDICATOR_REGION_PUB.Retrieve_User_Ind_Selections
2254: ( p_api_version => 1.0
2255: , p_user_id => l_user_id
2256: , p_all_info => FND_API.G_TRUE
2257: , p_plug_id => l_plug_id
2258: , x_Indicator_Region_Tbl => l_labels_tbl
2259: , x_return_status => l_return_status
2260: , x_Error_Tbl => l_error_tbl

Line 3559: l_button_tbl(1).disabled := FND_API.G_FALSE;

3555: --meastmon ICX Button is not ADA Complaint. ICX is not going to fix that.
3556: --icx_plug_utilities.buttonBoth(c_display_homepage,'Javascript:addTo()');
3557: l_button_tbl(1).left_edge := BIS_UTILITIES_PVT.G_ROUND_EDGE;
3558: l_button_tbl(1).right_edge := BIS_UTILITIES_PVT.G_ROUND_EDGE;
3559: l_button_tbl(1).disabled := FND_API.G_FALSE;
3560: l_button_tbl(1).label := c_display_homepage;
3561: l_button_tbl(1).href := 'Javascript:addTo()';
3562: BIS_UTILITIES_PVT.GetButtonString(l_button_tbl, l_button_str);
3563: htp.p(l_button_str);

Line 3751: l_button_tbl(1).disabled := FND_API.G_FALSE;

3747: -- BIS_UTILITIES_PVT.getPrompt('BIS_EDIT')
3748: -- ,'Javascript:editTo()');
3749: l_button_tbl(1).left_edge := BIS_UTILITIES_PVT.G_ROUND_EDGE;
3750: l_button_tbl(1).right_edge := BIS_UTILITIES_PVT.G_ROUND_EDGE;
3751: l_button_tbl(1).disabled := FND_API.G_FALSE;
3752: l_button_tbl(1).label := BIS_UTILITIES_PVT.getPrompt('BIS_EDIT');
3753: l_button_tbl(1).href := 'Javascript:editTo()';
3754: BIS_UTILITIES_PVT.GetButtonString(l_button_tbl, l_button_str);
3755: htp.p(l_button_str);

Line 3766: l_button_tbl(1).disabled := FND_API.G_FALSE;

3762: -- BIS_UTILITIES_PVT.getPrompt('BIS_DELETE')
3763: -- ,'Javascript:deleteTo()');
3764: l_button_tbl(1).left_edge := BIS_UTILITIES_PVT.G_ROUND_EDGE;
3765: l_button_tbl(1).right_edge := BIS_UTILITIES_PVT.G_ROUND_EDGE;
3766: l_button_tbl(1).disabled := FND_API.G_FALSE;
3767: l_button_tbl(1).label := BIS_UTILITIES_PVT.getPrompt('BIS_DELETE');
3768: l_button_tbl(1).href := 'Javascript:deleteTo()';
3769: BIS_UTILITIES_PVT.GetButtonString(l_button_tbl, l_button_str);
3770: htp.p(l_button_str);

Line 3817: l_button_tbl(1).disabled := FND_API.G_FALSE;

3813: --icx_plug_utilities.buttonLeft(BIS_UTILITIES_PVT.getPrompt('BIS_OK'),
3814: -- 'Javascript:savedimensions()');
3815: l_button_tbl(1).left_edge := BIS_UTILITIES_PVT.G_ROUND_EDGE;
3816: l_button_tbl(1).right_edge := BIS_UTILITIES_PVT.G_FLAT_EDGE;
3817: l_button_tbl(1).disabled := FND_API.G_FALSE;
3818: l_button_tbl(1).label := BIS_UTILITIES_PVT.getPrompt('BIS_OK');
3819: l_button_tbl(1).href := 'Javascript:savedimensions()';
3820: BIS_UTILITIES_PVT.GetButtonString(l_button_tbl, l_button_str);
3821: htp.p(l_button_str);

Line 3852: l_button_tbl(1).disabled := FND_API.G_FALSE;

3848: --icx_plug_utilities.buttonRight(BIS_UTILITIES_PVT.getPrompt('BIS_CANCEL'),
3849: -- 'Javascript:document.actionback.submit()');
3850: l_button_tbl(1).left_edge := BIS_UTILITIES_PVT.G_FLAT_EDGE;
3851: l_button_tbl(1).right_edge := BIS_UTILITIES_PVT.G_ROUND_EDGE;
3852: l_button_tbl(1).disabled := FND_API.G_FALSE;
3853: l_button_tbl(1).label := BIS_UTILITIES_PVT.getPrompt('BIS_CANCEL');
3854: l_button_tbl(1).href := 'Javascript:document.actionback.submit()';
3855: BIS_UTILITIES_PVT.GetButtonString(l_button_tbl, l_button_str);
3856: htp.p(l_button_str);

Line 4294: , p_all_info => FND_API.G_TRUE

4290: -- selections table.
4291: BIS_INDICATOR_REGION_PUB.Retrieve_User_Ind_Selections
4292: ( p_api_version => 1.0
4293: , p_user_id => l_user_id
4294: , p_all_info => FND_API.G_TRUE
4295: , p_plug_id => l_plug_id
4296: , x_Indicator_Region_Tbl => l_favorites_tbl
4297: , x_return_status => l_return_status
4298: , x_Error_Tbl => l_error_tbl

Line 5590: l_button_tbl(1).disabled := FND_API.G_FALSE;

5586: --icx_plug_utilities.buttonLeft
5587: -- (BIS_UTILITIES_PVT.getPrompt('BIS_OK'),'javascript:saveRename()');
5588: l_button_tbl(1).left_edge := BIS_UTILITIES_PVT.G_ROUND_EDGE;
5589: l_button_tbl(1).right_edge := BIS_UTILITIES_PVT.G_FLAT_EDGE;
5590: l_button_tbl(1).disabled := FND_API.G_FALSE;
5591: l_button_tbl(1).label := BIS_UTILITIES_PVT.getPrompt('BIS_OK');
5592: l_button_tbl(1).href := 'javascript:saveRename()';
5593: BIS_UTILITIES_PVT.GetButtonString(l_button_tbl, l_button_str);
5594: htp.p(l_button_str);

Line 5603: l_button_tbl(1).disabled := FND_API.G_FALSE;

5599: --icx_plug_utilities.buttonRight
5600: -- (BIS_UTILITIES_PVT.getPrompt('BIS_CANCEL'),'javascript:window.close()');
5601: l_button_tbl(1).left_edge := BIS_UTILITIES_PVT.G_FLAT_EDGE;
5602: l_button_tbl(1).right_edge := BIS_UTILITIES_PVT.G_ROUND_EDGE;
5603: l_button_tbl(1).disabled := FND_API.G_FALSE;
5604: l_button_tbl(1).label := BIS_UTILITIES_PVT.getPrompt('BIS_CANCEL');
5605: l_button_tbl(1).href := 'javascript:window.close()';
5606: BIS_UTILITIES_PVT.GetButtonString(l_button_tbl, l_button_str);
5607: htp.p(l_button_str);

Line 5808: x_return_status := FND_API.G_RET_STS_SUCCESS;

5804: IS
5805: l_level_short_name VARCHAR2(80);
5806: l_target_level_rec BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
5807: BEGIN
5808: x_return_status := FND_API.G_RET_STS_SUCCESS;
5809:
5810: l_level_short_name := BIS_PMF_PORTLET_UTIL.get_pl_value(c_key_target_level,p_parameters);
5811: IF (l_level_short_name IS NULL) THEN --bug#2210756
5812: RETURN NULL;

Line 5823: , p_all_info => FND_API.G_FALSE

5819: ---------------------------
5820: BIS_TARGET_LEVEL_PUB.Retrieve_Target_Level
5821: ( p_api_version => 1.0
5822: , p_Target_level_rec => l_Target_level_rec
5823: , p_all_info => FND_API.G_FALSE
5824: , x_Target_level_rec => l_Target_level_rec
5825: , x_return_status => x_return_status
5826: , x_error_Tbl => x_error_tbl
5827: );

Line 5830: IF (BIS_UTILITIES_PUB.Value_Missing(l_Target_level_rec.TARGET_LEVEL_ID) = FND_API.G_TRUE) THEN

5826: , x_error_Tbl => x_error_tbl
5827: );
5828: -- bug#2210756
5829:
5830: IF (BIS_UTILITIES_PUB.Value_Missing(l_Target_level_rec.TARGET_LEVEL_ID) = FND_API.G_TRUE) THEN
5831:
5832: RETURN NULL;
5833: END IF;
5834:

Line 5872: x_return_status := FND_API.G_RET_STS_SUCCESS;

5868: FROM BISBV_BUSINESS_PLANS
5869: ORDER BY name;
5870:
5871: BEGIN
5872: x_return_status := FND_API.G_RET_STS_SUCCESS;
5873:
5874: OPEN cPlan;
5875: FETCH cPlan INTO l_plan_id;
5876: IF cPlan%NOTFOUND THEN

Line 5885: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

5881:
5882:
5883: EXCEPTION
5884: WHEN OTHERS THEN
5885: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5886: --added last two parameters
5887: BIS_UTILITIES_PVT.Add_Error_Message
5888: ( p_error_msg_id => SQLCODE
5889: , p_error_description => SQLERRM

Line 5929: x_return_status := FND_API.G_RET_STS_SUCCESS;

5925:
5926:
5927:
5928: BEGIN
5929: x_return_status := FND_API.G_RET_STS_SUCCESS;
5930:
5931: l_plan_short_name := BIS_PMF_PORTLET_UTIL.get_pl_value(c_key_plan,p_parameters);
5932:
5933: -- plan short name is not specified

Line 5951: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5947: , x_return_status => x_return_status
5948: , x_error_tbl => x_error_tbl
5949: );
5950: /*
5951: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5952: RETURN p_default_plan_id;
5953: END IF;
5954: */
5955: RETURN l_business_plan_rec.Business_Plan_id;

Line 5960: WHEN FND_API.G_EXC_ERROR then

5956:
5957:
5958: EXCEPTION
5959: /*
5960: WHEN FND_API.G_EXC_ERROR then
5961: x_return_status := FND_API.G_RET_STS_ERROR ;
5962: */
5963: WHEN OTHERS THEN
5964: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 5961: x_return_status := FND_API.G_RET_STS_ERROR ;

5957:
5958: EXCEPTION
5959: /*
5960: WHEN FND_API.G_EXC_ERROR then
5961: x_return_status := FND_API.G_RET_STS_ERROR ;
5962: */
5963: WHEN OTHERS THEN
5964: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5965: --added last two parameters

Line 5964: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

5960: WHEN FND_API.G_EXC_ERROR then
5961: x_return_status := FND_API.G_RET_STS_ERROR ;
5962: */
5963: WHEN OTHERS THEN
5964: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5965: --added last two parameters
5966: BIS_UTILITIES_PVT.Add_Error_Message
5967: ( p_error_msg_id => SQLCODE
5968: , p_error_description => SQLERRM

Line 6063: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6059:
6060:
6061: EXCEPTION
6062: WHEN OTHERS THEN
6063: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6064:
6065: --dbms_output.put_line('l_return_status='|| x_return_status);
6066: FOR i in 1 .. x_error_tbl.COUNT LOOP
6067: NULL;

Line 6160: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6156: CLOSE cMs;
6157:
6158: EXCEPTION
6159: WHEN OTHERS THEN
6160: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6161: --dbms_output.put_line('l_return_status='|| x_return_status);
6162: FOR i in 1 .. x_error_tbl.COUNT LOOP
6163: NULL;
6164: --dbms_output.put_line('err='||x_error_tbl(i).Error_Description);

Line 7011: x_return_status := FND_API.G_RET_STS_SUCCESS;

7007: ,p_user_id
7008: ,p_user_id
7009: );
7010:
7011: x_return_status := FND_API.G_RET_STS_SUCCESS;
7012: EXCEPTION
7013: WHEN OTHERS THEN
7014: x_return_status := FND_API.G_RET_STS_ERROR;
7015: /*

Line 7014: x_return_status := FND_API.G_RET_STS_ERROR;

7010:
7011: x_return_status := FND_API.G_RET_STS_SUCCESS;
7012: EXCEPTION
7013: WHEN OTHERS THEN
7014: x_return_status := FND_API.G_RET_STS_ERROR;
7015: /*
7016: BIS_UTILITIES_PVT.Add_Error_Message
7017: ( p_error_table => x_error_Tbl
7018: , p_error_msg_id => SQLCODE

Line 7122: ,p_all_info => FND_API.G_FALSE

7118: l_act_in.Dim7_Level_Value_ID := p_target_rec.dim7_level_value_id;
7119:
7120: bis_actual_pub.Retrieve_Actual
7121: ( p_api_version => 1.0
7122: ,p_all_info => FND_API.G_FALSE
7123: ,p_Actual_Rec => l_act_in
7124: ,x_Actual_Rec => l_act_out
7125: ,x_return_Status => l_return_status
7126: ,x_msg_count => l_msg_count