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

Line 44: -- Default = FND_API.G_FALSE

40: -- Description Standard API parameter which states
41: -- the api version; used to check
42: -- compatibility of calling code
43: -- p_init_msg_list IN VARCHAR2 Optional
44: -- Default = FND_API.G_FALSE
45: -- Description Standard API parameter which
46: -- specifies whether message stack
47: -- should be re-initialized
48: -- p_commit IN VARCHAR2 Optional

Line 49: -- Default = FND_API.G_FALSE

45: -- Description Standard API parameter which
46: -- specifies whether message stack
47: -- should be re-initialized
48: -- p_commit IN VARCHAR2 Optional
49: -- Default = FND_API.G_FALSE
50: -- Description Standard API parameter; specifies
51: -- whether a commit should be issued
52: -- on successful completion of
53: -- transaction

Line 55: -- Default = FND_API.G_VALID_LEVEL_FULL

51: -- whether a commit should be issued
52: -- on successful completion of
53: -- transaction
54: -- p_validation_level IN NUMBER Optional
55: -- Default = FND_API.G_VALID_LEVEL_FULL
56: -- Description Standard API parameter; specifies
57: -- validation level
58: -- IMPORTANT: USE DEFAULT
59: -- p_comp_group_rec IN comp_group_rec_type Required

Line 67: -- FND_API.G_RE_STS_SUCCESS

63: -- Description The date on which the move is to
64: -- be made
65: -- OUT : x_return_status OUT VARCHAR2(1)
66: -- Description Contains the status of the call
67: -- FND_API.G_RE_STS_SUCCESS
68: -- - SUCCESS
69: -- FND_API.G_RE_STS_UNEXP_ERROR
70: -- - UNEXPECTED ERROR
71: -- FND_API.G_RE_STS_ERROR

Line 69: -- FND_API.G_RE_STS_UNEXP_ERROR

65: -- OUT : x_return_status OUT VARCHAR2(1)
66: -- Description Contains the status of the call
67: -- FND_API.G_RE_STS_SUCCESS
68: -- - SUCCESS
69: -- FND_API.G_RE_STS_UNEXP_ERROR
70: -- - UNEXPECTED ERROR
71: -- FND_API.G_RE_STS_ERROR
72: -- - EXPECTED ERROR
73: -- x_msg_count OUT NUMBER

Line 71: -- FND_API.G_RE_STS_ERROR

67: -- FND_API.G_RE_STS_SUCCESS
68: -- - SUCCESS
69: -- FND_API.G_RE_STS_UNEXP_ERROR
70: -- - UNEXPECTED ERROR
71: -- FND_API.G_RE_STS_ERROR
72: -- - EXPECTED ERROR
73: -- x_msg_count OUT NUMBER
74: -- Description The number of messages in the
75: -- message stack

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

96: -- End of comments
97:
98: PROCEDURE Move_Group
99: (p_api_version IN NUMBER ,
100: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
101: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
102: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
103: p_comp_group_rec IN comp_group_rec_type ,
104: p_effective_move_date IN date ,

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

97:
98: PROCEDURE Move_Group
99: (p_api_version IN NUMBER ,
100: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
101: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
102: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
103: p_comp_group_rec IN comp_group_rec_type ,
104: p_effective_move_date IN date ,
105: p_new_parent_group_id IN cn_comp_groups.comp_group_id%TYPE ,

Line 102: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

98: PROCEDURE Move_Group
99: (p_api_version IN NUMBER ,
100: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
101: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
102: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
103: p_comp_group_rec IN comp_group_rec_type ,
104: p_effective_move_date IN date ,
105: p_new_parent_group_id IN cn_comp_groups.comp_group_id%TYPE ,
106: x_return_status OUT VARCHAR2 ,

Line 123: IF NOT FND_API.Compatible_API_Call (

119: BEGIN
120: -- Standard Start of API savepoint
121: SAVEPOINT Move_Group_PUB;
122: -- Standard call to check for call compatibility.
123: IF NOT FND_API.Compatible_API_Call (
124: l_api_version ,
125: p_api_version ,
126: l_api_name ,
127: G_PKG_NAME )

Line 129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

125: p_api_version ,
126: l_api_name ,
127: G_PKG_NAME )
128: THEN
129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
130: END IF;
131: -- Initialize message list if p_init_msg_list is set to TRUE.
132: IF FND_API.to_Boolean( p_init_msg_list ) THEN
133: FND_MSG_PUB.initialize;

Line 132: IF FND_API.to_Boolean( p_init_msg_list ) THEN

128: THEN
129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
130: END IF;
131: -- Initialize message list if p_init_msg_list is set to TRUE.
132: IF FND_API.to_Boolean( p_init_msg_list ) THEN
133: FND_MSG_PUB.initialize;
134: END IF;
135: -- Initialize API return status to success
136: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 136: x_return_status := FND_API.G_RET_STS_SUCCESS;

132: IF FND_API.to_Boolean( p_init_msg_list ) THEN
133: FND_MSG_PUB.initialize;
134: END IF;
135: -- Initialize API return status to success
136: x_return_status := FND_API.G_RET_STS_SUCCESS;
137: -- API body
138: SELECT group_relate_id, object_version_number
139: INTO l_group_relate_id, l_object_version_number
140: FROM jtf_rs_grp_relations

Line 189: IF FND_API.To_Boolean( p_commit ) THEN

185: --return success
186: assign_errormessage('CN_MOVED');
187: -- End of API body.
188: -- Standard check of p_commit.
189: IF FND_API.To_Boolean( p_commit ) THEN
190: COMMIT WORK;
191: END IF;
192: -- Standard call to get message count and if count is 1, get message info.
193: FND_MSG_PUB.Count_And_get(

Line 197: WHEN FND_API.G_EXC_ERROR THEN

193: FND_MSG_PUB.Count_And_get(
194: p_count => x_msg_count ,
195: p_data => x_msg_data );
196: EXCEPTION
197: WHEN FND_API.G_EXC_ERROR THEN
198: ROLLBACK TO Move_Group_PUB;
199: x_return_status := FND_API.G_RET_STS_ERROR ;
200: FND_MSG_PUB.Count_And_Get(
201: p_count => x_msg_count ,

Line 199: x_return_status := FND_API.G_RET_STS_ERROR ;

195: p_data => x_msg_data );
196: EXCEPTION
197: WHEN FND_API.G_EXC_ERROR THEN
198: ROLLBACK TO Move_Group_PUB;
199: x_return_status := FND_API.G_RET_STS_ERROR ;
200: FND_MSG_PUB.Count_And_Get(
201: p_count => x_msg_count ,
202: p_data => x_msg_data );
203: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 203: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

199: x_return_status := FND_API.G_RET_STS_ERROR ;
200: FND_MSG_PUB.Count_And_Get(
201: p_count => x_msg_count ,
202: p_data => x_msg_data );
203: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
204: ROLLBACK TO Move_Group_PUB;
205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
206: FND_MSG_PUB.Count_And_Get(
207: p_count => x_msg_count ,

Line 205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

201: p_count => x_msg_count ,
202: p_data => x_msg_data );
203: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
204: ROLLBACK TO Move_Group_PUB;
205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
206: FND_MSG_PUB.Count_And_Get(
207: p_count => x_msg_count ,
208: p_data => x_msg_data );
209: WHEN OTHERS THEN

Line 211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

207: p_count => x_msg_count ,
208: p_data => x_msg_data );
209: WHEN OTHERS THEN
210: ROLLBACK TO Move_Group_PUB;
211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
212: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
213: FND_MSG_PUB.Add_Exc_Msg(
214: G_PKG_NAME ,
215: l_api_name );