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

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

10: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
11: --
12: PROCEDURE get_comp_group_hier(
13: p_api_version IN NUMBER,
14: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
15: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
16: p_salesrep_id IN NUMBER ,
17: p_comp_group_id IN NUMBER,
18: p_focus_cg_id IN NUMBER,

Line 15: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,

11: --
12: PROCEDURE get_comp_group_hier(
13: p_api_version IN NUMBER,
14: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
15: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
16: p_salesrep_id IN NUMBER ,
17: p_comp_group_id IN NUMBER,
18: p_focus_cg_id IN NUMBER,
19: p_expand IN CHAR,

Line 96: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

92: (cscg.end_date_active >= l_date));
93:
94: BEGIN
95: -- Standard call to check for call compatibility.
96: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
97: p_api_version ,
98: l_api_name,
99: G_PKG_NAME ) THEN
100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

96: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
97: p_api_version ,
98: l_api_name,
99: G_PKG_NAME ) THEN
100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
101: END IF;
102:
103: -- Initialize message list if p_init_msg_list is set to TRUE.
104: IF FND_API.to_Boolean(p_init_msg_list ) THEN

Line 104: IF FND_API.to_Boolean(p_init_msg_list ) THEN

100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
101: END IF;
102:
103: -- Initialize message list if p_init_msg_list is set to TRUE.
104: IF FND_API.to_Boolean(p_init_msg_list ) THEN
105: FND_MSG_PUB.initialize;
106: END IF;
107:
108: -- Initialize API return status to success

Line 109: x_return_status := FND_API.G_RET_STS_SUCCESS;

105: FND_MSG_PUB.initialize;
106: END IF;
107:
108: -- Initialize API return status to success
109: x_return_status := FND_API.G_RET_STS_SUCCESS;
110: x_loading_status := 'CN_INSERTED';
111: l_mgr_count := 0;
112: l_counter := 0;
113: -- Before doing anything, check whether the comp_group_id

Line 333: WHEN FND_API.G_EXC_ERROR THEN

329: END LOOP;
330: l_mgr_count := x_mgr_tbl.COUNT;
331: END IF;
332: EXCEPTION
333: WHEN FND_API.G_EXC_ERROR THEN
334: x_return_status := FND_API.G_RET_STS_ERROR ;
335: FND_MSG_PUB.Count_And_Get(
336: p_count => x_msg_count,
337: p_data => x_msg_data ,

Line 334: x_return_status := FND_API.G_RET_STS_ERROR ;

330: l_mgr_count := x_mgr_tbl.COUNT;
331: END IF;
332: EXCEPTION
333: WHEN FND_API.G_EXC_ERROR THEN
334: x_return_status := FND_API.G_RET_STS_ERROR ;
335: FND_MSG_PUB.Count_And_Get(
336: p_count => x_msg_count,
337: p_data => x_msg_data ,
338: p_encoded => FND_API.G_FALSE);

Line 338: p_encoded => FND_API.G_FALSE);

334: x_return_status := FND_API.G_RET_STS_ERROR ;
335: FND_MSG_PUB.Count_And_Get(
336: p_count => x_msg_count,
337: p_data => x_msg_data ,
338: p_encoded => FND_API.G_FALSE);
339: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
340: x_loading_status := 'UNEXPECTED_ERR';
341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
342: FND_MSG_PUB.Count_And_Get(

Line 339: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

335: FND_MSG_PUB.Count_And_Get(
336: p_count => x_msg_count,
337: p_data => x_msg_data ,
338: p_encoded => FND_API.G_FALSE);
339: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
340: x_loading_status := 'UNEXPECTED_ERR';
341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
342: FND_MSG_PUB.Count_And_Get(
343: p_count => x_msg_count,

Line 341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

337: p_data => x_msg_data ,
338: p_encoded => FND_API.G_FALSE);
339: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
340: x_loading_status := 'UNEXPECTED_ERR';
341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
342: FND_MSG_PUB.Count_And_Get(
343: p_count => x_msg_count,
344: p_data => x_msg_data,
345: p_encoded => FND_API.G_FALSE);

Line 345: p_encoded => FND_API.G_FALSE);

341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
342: FND_MSG_PUB.Count_And_Get(
343: p_count => x_msg_count,
344: p_data => x_msg_data,
345: p_encoded => FND_API.G_FALSE);
346: WHEN OTHERS THEN
347: x_loading_status := 'UNEXPECTED_ERR';
348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
349: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

344: p_data => x_msg_data,
345: p_encoded => FND_API.G_FALSE);
346: WHEN OTHERS THEN
347: x_loading_status := 'UNEXPECTED_ERR';
348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
349: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
350: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
351: END IF;
352: FND_MSG_PUB.Count_And_Get(

Line 355: p_encoded => FND_API.G_FALSE);

351: END IF;
352: FND_MSG_PUB.Count_And_Get(
353: p_count => x_msg_count ,
354: p_data => x_msg_data ,
355: p_encoded => FND_API.G_FALSE);
356:
357: END;
358: --
359: END cn_comp_grp_hier_pub;