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

Line 148: p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,

144: P_END_DATE in date,
145: P_LAST_UPDATED_BY in NUMBER := null,
146: P_LAST_UPDATE_LOGIN in NUMBER := null,
147: P_LAST_UPDATE_DATE in DATE := null,
148: p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,
149: p_commit IN VARCHAR2 := fnd_api.g_FALSE,
150: x_return_status OUT NOCOPY VARCHAR2,
151: x_errorcode OUT NOCOPY NUMBER,
152: x_msg_count OUT NOCOPY NUMBER,

Line 149: p_commit IN VARCHAR2 := fnd_api.g_FALSE,

145: P_LAST_UPDATED_BY in NUMBER := null,
146: P_LAST_UPDATE_LOGIN in NUMBER := null,
147: P_LAST_UPDATE_DATE in DATE := null,
148: p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,
149: p_commit IN VARCHAR2 := fnd_api.g_FALSE,
150: x_return_status OUT NOCOPY VARCHAR2,
151: x_errorcode OUT NOCOPY NUMBER,
152: x_msg_count OUT NOCOPY NUMBER,
153: x_msg_data OUT NOCOPY VARCHAR2

Line 176: IF FND_API.to_Boolean( p_init_msg_list ) THEN

172: begin
173:
174: -- Initialize API message list if necessary.
175: -- Initialize message list if p_init_msg_list is set to TRUE.
176: IF FND_API.to_Boolean( p_init_msg_list ) THEN
177: FND_MSG_PUB.initialize;
178: END IF;
179:
180: if (P_ROWID is not null) then

Line 234: x_return_status := FND_API.G_RET_STS_SUCCESS;

230: ) ;
231: end loop;
232: end if;
233:
234: x_return_status := FND_API.G_RET_STS_SUCCESS;
235:
236: -----------------------------------
237: -- Make a standard call to get message count
238: -- and if count is 1, get message info.

Line 254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

250: exception
251: when no_data_found then
252: return;
253: when others then
254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
255: IF FND_MSG_PUB.Check_Msg_Level
256: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
257: THEN
258: FND_MSG_PUB.Add_Exc_Msg

Line 281: p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,

277: P_DIM_LEVEL_VALUE in VARCHAR2,
278: P_LAST_UPDATED_BY in NUMBER := null,
279: P_LAST_UPDATE_LOGIN in NUMBER := null,
280: P_LAST_UPDATE_DATE in DATE := null,
281: p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,
282: p_commit IN VARCHAR2 := fnd_api.g_FALSE,
283: x_return_status OUT NOCOPY VARCHAR2,
284: x_errorcode OUT NOCOPY NUMBER,
285: x_msg_count OUT NOCOPY NUMBER,

Line 282: p_commit IN VARCHAR2 := fnd_api.g_FALSE,

278: P_LAST_UPDATED_BY in NUMBER := null,
279: P_LAST_UPDATE_LOGIN in NUMBER := null,
280: P_LAST_UPDATE_DATE in DATE := null,
281: p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,
282: p_commit IN VARCHAR2 := fnd_api.g_FALSE,
283: x_return_status OUT NOCOPY VARCHAR2,
284: x_errorcode OUT NOCOPY NUMBER,
285: x_msg_count OUT NOCOPY NUMBER,
286: x_msg_data OUT NOCOPY VARCHAR2

Line 298: IF FND_API.to_Boolean( p_init_msg_list ) THEN

294: begin
295:
296: -- Initialize API message list if necessary.
297: -- Initialize message list if p_init_msg_list is set to TRUE.
298: IF FND_API.to_Boolean( p_init_msg_list ) THEN
299: FND_MSG_PUB.initialize;
300: END IF;
301:
302: if (P_ROWID is not null) then

Line 324: x_return_status := FND_API.G_RET_STS_SUCCESS;

320: AND tab_id = P_TAB_ID
321: and dim_level_index = P_DIM_LEVEL_INDEX ;
322: END IF;
323:
324: x_return_status := FND_API.G_RET_STS_SUCCESS;
325:
326: -----------------------------------
327: -- Make a standard call to get message count
328: -- and if count is 1, get message info.

Line 344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

340: exception
341: when no_data_found then
342: return;
343: when others then
344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
345: IF FND_MSG_PUB.Check_Msg_Level
346: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
347: THEN
348: FND_MSG_PUB.Add_Exc_Msg

Line 372: p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,

368: p_CREATED_BY in number :=null,
369: P_LAST_UPDATED_BY in NUMBER := null,
370: P_LAST_UPDATE_LOGIN in NUMBER := null,
371: P_LAST_UPDATE_DATE in DATE := null,
372: p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,
373: p_commit IN VARCHAR2 := fnd_api.g_FALSE,
374: x_return_status OUT NOCOPY VARCHAR2,
375: x_errorcode OUT NOCOPY NUMBER,
376: x_msg_count OUT NOCOPY NUMBER,

Line 373: p_commit IN VARCHAR2 := fnd_api.g_FALSE,

369: P_LAST_UPDATED_BY in NUMBER := null,
370: P_LAST_UPDATE_LOGIN in NUMBER := null,
371: P_LAST_UPDATE_DATE in DATE := null,
372: p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,
373: p_commit IN VARCHAR2 := fnd_api.g_FALSE,
374: x_return_status OUT NOCOPY VARCHAR2,
375: x_errorcode OUT NOCOPY NUMBER,
376: x_msg_count OUT NOCOPY NUMBER,
377: x_msg_data OUT NOCOPY VARCHAR2

Line 391: IF FND_API.to_Boolean( p_init_msg_list ) THEN

387: begin
388:
389: -- Initialize API message list if necessary.
390: -- Initialize message list if p_init_msg_list is set to TRUE.
391: IF FND_API.to_Boolean( p_init_msg_list ) THEN
392: FND_MSG_PUB.initialize;
393: END IF;
394:
395: insert into bsc_user_list_access

Line 420: x_return_status := FND_API.G_RET_STS_SUCCESS;

416: l_last_updated_by,
417: l_last_update_login
418: );
419:
420: x_return_status := FND_API.G_RET_STS_SUCCESS;
421:
422: -----------------------------------
423: -- Make a standard call to get message count
424: -- and if count is 1, get message info.

Line 440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

436: exception
437: when no_data_found then
438: return;
439: when others then
440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
441: IF FND_MSG_PUB.Check_Msg_Level
442: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
443: THEN
444: FND_MSG_PUB.Add_Exc_Msg

Line 519: p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,

515: P_CREATION_DATE in DATE := null,
516: P_LAST_UPDATED_BY in NUMBER := null,
517: P_LAST_UPDATE_LOGIN in NUMBER := null,
518: P_LAST_UPDATE_DATE in DATE := null,
519: p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,
520: p_commit IN VARCHAR2 := fnd_api.g_FALSE,
521: x_return_status OUT NOCOPY VARCHAR2,
522: x_errorcode OUT NOCOPY NUMBER,
523: x_msg_count OUT NOCOPY NUMBER,

Line 520: p_commit IN VARCHAR2 := fnd_api.g_FALSE,

516: P_LAST_UPDATED_BY in NUMBER := null,
517: P_LAST_UPDATE_LOGIN in NUMBER := null,
518: P_LAST_UPDATE_DATE in DATE := null,
519: p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,
520: p_commit IN VARCHAR2 := fnd_api.g_FALSE,
521: x_return_status OUT NOCOPY VARCHAR2,
522: x_errorcode OUT NOCOPY NUMBER,
523: x_msg_count OUT NOCOPY NUMBER,
524: x_msg_data OUT NOCOPY VARCHAR2

Line 570: IF FND_API.to_Boolean( p_init_msg_list ) THEN

566: begin
567: l_dummy:=null;
568: -- Initialize API message list if necessary.
569: -- Initialize message list if p_init_msg_list is set to TRUE.
570: IF FND_API.to_Boolean( p_init_msg_list ) THEN
571: FND_MSG_PUB.initialize;
572: END IF;
573:
574: open row_exists;

Line 654: x_return_status := FND_API.G_RET_STS_SUCCESS;

650:
651: end if;
652:
653:
654: x_return_status := FND_API.G_RET_STS_SUCCESS;
655:
656: -----------------------------------
657: -- Make a standard call to get message count
658: -- and if count is 1, get message info.

Line 674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

670: exception
671: when no_data_found then
672: return;
673: when others then
674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
675: IF FND_MSG_PUB.Check_Msg_Level
676: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
677: THEN
678: FND_MSG_PUB.Add_Exc_Msg

Line 703: p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,

699: P_CREATION_DATE in DATE := null,
700: P_LAST_UPDATED_BY in NUMBER := null,
701: P_LAST_UPDATE_LOGIN in NUMBER := null,
702: P_LAST_UPDATE_DATE in DATE := null,
703: p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,
704: p_commit IN VARCHAR2 := fnd_api.g_FALSE,
705: x_return_status OUT NOCOPY VARCHAR2,
706: x_errorcode OUT NOCOPY NUMBER,
707: x_msg_count OUT NOCOPY NUMBER,

Line 704: p_commit IN VARCHAR2 := fnd_api.g_FALSE,

700: P_LAST_UPDATED_BY in NUMBER := null,
701: P_LAST_UPDATE_LOGIN in NUMBER := null,
702: P_LAST_UPDATE_DATE in DATE := null,
703: p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,
704: p_commit IN VARCHAR2 := fnd_api.g_FALSE,
705: x_return_status OUT NOCOPY VARCHAR2,
706: x_errorcode OUT NOCOPY NUMBER,
707: x_msg_count OUT NOCOPY NUMBER,
708: x_msg_data OUT NOCOPY VARCHAR2

Line 734: IF FND_API.to_Boolean( p_init_msg_list ) THEN

730: begin
731: l_dummy:=null;
732: -- Initialize API message list if necessary.
733: -- Initialize message list if p_init_msg_list is set to TRUE.
734: IF FND_API.to_Boolean( p_init_msg_list ) THEN
735: FND_MSG_PUB.initialize;
736: END IF;
737:
738: open row_exists;

Line 782: x_return_status := FND_API.G_RET_STS_SUCCESS;

778: L_LAST_UPDATE_LOGIN,
779: L_LAST_UPDATE_DATE);
780: end if;
781:
782: x_return_status := FND_API.G_RET_STS_SUCCESS;
783:
784: -----------------------------------
785: -- Make a standard call to get message count
786: -- and if count is 1, get message info.

Line 802: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

798: exception
799: when no_data_found then
800: return;
801: when others then
802: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
803: IF FND_MSG_PUB.Check_Msg_Level
804: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
805: THEN
806: FND_MSG_PUB.Add_Exc_Msg

Line 830: p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,

826: P_END_DATE in date,
827: P_LAST_UPDATED_BY in NUMBER := null,
828: P_LAST_UPDATE_LOGIN in NUMBER := null,
829: P_LAST_UPDATE_DATE in DATE := null,
830: p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,
831: p_commit IN VARCHAR2 := fnd_api.g_FALSE,
832: x_return_status OUT NOCOPY VARCHAR2,
833: x_errorcode OUT NOCOPY NUMBER,
834: x_msg_count OUT NOCOPY NUMBER,

Line 831: p_commit IN VARCHAR2 := fnd_api.g_FALSE,

827: P_LAST_UPDATED_BY in NUMBER := null,
828: P_LAST_UPDATE_LOGIN in NUMBER := null,
829: P_LAST_UPDATE_DATE in DATE := null,
830: p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,
831: p_commit IN VARCHAR2 := fnd_api.g_FALSE,
832: x_return_status OUT NOCOPY VARCHAR2,
833: x_errorcode OUT NOCOPY NUMBER,
834: x_msg_count OUT NOCOPY NUMBER,
835: x_msg_data OUT NOCOPY VARCHAR2

Line 847: IF FND_API.to_Boolean( p_init_msg_list ) THEN

843: begin
844:
845: -- Initialize API message list if necessary.
846: -- Initialize message list if p_init_msg_list is set to TRUE.
847: IF FND_API.to_Boolean( p_init_msg_list ) THEN
848: FND_MSG_PUB.initialize;
849: END IF;
850:
851: if (P_ROWID is not null) then

Line 873: x_return_status := FND_API.G_RET_STS_SUCCESS;

869: WHERE responsibility_id = P_RESP_ID
870: AND indicator = P_INDICATOR ;
871: END IF;
872:
873: x_return_status := FND_API.G_RET_STS_SUCCESS;
874:
875: -----------------------------------
876: -- Make a standard call to get message count
877: -- and if count is 1, get message info.

Line 893: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

889: exception
890: when no_data_found then
891: return;
892: when others then
893: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
894: IF FND_MSG_PUB.Check_Msg_Level
895: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
896: THEN
897: FND_MSG_PUB.Add_Exc_Msg

Line 914: p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,

910:
911: procedure remove_kpi_access(
912: p_resp_id in number,
913: p_indicator in number,
914: p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,
915: p_commit IN VARCHAR2 := fnd_api.g_FALSE,
916: x_return_status OUT NOCOPY VARCHAR2,
917: x_errorcode OUT NOCOPY NUMBER,
918: x_msg_count OUT NOCOPY NUMBER,

Line 915: p_commit IN VARCHAR2 := fnd_api.g_FALSE,

911: procedure remove_kpi_access(
912: p_resp_id in number,
913: p_indicator in number,
914: p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,
915: p_commit IN VARCHAR2 := fnd_api.g_FALSE,
916: x_return_status OUT NOCOPY VARCHAR2,
917: x_errorcode OUT NOCOPY NUMBER,
918: x_msg_count OUT NOCOPY NUMBER,
919: x_msg_data OUT NOCOPY VARCHAR2

Line 925: IF FND_API.to_Boolean( p_init_msg_list ) THEN

921: l_api_name CONSTANT VARCHAR2(30) := 'remove_kpi_access';
922: begin
923: -- Initialize API message list if necessary.
924: -- Initialize message list if p_init_msg_list is set to TRUE.
925: IF FND_API.to_Boolean( p_init_msg_list ) THEN
926: FND_MSG_PUB.initialize;
927: END IF;
928:
929: delete from bsc_user_kpi_access

Line 934: x_return_status := FND_API.G_RET_STS_SUCCESS;

930: where responsibility_id=p_resp_id
931: and indicator=p_indicator;
932:
933:
934: x_return_status := FND_API.G_RET_STS_SUCCESS;
935:
936: -----------------------------------
937: -- Make a standard call to get message count
938: -- and if count is 1, get message info.

Line 954: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

950: exception
951: when no_data_found then
952: return;
953: when others then
954: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
955: IF FND_MSG_PUB.Check_Msg_Level
956: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
957: THEN
958: FND_MSG_PUB.Add_Exc_Msg