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_OVER_ASSIGN_PVT dependencies on FND_API

Line 63: RAISE FND_API.G_EXC_ERROR;

59: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
60: FND_MESSAGE.SET_NAME ('CN' , 'CN_QM_SR_ED_NULL');
61: FND_MSG_PUB.Add;
62: END IF;
63: RAISE FND_API.G_EXC_ERROR;
64: END IF;
65:
66: IF srp_role_info%notfound THEN
67: -- invalid srp_role_id

Line 68: RAISE FND_API.G_EXC_ERROR;

64: END IF;
65:
66: IF srp_role_info%notfound THEN
67: -- invalid srp_role_id
68: RAISE FND_API.G_EXC_ERROR;
69: END IF;
70: CLOSE srp_role_info;
71:
72: IF x_quota.COUNT > 0 THEN

Line 257: -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)

253: --
254: --
255: -- Parameters :
256: -- IN : p_api_version NUMBER Require
257: -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)
258: -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)
259: -- p_validation_level NUMBER Optional (FND_API.G_VALID_LEVEL_FULL)
260: -- OUT : x_return_status VARCHAR2(1)
261: -- x_msg_count NUMBER

Line 258: -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)

254: --
255: -- Parameters :
256: -- IN : p_api_version NUMBER Require
257: -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)
258: -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)
259: -- p_validation_level NUMBER Optional (FND_API.G_VALID_LEVEL_FULL)
260: -- OUT : x_return_status VARCHAR2(1)
261: -- x_msg_count NUMBER
262: -- x_msg_data VARCHAR2(2000)

Line 259: -- p_validation_level NUMBER Optional (FND_API.G_VALID_LEVEL_FULL)

255: -- Parameters :
256: -- IN : p_api_version NUMBER Require
257: -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)
258: -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)
259: -- p_validation_level NUMBER Optional (FND_API.G_VALID_LEVEL_FULL)
260: -- OUT : x_return_status VARCHAR2(1)
261: -- x_msg_count NUMBER
262: -- x_msg_data VARCHAR2(2000)
263: -- IN : p_srp_role_id NUMBER, Required

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

274: -- End of comments
275:
276: PROCEDURE get_overassign
277: ( p_api_version IN NUMBER,
278: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
279: p_commit IN VARCHAR2 := FND_API.G_FALSE,
280: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
281: x_return_status OUT NOCOPY VARCHAR2,
282: x_msg_count OUT NOCOPY NUMBER,

Line 279: p_commit IN VARCHAR2 := FND_API.G_FALSE,

275:
276: PROCEDURE get_overassign
277: ( p_api_version IN NUMBER,
278: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
279: p_commit IN VARCHAR2 := FND_API.G_FALSE,
280: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
281: x_return_status OUT NOCOPY VARCHAR2,
282: x_msg_count OUT NOCOPY NUMBER,
283: x_msg_data OUT NOCOPY VARCHAR2,

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

276: PROCEDURE get_overassign
277: ( p_api_version IN NUMBER,
278: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
279: p_commit IN VARCHAR2 := FND_API.G_FALSE,
280: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
281: x_return_status OUT NOCOPY VARCHAR2,
282: x_msg_count OUT NOCOPY NUMBER,
283: x_msg_data OUT NOCOPY VARCHAR2,
284: p_qm_mgr_srp_group_id IN NUMBER ,

Line 395: IF NOT FND_API.Compatible_API_Call( l_api_version ,p_api_version ,

391:
392: BEGIN
393:
394: -- Standard call to check for call compatibility.
395: IF NOT FND_API.Compatible_API_Call( l_api_version ,p_api_version ,
396: l_api_name ,G_PKG_NAME ) THEN
397: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
398: END IF;
399:

Line 397: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

393:
394: -- Standard call to check for call compatibility.
395: IF NOT FND_API.Compatible_API_Call( l_api_version ,p_api_version ,
396: l_api_name ,G_PKG_NAME ) THEN
397: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
398: END IF;
399:
400: -- Initialize message list if p_init_msg_list is set to TRUE.
401: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 401: IF FND_API.to_Boolean( p_init_msg_list ) THEN

397: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
398: END IF;
399:
400: -- Initialize message list if p_init_msg_list is set to TRUE.
401: IF FND_API.to_Boolean( p_init_msg_list ) THEN
402: FND_MSG_PUB.initialize;
403: END IF;
404:
405: -- Initialize API return status to success

Line 406: x_return_status := FND_API.G_RET_STS_SUCCESS;

402: FND_MSG_PUB.initialize;
403: END IF;
404:
405: -- Initialize API return status to success
406: x_return_status := FND_API.G_RET_STS_SUCCESS;
407:
408: -- get related information about this salesrep
409: OPEN c_srp_info;
410: FETCH c_srp_info INTO l_srp_info;

Line 418: RAISE FND_API.G_EXC_ERROR;

414: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
415: FND_MESSAGE.SET_NAME ('CN' , 'CN_QM_SR_ED_NULL');
416: FND_MSG_PUB.Add;
417: END IF;
418: RAISE FND_API.G_EXC_ERROR;
419: END IF;
420:
421: IF c_srp_info%notfound THEN
422: -- invalid srp_role_id

Line 427: RAISE FND_API.G_EXC_ERROR;

423: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
424: FND_MESSAGE.SET_NAME ('CN' , 'CN_QM_INVALID_SRPROLE');
425: FND_MSG_PUB.Add;
426: END IF;
427: RAISE FND_API.G_EXC_ERROR;
428: END IF;
429: CLOSE c_srp_info;
430:
431: -- Check if this srp is manager

Line 749: p_encoded => FND_API.G_FALSE

745: -- Standard call to get message count and if count is 1 get message info.
746: FND_MSG_PUB.Count_And_Get
747: ( p_count => x_msg_count ,
748: p_data => x_msg_data ,
749: p_encoded => FND_API.G_FALSE
750: );
751:
752: EXCEPTION
753: WHEN FND_API.G_EXC_ERROR THEN

Line 753: WHEN FND_API.G_EXC_ERROR THEN

749: p_encoded => FND_API.G_FALSE
750: );
751:
752: EXCEPTION
753: WHEN FND_API.G_EXC_ERROR THEN
754: x_return_status := FND_API.G_RET_STS_ERROR ;
755: FND_MSG_PUB.Count_And_Get
756: (p_count => x_msg_count ,
757: p_data => x_msg_data ,

Line 754: x_return_status := FND_API.G_RET_STS_ERROR ;

750: );
751:
752: EXCEPTION
753: WHEN FND_API.G_EXC_ERROR THEN
754: x_return_status := FND_API.G_RET_STS_ERROR ;
755: FND_MSG_PUB.Count_And_Get
756: (p_count => x_msg_count ,
757: p_data => x_msg_data ,
758: p_encoded => FND_API.G_FALSE

Line 758: p_encoded => FND_API.G_FALSE

754: x_return_status := FND_API.G_RET_STS_ERROR ;
755: FND_MSG_PUB.Count_And_Get
756: (p_count => x_msg_count ,
757: p_data => x_msg_data ,
758: p_encoded => FND_API.G_FALSE
759: );
760: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
762: FND_MSG_PUB.Count_And_Get

Line 760: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

756: (p_count => x_msg_count ,
757: p_data => x_msg_data ,
758: p_encoded => FND_API.G_FALSE
759: );
760: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
762: FND_MSG_PUB.Count_And_Get
763: (p_count => x_msg_count ,
764: p_data => x_msg_data ,

Line 761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

757: p_data => x_msg_data ,
758: p_encoded => FND_API.G_FALSE
759: );
760: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
762: FND_MSG_PUB.Count_And_Get
763: (p_count => x_msg_count ,
764: p_data => x_msg_data ,
765: p_encoded => FND_API.G_FALSE

Line 765: p_encoded => FND_API.G_FALSE

761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
762: FND_MSG_PUB.Count_And_Get
763: (p_count => x_msg_count ,
764: p_data => x_msg_data ,
765: p_encoded => FND_API.G_FALSE
766: );
767: WHEN OTHERS THEN
768: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
769: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 768: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

764: p_data => x_msg_data ,
765: p_encoded => FND_API.G_FALSE
766: );
767: WHEN OTHERS THEN
768: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
769: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
770: THEN
771: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
772: END IF;

Line 776: p_encoded => FND_API.G_FALSE

772: END IF;
773: FND_MSG_PUB.Count_And_Get
774: (p_count => x_msg_count ,
775: p_data => x_msg_data ,
776: p_encoded => FND_API.G_FALSE
777: );
778: END;
779:
780: END cn_over_assign_pvt;