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

Line 37: x_return_status := FND_API.G_TRUE;

33: l_resp_id := FND_GLOBAL.RESP_ID;
34: l_app_id := FND_GLOBAL.RESP_APPL_ID;
35: l_return_value := FND_PROFILE.VALUE_SPECIFIC ('IBU_INTERNAL_ROLLOUT', l_user_id, l_resp_id, l_app_id);
36: if l_return_value = 'Y' then
37: x_return_status := FND_API.G_TRUE;
38: else
39: x_return_status := FND_API.G_FALSE;
40: end if;
41: return x_return_status;

Line 39: x_return_status := FND_API.G_FALSE;

35: l_return_value := FND_PROFILE.VALUE_SPECIFIC ('IBU_INTERNAL_ROLLOUT', l_user_id, l_resp_id, l_app_id);
36: if l_return_value = 'Y' then
37: x_return_status := FND_API.G_TRUE;
38: else
39: x_return_status := FND_API.G_FALSE;
40: end if;
41: return x_return_status;
42: end;
43:

Line 51: x_return_status VARCHAR2(1) := FND_API.G_FALSE;

47: l_info_cursor Info_Cursor;
48: l_count NUMBER;
49: l_cust_id NUMBER;
50: stmt VARCHAR(200);
51: x_return_status VARCHAR2(1) := FND_API.G_FALSE;
52: begin
53: l_cust_id := get_customer_id();
54: if (l_cust_id > 0) then
55: stmt := 'select count(*) ';

Line 66: x_return_status := FND_API.G_TRUE;

62: END LOOP;
63: CLOSE l_info_cursor;
64:
65: if l_count > 0 then
66: x_return_status := FND_API.G_TRUE;
67: else
68: x_return_status := FND_API.G_FALSE;
69: end if;
70: end if;

Line 68: x_return_status := FND_API.G_FALSE;

64:
65: if l_count > 0 then
66: x_return_status := FND_API.G_TRUE;
67: else
68: x_return_status := FND_API.G_FALSE;
69: end if;
70: end if;
71: return x_return_status;
72: end;

Line 201: raise FND_API.G_EXC_ERROR;

197: exception
198: when NO_DATA_FOUND then
199: return null;
200: when others then
201: raise FND_API.G_EXC_ERROR;
202: end get_party_type_from_user;
203:
204: function get_company_id_from_user(p_user_id IN NUMBER) return NUMBER
205: as

Line 239: raise FND_API.G_EXC_ERROR;

235: exception
236: when NO_DATA_FOUND then
237: return null;
238: when others then
239: raise FND_API.G_EXC_ERROR;
240: end get_company_id_from_user;
241:
242: function get_company_name_from_user(p_user_id IN NUMBER) return VARCHAR2
243: as

Line 287: if NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) OR l_attrib_val is null THEN

283: x_pd_attrib_value => l_attrib_val,
284: x_pd_attrib_tbl => l_pd_attrib_tbl
285: );
286:
287: if NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) OR l_attrib_val is null THEN
288: -- default accout does not exist
289: l_acct_list := get_accounts_from_user(p_user_id);
290: if l_acct_list is not null and l_acct_list.count() >0 then
291: l_acct_id := l_acct_list(1).account_id;

Line 520: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

516: end get_bin_header_html;
517:
518: procedure get_bin_info(
519: p_api_version_number IN NUMBER,
520: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
521: p_commit IN VARCHAR := FND_API.G_FALSE,
522: x_return_status OUT NOCOPY VARCHAR2,
523: x_msg_count OUT NOCOPY NUMBER,
524: x_msg_data OUT NOCOPY VARCHAR2,

Line 521: p_commit IN VARCHAR := FND_API.G_FALSE,

517:
518: procedure get_bin_info(
519: p_api_version_number IN NUMBER,
520: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
521: p_commit IN VARCHAR := FND_API.G_FALSE,
522: x_return_status OUT NOCOPY VARCHAR2,
523: x_msg_count OUT NOCOPY NUMBER,
524: x_msg_data OUT NOCOPY VARCHAR2,
525: p_bin_id IN NUMBER,

Line 533: x_return_status := FND_API.G_RET_STS_SUCCESS;

529: l_attrib_val VARCHAR2(300);
530: l_pd_attrib_tbl JTF_PERZ_DATA_PUB.DATA_ATTRIB_TBL_TYPE;
531: l_bin_info Bin_Data_Type;
532: begin
533: x_return_status := FND_API.G_RET_STS_SUCCESS;
534:
535: l_bin_info.bin_id := p_bin_id;
536:
537: get_perz_data_attrib(p_api_version_number => 1.0,

Line 545: p_one_attrib => FND_API.G_FALSE,

541: p_prof_name => G_ADMIN_PROFILE_NAME,
542: p_pd_id => p_bin_id,
543: p_pd_name => null,
544: p_pd_type => null,
545: p_one_attrib => FND_API.G_FALSE,
546: x_pd_attrib_value => l_attrib_val,
547: x_pd_attrib_tbl => l_pd_attrib_tbl
548: );
549:

Line 550: if NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

546: x_pd_attrib_value => l_attrib_val,
547: x_pd_attrib_tbl => l_pd_attrib_tbl
548: );
549:
550: if NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
551: -- the bin does not exist (maybe deleted)
552: l_bin_info.bin_id := null;
553: return;
554: end if;

Line 567: l_bin_info.mandatory_flag := FND_API.G_TRUE;

563: IF l_attrib_name = G_BIN_PACKAGE_ATTR_NAME THEN
564: l_bin_info.package_name := l_attrib_val;
565: ELSIF l_attrib_name = G_BIN_MANDATORY_ATTR_NAME THEN
566: if l_attrib_val = 'Y' then
567: l_bin_info.mandatory_flag := FND_API.G_TRUE;
568: else
569: l_bin_info.mandatory_flag := FND_API.G_FALSE;
570: end if;
571: ELSIF l_attrib_name = G_BIN_DISABLED_ATTR_NAME THEN

Line 569: l_bin_info.mandatory_flag := FND_API.G_FALSE;

565: ELSIF l_attrib_name = G_BIN_MANDATORY_ATTR_NAME THEN
566: if l_attrib_val = 'Y' then
567: l_bin_info.mandatory_flag := FND_API.G_TRUE;
568: else
569: l_bin_info.mandatory_flag := FND_API.G_FALSE;
570: end if;
571: ELSIF l_attrib_name = G_BIN_DISABLED_ATTR_NAME THEN
572: if l_attrib_val = 'Y' then
573: l_bin_info.disabled_flag := FND_API.G_TRUE;

Line 573: l_bin_info.disabled_flag := FND_API.G_TRUE;

569: l_bin_info.mandatory_flag := FND_API.G_FALSE;
570: end if;
571: ELSIF l_attrib_name = G_BIN_DISABLED_ATTR_NAME THEN
572: if l_attrib_val = 'Y' then
573: l_bin_info.disabled_flag := FND_API.G_TRUE;
574: else
575: l_bin_info.disabled_flag := FND_API.G_FALSE;
576: end if;
577: ELSIF l_attrib_name = G_BIN_MES_ID_ATTR_NAME THEN

Line 575: l_bin_info.disabled_flag := FND_API.G_FALSE;

571: ELSIF l_attrib_name = G_BIN_DISABLED_ATTR_NAME THEN
572: if l_attrib_val = 'Y' then
573: l_bin_info.disabled_flag := FND_API.G_TRUE;
574: else
575: l_bin_info.disabled_flag := FND_API.G_FALSE;
576: end if;
577: ELSIF l_attrib_name = G_BIN_MES_ID_ATTR_NAME THEN
578: l_bin_info.MES_cat_ID := to_number(l_attrib_val);
579: ELSIF l_attrib_name = G_BIN_ROW_NUMBER_ATTR_NAME THEN

Line 589: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

585: x_bin_info := l_bin_info;
586:
587: exception
588: when others then
589: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
590: FND_MSG_PUB.Count_And_Get
591: (p_count => x_msg_count ,
592: p_data => x_msg_data
593: );

Line 697: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

693: p_prompts := l_prompts;
694: end;
695:
696: procedure get_filter_list(p_api_version IN NUMBER,
697: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
698: p_commit IN VARCHAR := FND_API.G_FALSE,
699: p_user_id IN NUMBER,
700: p_bin_id In NUMBER,
701: x_return_status OUT NOCOPY VARCHAR2,

Line 698: p_commit IN VARCHAR := FND_API.G_FALSE,

694: end;
695:
696: procedure get_filter_list(p_api_version IN NUMBER,
697: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
698: p_commit IN VARCHAR := FND_API.G_FALSE,
699: p_user_id IN NUMBER,
700: p_bin_id In NUMBER,
701: x_return_status OUT NOCOPY VARCHAR2,
702: x_msg_count OUT NOCOPY NUMBER,

Line 719: IF FND_API.to_Boolean( p_init_msg_list ) THEN

715: ind NUMBER := 0;
716: begin
717:
718: -- Initialize message list if p_init_msg_list is set to TRUE.
719: IF FND_API.to_Boolean( p_init_msg_list ) THEN
720: FND_MSG_PUB.initialize;
721: END IF;
722: -- Initialize API return status to success
723: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 723: x_return_status := FND_API.G_RET_STS_SUCCESS;

719: IF FND_API.to_Boolean( p_init_msg_list ) THEN
720: FND_MSG_PUB.initialize;
721: END IF;
722: -- Initialize API return status to success
723: x_return_status := FND_API.G_RET_STS_SUCCESS;
724:
725: -- API Body
726: filter_list := Filter_Data_List_Type ();
727: ind := 1;

Line 740: p_one_attrib => FND_API.G_FALSE,

736: p_user_id => p_user_id,
737: p_pd_id => null,
738: p_pd_name => G_FILTER_DATA_NAME || to_char(p_bin_id),
739: p_pd_type => G_FILTER_DATA_TYPE,
740: p_one_attrib => FND_API.G_FALSE,
741: p_pd_attrib_name => null,
742: x_pd_attrib_value => l_attrib_val,
743: x_pd_attrib_tbl => l_pd_attrib_tbl
744: );

Line 746: IF x_return_status = FND_API.G_RET_STS_SUCCESS

742: x_pd_attrib_value => l_attrib_val,
743: x_pd_attrib_tbl => l_pd_attrib_tbl
744: );
745:
746: IF x_return_status = FND_API.G_RET_STS_SUCCESS
747: AND l_pd_attrib_tbl is not null AND l_pd_attrib_tbl.count > 0 THEN
748: FOR f_curr_row IN 1..l_pd_attrib_tbl.count
749: LOOP
750: -- add one more item in filter list

Line 778: IF FND_API.To_Boolean( p_commit ) THEN

774:
775: -- End of API Body
776:
777: -- Standard check of p_commit.
778: IF FND_API.To_Boolean( p_commit ) THEN
779: COMMIT WORK;
780: END IF;
781: -- Standard call to get message count and if count is 1, get message info.
782: FND_MSG_PUB.Count_And_Get

Line 788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

784: p_data => x_msg_data
785: );
786: EXCEPTION
787: WHEN OTHERS THEN
788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
789: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
790: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
791: END IF;
792: FND_MSG_PUB.Count_And_Get

Line 800: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

796: end get_filter_list;
797:
798: procedure get_perz_data_attrib(
799: p_api_version_number IN NUMBER,
800: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
801: p_commit IN VARCHAR := FND_API.G_FALSE,
802: x_return_status OUT NOCOPY VARCHAR2,
803: x_msg_count OUT NOCOPY NUMBER,
804: x_msg_data OUT NOCOPY VARCHAR2,

Line 801: p_commit IN VARCHAR := FND_API.G_FALSE,

797:
798: procedure get_perz_data_attrib(
799: p_api_version_number IN NUMBER,
800: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
801: p_commit IN VARCHAR := FND_API.G_FALSE,
802: x_return_status OUT NOCOPY VARCHAR2,
803: x_msg_count OUT NOCOPY NUMBER,
804: x_msg_data OUT NOCOPY VARCHAR2,
805: p_user_id IN NUMBER := 0,

Line 810: p_one_attrib IN VARCHAR2 := FND_API.G_TRUE,

806: p_prof_name IN VARCHAR2 := NULL,
807: p_pd_id IN NUMBER,
808: p_pd_name IN VARCHAR2,
809: p_pd_type IN VARCHAR2,
810: p_one_attrib IN VARCHAR2 := FND_API.G_TRUE,
811: p_pd_attrib_name IN VARCHAR2 := NULL,
812: --x_pd_id OUT NOCOPY NUMBER,
813: --x_pd_name OUT NOCOPY VARCHAR2,
814: --x_pd_type OUT NOCOPY VARCHAR2,

Line 832: x_return_status := FND_API.G_RET_STS_SUCCESS;

828: out_perz_data_desc VARCHAR2(240);
829: begin
830:
831: -- Initialize API return status to success
832: x_return_status := FND_API.G_RET_STS_SUCCESS;
833: x_pd_attrib_value := NULL;
834:
835: -- API Body
836:

Line 860: if p_one_attrib = FND_API.G_TRUE and p_pd_attrib_name is NULL then

856: if p_pd_type is not NULL then
857: l_pd_type := p_pd_type;
858: end if;
859:
860: if p_one_attrib = FND_API.G_TRUE and p_pd_attrib_name is NULL then
861: RETURN;
862: end if;
863:
864: JTF_PERZ_DATA_PUB.Get_Perz_Data

Line 884: if NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

880: x_msg_count => x_msg_count,
881: x_msg_data => x_msg_data
882: );
883:
884: if NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
885: RETURN;
886: end if;
887:
888: if p_pd_attrib_name is not null then

Line 897: if p_one_attrib = FND_API.G_TRUE then

893: RETURN;
894: end if;
895: end loop;
896:
897: if p_one_attrib = FND_API.G_TRUE then
898: -- the value does not exist
899: x_return_status := FND_API.G_RET_STS_ERROR;
900: x_pd_attrib_value := null;
901: end if;

Line 899: x_return_status := FND_API.G_RET_STS_ERROR;

895: end loop;
896:
897: if p_one_attrib = FND_API.G_TRUE then
898: -- the value does not exist
899: x_return_status := FND_API.G_RET_STS_ERROR;
900: x_pd_attrib_value := null;
901: end if;
902: end if;
903:

Line 907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

903:
904: exception
905: WHEN OTHERS THEN
906: --ROLLBACK TO CS_Process_Order_Line;
907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
908: FND_MSG_PUB.Count_And_Get
909: (p_count => x_msg_count ,
910: p_data => x_msg_data
911: );