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

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

7: -- Type : Private.
8: -- Pre-reqs : None
9: -- Parameters :
10: -- IN : p_api_version NUMBER Require
11: -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)
12: -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)
13: -- p_validation_level NUMBER Optional (FND_API.G_VALID_LEVEL_FULL)
14: -- OUT : x_return_status VARCHAR2(1)
15: -- x_msg_count NUMBER

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

8: -- Pre-reqs : None
9: -- Parameters :
10: -- IN : p_api_version NUMBER Require
11: -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)
12: -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)
13: -- p_validation_level NUMBER Optional (FND_API.G_VALID_LEVEL_FULL)
14: -- OUT : x_return_status VARCHAR2(1)
15: -- x_msg_count NUMBER
16: -- x_msg_data VARCHAR2(2000)

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

9: -- Parameters :
10: -- IN : p_api_version NUMBER Require
11: -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)
12: -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)
13: -- p_validation_level NUMBER Optional (FND_API.G_VALID_LEVEL_FULL)
14: -- OUT : x_return_status VARCHAR2(1)
15: -- x_msg_count NUMBER
16: -- x_msg_data VARCHAR2(2000)
17: -- Version : Current version 1.0

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

22: -- End of comments
23:
24: PROCEDURE get_active_role
25: ( p_api_version IN NUMBER,
26: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
27: p_commit IN VARCHAR2 := FND_API.G_FALSE,
28: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
29: x_return_status OUT NOCOPY VARCHAR2,
30: x_msg_count OUT NOCOPY NUMBER,

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

23:
24: PROCEDURE get_active_role
25: ( p_api_version IN NUMBER,
26: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
27: p_commit IN VARCHAR2 := FND_API.G_FALSE,
28: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
29: x_return_status OUT NOCOPY VARCHAR2,
30: x_msg_count OUT NOCOPY NUMBER,
31: x_msg_data OUT NOCOPY VARCHAR2,

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

24: PROCEDURE get_active_role
25: ( p_api_version IN NUMBER,
26: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
27: p_commit IN VARCHAR2 := FND_API.G_FALSE,
28: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
29: x_return_status OUT NOCOPY VARCHAR2,
30: x_msg_count OUT NOCOPY NUMBER,
31: x_msg_data OUT NOCOPY VARCHAR2,
32: p_org_id IN NUMBER,

Line 55: IF NOT FND_API.Compatible_API_Call

51: AND (end_date_active IS NULL OR p_srp.start_date <= end_date_active)
52: AND (p_srp.end_date IS NULL OR p_srp.end_date >= start_date_active);
53: BEGIN
54: -- Standard call to check for call compatibility.
55: IF NOT FND_API.Compatible_API_Call
56: (l_api_version ,
57: p_api_version ,
58: l_api_name ,
59: G_PKG_NAME )

Line 61: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

57: p_api_version ,
58: l_api_name ,
59: G_PKG_NAME )
60: THEN
61: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
62: END IF;
63:
64: -- Initialize message list if p_init_msg_list is set to TRUE.
65: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 65: IF FND_API.to_Boolean( p_init_msg_list ) THEN

61: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
62: END IF;
63:
64: -- Initialize message list if p_init_msg_list is set to TRUE.
65: IF FND_API.to_Boolean( p_init_msg_list ) THEN
66: FND_MSG_PUB.initialize;
67: END IF;
68:
69: -- Initialize API return status to success

Line 70: x_return_status := FND_API.G_RET_STS_SUCCESS;

66: FND_MSG_PUB.initialize;
67: END IF;
68:
69: -- Initialize API return status to success
70: x_return_status := FND_API.G_RET_STS_SUCCESS;
71:
72: -- API body
73:
74: l_counter := 0;

Line 90: WHEN FND_API.G_EXC_ERROR THEN

86: FND_MSG_PUB.Count_And_Get
87: (p_count => x_msg_count ,
88: p_data => x_msg_data );
89: EXCEPTION
90: WHEN FND_API.G_EXC_ERROR THEN
91: x_return_status := FND_API.G_RET_STS_ERROR ;
92: FND_MSG_PUB.Count_And_Get
93: (p_count => x_msg_count ,
94: p_data => x_msg_data );

Line 91: x_return_status := FND_API.G_RET_STS_ERROR ;

87: (p_count => x_msg_count ,
88: p_data => x_msg_data );
89: EXCEPTION
90: WHEN FND_API.G_EXC_ERROR THEN
91: x_return_status := FND_API.G_RET_STS_ERROR ;
92: FND_MSG_PUB.Count_And_Get
93: (p_count => x_msg_count ,
94: p_data => x_msg_data );
95: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 95: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

91: x_return_status := FND_API.G_RET_STS_ERROR ;
92: FND_MSG_PUB.Count_And_Get
93: (p_count => x_msg_count ,
94: p_data => x_msg_data );
95: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
96: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
97: FND_MSG_PUB.Count_And_Get
98: (p_count => x_msg_count ,
99: p_data => x_msg_data );

Line 96: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

92: FND_MSG_PUB.Count_And_Get
93: (p_count => x_msg_count ,
94: p_data => x_msg_data );
95: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
96: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
97: FND_MSG_PUB.Count_And_Get
98: (p_count => x_msg_count ,
99: p_data => x_msg_data );
100: WHEN OTHERS THEN

Line 101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

97: FND_MSG_PUB.Count_And_Get
98: (p_count => x_msg_count ,
99: p_data => x_msg_data );
100: WHEN OTHERS THEN
101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
102: IF FND_MSG_PUB.Check_Msg_Level
103: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
104: THEN
105: FND_MSG_PUB.Add_Exc_Msg

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

122: -- Type : Private.
123: -- Pre-reqs : None
124: -- Parameters :
125: -- IN : p_api_version NUMBER Require
126: -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)
127: -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)
128: -- p_validation_level NUMBER Optional (FND_API.G_VALID_LEVEL_FULL)
129: -- OUT : x_return_status VARCHAR2(1)
130: -- x_msg_count NUMBER

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

123: -- Pre-reqs : None
124: -- Parameters :
125: -- IN : p_api_version NUMBER Require
126: -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)
127: -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)
128: -- p_validation_level NUMBER Optional (FND_API.G_VALID_LEVEL_FULL)
129: -- OUT : x_return_status VARCHAR2(1)
130: -- x_msg_count NUMBER
131: -- x_msg_data VARCHAR2(2000)

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

124: -- Parameters :
125: -- IN : p_api_version NUMBER Require
126: -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)
127: -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)
128: -- p_validation_level NUMBER Optional (FND_API.G_VALID_LEVEL_FULL)
129: -- OUT : x_return_status VARCHAR2(1)
130: -- x_msg_count NUMBER
131: -- x_msg_data VARCHAR2(2000)
132: --

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

138: -- End of comments
139:
140: PROCEDURE get_active_group_member
141: ( p_api_version IN NUMBER,
142: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
143: p_commit IN VARCHAR2 := FND_API.G_FALSE,
144: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
145: x_return_status OUT NOCOPY VARCHAR2,
146: x_msg_count OUT NOCOPY NUMBER,

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

139:
140: PROCEDURE get_active_group_member
141: ( p_api_version IN NUMBER,
142: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
143: p_commit IN VARCHAR2 := FND_API.G_FALSE,
144: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
145: x_return_status OUT NOCOPY VARCHAR2,
146: x_msg_count OUT NOCOPY NUMBER,
147: x_msg_data OUT NOCOPY VARCHAR2,

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

140: PROCEDURE get_active_group_member
141: ( p_api_version IN NUMBER,
142: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
143: p_commit IN VARCHAR2 := FND_API.G_FALSE,
144: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
145: x_return_status OUT NOCOPY VARCHAR2,
146: x_msg_count OUT NOCOPY NUMBER,
147: x_msg_data OUT NOCOPY VARCHAR2,
148: p_org_id IN NUMBER,

Line 171: IF NOT FND_API.Compatible_API_Call

167:
168: l_counter NUMBER(15);
169: BEGIN
170: -- Standard call to check for call compatibility.
171: IF NOT FND_API.Compatible_API_Call
172: (l_api_version ,
173: p_api_version ,
174: l_api_name ,
175: G_PKG_NAME )

Line 177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

173: p_api_version ,
174: l_api_name ,
175: G_PKG_NAME )
176: THEN
177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
178: END IF;
179:
180: -- Initialize message list if p_init_msg_list is set to TRUE.
181: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 181: IF FND_API.to_Boolean( p_init_msg_list ) THEN

177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
178: END IF;
179:
180: -- Initialize message list if p_init_msg_list is set to TRUE.
181: IF FND_API.to_Boolean( p_init_msg_list ) THEN
182: FND_MSG_PUB.initialize;
183: END IF;
184:
185: -- Initialize API return status to success

Line 186: x_return_status := FND_API.G_RET_STS_SUCCESS;

182: FND_MSG_PUB.initialize;
183: END IF;
184:
185: -- Initialize API return status to success
186: x_return_status := FND_API.G_RET_STS_SUCCESS;
187:
188: -- API body
189:
190: l_counter := 0;

Line 208: WHEN FND_API.G_EXC_ERROR THEN

204: FND_MSG_PUB.Count_And_Get
205: (p_count => x_msg_count ,
206: p_data => x_msg_data );
207: EXCEPTION
208: WHEN FND_API.G_EXC_ERROR THEN
209: x_return_status := FND_API.G_RET_STS_ERROR ;
210: FND_MSG_PUB.Count_And_Get
211: (p_count => x_msg_count ,
212: p_data => x_msg_data );

Line 209: x_return_status := FND_API.G_RET_STS_ERROR ;

205: (p_count => x_msg_count ,
206: p_data => x_msg_data );
207: EXCEPTION
208: WHEN FND_API.G_EXC_ERROR THEN
209: x_return_status := FND_API.G_RET_STS_ERROR ;
210: FND_MSG_PUB.Count_And_Get
211: (p_count => x_msg_count ,
212: p_data => x_msg_data );
213: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 213: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

209: x_return_status := FND_API.G_RET_STS_ERROR ;
210: FND_MSG_PUB.Count_And_Get
211: (p_count => x_msg_count ,
212: p_data => x_msg_data );
213: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
215: FND_MSG_PUB.Count_And_Get
216: (p_count => x_msg_count ,
217: p_data => x_msg_data );

Line 214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

210: FND_MSG_PUB.Count_And_Get
211: (p_count => x_msg_count ,
212: p_data => x_msg_data );
213: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
215: FND_MSG_PUB.Count_And_Get
216: (p_count => x_msg_count ,
217: p_data => x_msg_data );
218: WHEN OTHERS THEN

Line 219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

215: FND_MSG_PUB.Count_And_Get
216: (p_count => x_msg_count ,
217: p_data => x_msg_data );
218: WHEN OTHERS THEN
219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
220: IF FND_MSG_PUB.Check_Msg_Level
221: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
222: THEN
223: FND_MSG_PUB.Add_Exc_Msg

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

240: -- Pre-reqs : None
241: --
242: -- Parameters :
243: -- IN : p_api_version NUMBER Require
244: -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)
245: -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)
246: -- p_validation_level NUMBER Optional (FND_API.G_VALID_LEVEL_FULL)
247: -- OUT : x_return_status VARCHAR2(1)
248: -- x_msg_count NUMBER

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

241: --
242: -- Parameters :
243: -- IN : p_api_version NUMBER Require
244: -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)
245: -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)
246: -- p_validation_level NUMBER Optional (FND_API.G_VALID_LEVEL_FULL)
247: -- OUT : x_return_status VARCHAR2(1)
248: -- x_msg_count NUMBER
249: -- x_msg_data VARCHAR2(2000)

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

242: -- Parameters :
243: -- IN : p_api_version NUMBER Require
244: -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)
245: -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)
246: -- p_validation_level NUMBER Optional (FND_API.G_VALID_LEVEL_FULL)
247: -- OUT : x_return_status VARCHAR2(1)
248: -- x_msg_count NUMBER
249: -- x_msg_data VARCHAR2(2000)
250: -- Version : Current version 1.0

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

255: -- End of comments
256:
257: PROCEDURE get_active_group_member
258: ( p_api_version IN NUMBER,
259: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
260: p_commit IN VARCHAR2 := FND_API.G_FALSE,
261: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
262: x_return_status OUT NOCOPY VARCHAR2,
263: x_msg_count OUT NOCOPY NUMBER,

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

256:
257: PROCEDURE get_active_group_member
258: ( p_api_version IN NUMBER,
259: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
260: p_commit IN VARCHAR2 := FND_API.G_FALSE,
261: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
262: x_return_status OUT NOCOPY VARCHAR2,
263: x_msg_count OUT NOCOPY NUMBER,
264: x_msg_data OUT NOCOPY VARCHAR2,

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

257: PROCEDURE get_active_group_member
258: ( p_api_version IN NUMBER,
259: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
260: p_commit IN VARCHAR2 := FND_API.G_FALSE,
261: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
262: x_return_status OUT NOCOPY VARCHAR2,
263: x_msg_count OUT NOCOPY NUMBER,
264: x_msg_data OUT NOCOPY VARCHAR2,
265: p_org_id IN NUMBER,

Line 277: IF NOT FND_API.Compatible_API_Call

273:
274: l_group_member cn_rollup_pvt.group_mem_tbl_type;
275: BEGIN
276: -- Standard call to check for call compatibility.
277: IF NOT FND_API.Compatible_API_Call
278: (l_api_version ,
279: p_api_version ,
280: l_api_name ,
281: G_PKG_NAME )

Line 283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

279: p_api_version ,
280: l_api_name ,
281: G_PKG_NAME )
282: THEN
283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
284: END IF;
285:
286: -- Initialize message list if p_init_msg_list is set to TRUE.
287: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 287: IF FND_API.to_Boolean( p_init_msg_list ) THEN

283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
284: END IF;
285:
286: -- Initialize message list if p_init_msg_list is set to TRUE.
287: IF FND_API.to_Boolean( p_init_msg_list ) THEN
288: FND_MSG_PUB.initialize;
289: END IF;
290:
291: -- Initialize API return status to success

Line 292: x_return_status := FND_API.G_RET_STS_SUCCESS;

288: FND_MSG_PUB.initialize;
289: END IF;
290:
291: -- Initialize API return status to success
292: x_return_status := FND_API.G_RET_STS_SUCCESS;
293:
294: -- API body
295:
296: l_counter := 0;

Line 327: WHEN FND_API.G_EXC_ERROR THEN

323: FND_MSG_PUB.Count_And_Get
324: (p_count => x_msg_count ,
325: p_data => x_msg_data );
326: EXCEPTION
327: WHEN FND_API.G_EXC_ERROR THEN
328: x_return_status := FND_API.G_RET_STS_ERROR ;
329: FND_MSG_PUB.Count_And_Get
330: (p_count => x_msg_count ,
331: p_data => x_msg_data );

Line 328: x_return_status := FND_API.G_RET_STS_ERROR ;

324: (p_count => x_msg_count ,
325: p_data => x_msg_data );
326: EXCEPTION
327: WHEN FND_API.G_EXC_ERROR THEN
328: x_return_status := FND_API.G_RET_STS_ERROR ;
329: FND_MSG_PUB.Count_And_Get
330: (p_count => x_msg_count ,
331: p_data => x_msg_data );
332: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 332: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

328: x_return_status := FND_API.G_RET_STS_ERROR ;
329: FND_MSG_PUB.Count_And_Get
330: (p_count => x_msg_count ,
331: p_data => x_msg_data );
332: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
334: FND_MSG_PUB.Count_And_Get
335: (p_count => x_msg_count ,
336: p_data => x_msg_data );

Line 333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

329: FND_MSG_PUB.Count_And_Get
330: (p_count => x_msg_count ,
331: p_data => x_msg_data );
332: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
334: FND_MSG_PUB.Count_And_Get
335: (p_count => x_msg_count ,
336: p_data => x_msg_data );
337: WHEN OTHERS THEN

Line 338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

334: FND_MSG_PUB.Count_And_Get
335: (p_count => x_msg_count ,
336: p_data => x_msg_data );
337: WHEN OTHERS THEN
338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
339: IF FND_MSG_PUB.Check_Msg_Level
340: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
341: THEN
342: FND_MSG_PUB.Add_Exc_Msg

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

360: -- Usage :
361: --
362: -- Parameters :
363: -- IN : p_api_version NUMBER Require
364: -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)
365: -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)
366: -- p_validation_level NUMBER Optional (FND_API.G_VALID_LEVEL_FULL)
367: -- OUT : x_return_status VARCHAR2(1)
368: -- x_msg_count NUMBER

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

361: --
362: -- Parameters :
363: -- IN : p_api_version NUMBER Require
364: -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)
365: -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)
366: -- p_validation_level NUMBER Optional (FND_API.G_VALID_LEVEL_FULL)
367: -- OUT : x_return_status VARCHAR2(1)
368: -- x_msg_count NUMBER
369: -- x_msg_data VARCHAR2(2000)

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

362: -- Parameters :
363: -- IN : p_api_version NUMBER Require
364: -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)
365: -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)
366: -- p_validation_level NUMBER Optional (FND_API.G_VALID_LEVEL_FULL)
367: -- OUT : x_return_status VARCHAR2(1)
368: -- x_msg_count NUMBER
369: -- x_msg_data VARCHAR2(2000)
370: --

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

376: -- End of comments
377:
378: PROCEDURE get_active_group
379: ( p_api_version IN NUMBER,
380: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
381: p_commit IN VARCHAR2 := FND_API.G_FALSE,
382: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
383: x_return_status OUT NOCOPY VARCHAR2,
384: x_msg_count OUT NOCOPY NUMBER,

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

377:
378: PROCEDURE get_active_group
379: ( p_api_version IN NUMBER,
380: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
381: p_commit IN VARCHAR2 := FND_API.G_FALSE,
382: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
383: x_return_status OUT NOCOPY VARCHAR2,
384: x_msg_count OUT NOCOPY NUMBER,
385: x_msg_data OUT NOCOPY VARCHAR2,

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

378: PROCEDURE get_active_group
379: ( p_api_version IN NUMBER,
380: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
381: p_commit IN VARCHAR2 := FND_API.G_FALSE,
382: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
383: x_return_status OUT NOCOPY VARCHAR2,
384: x_msg_count OUT NOCOPY NUMBER,
385: x_msg_data OUT NOCOPY VARCHAR2,
386: p_org_id IN NUMBER,

Line 409: IF NOT FND_API.Compatible_API_Call

405:
406: l_counter NUMBER(15) := 0;
407: BEGIN
408: -- Standard call to check for call compatibility.
409: IF NOT FND_API.Compatible_API_Call
410: (l_api_version ,
411: p_api_version ,
412: l_api_name ,
413: G_PKG_NAME )

Line 415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

411: p_api_version ,
412: l_api_name ,
413: G_PKG_NAME )
414: THEN
415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
416: END IF;
417:
418: -- Initialize message list if p_init_msg_list is set to TRUE.
419: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 419: IF FND_API.to_Boolean( p_init_msg_list ) THEN

415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
416: END IF;
417:
418: -- Initialize message list if p_init_msg_list is set to TRUE.
419: IF FND_API.to_Boolean( p_init_msg_list ) THEN
420: FND_MSG_PUB.initialize;
421: END IF;
422:
423: -- Initialize API return status to success

Line 424: x_return_status := FND_API.G_RET_STS_SUCCESS;

420: FND_MSG_PUB.initialize;
421: END IF;
422:
423: -- Initialize API return status to success
424: x_return_status := FND_API.G_RET_STS_SUCCESS;
425:
426: -- API body
427:
428: FOR eachgroup IN groups_csr LOOP

Line 445: WHEN FND_API.G_EXC_ERROR THEN

441: FND_MSG_PUB.Count_And_Get
442: (p_count => x_msg_count ,
443: p_data => x_msg_data );
444: EXCEPTION
445: WHEN FND_API.G_EXC_ERROR THEN
446: x_return_status := FND_API.G_RET_STS_ERROR ;
447: FND_MSG_PUB.Count_And_Get
448: (p_count => x_msg_count ,
449: p_data => x_msg_data );

Line 446: x_return_status := FND_API.G_RET_STS_ERROR ;

442: (p_count => x_msg_count ,
443: p_data => x_msg_data );
444: EXCEPTION
445: WHEN FND_API.G_EXC_ERROR THEN
446: x_return_status := FND_API.G_RET_STS_ERROR ;
447: FND_MSG_PUB.Count_And_Get
448: (p_count => x_msg_count ,
449: p_data => x_msg_data );
450: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 450: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

446: x_return_status := FND_API.G_RET_STS_ERROR ;
447: FND_MSG_PUB.Count_And_Get
448: (p_count => x_msg_count ,
449: p_data => x_msg_data );
450: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
451: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
452: FND_MSG_PUB.Count_And_Get
453: (p_count => x_msg_count ,
454: p_data => x_msg_data );

Line 451: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

447: FND_MSG_PUB.Count_And_Get
448: (p_count => x_msg_count ,
449: p_data => x_msg_data );
450: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
451: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
452: FND_MSG_PUB.Count_And_Get
453: (p_count => x_msg_count ,
454: p_data => x_msg_data );
455: WHEN OTHERS THEN

Line 456: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

452: FND_MSG_PUB.Count_And_Get
453: (p_count => x_msg_count ,
454: p_data => x_msg_data );
455: WHEN OTHERS THEN
456: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
457: IF FND_MSG_PUB.Check_Msg_Level
458: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
459: THEN
460: FND_MSG_PUB.Add_Exc_Msg

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

478: -- Pre-reqs : None
479: --
480: -- Parameters :
481: -- IN : p_api_version NUMBER Require
482: -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)
483: -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)
484: -- p_validation_level NUMBER Optional (FND_API.G_VALID_LEVEL_FULL)
485: -- OUT : x_return_status VARCHAR2(1)
486: -- x_msg_count NUMBER

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

479: --
480: -- Parameters :
481: -- IN : p_api_version NUMBER Require
482: -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)
483: -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)
484: -- p_validation_level NUMBER Optional (FND_API.G_VALID_LEVEL_FULL)
485: -- OUT : x_return_status VARCHAR2(1)
486: -- x_msg_count NUMBER
487: -- x_msg_data VARCHAR2(2000)

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

480: -- Parameters :
481: -- IN : p_api_version NUMBER Require
482: -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)
483: -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)
484: -- p_validation_level NUMBER Optional (FND_API.G_VALID_LEVEL_FULL)
485: -- OUT : x_return_status VARCHAR2(1)
486: -- x_msg_count NUMBER
487: -- x_msg_data VARCHAR2(2000)
488: --

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

494: -- End of comments
495:
496: PROCEDURE get_ancestor_group
497: ( p_api_version IN NUMBER,
498: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
499: p_commit IN VARCHAR2 := FND_API.G_FALSE,
500: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
501: x_return_status OUT NOCOPY VARCHAR2,
502: x_msg_count OUT NOCOPY NUMBER,

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

495:
496: PROCEDURE get_ancestor_group
497: ( p_api_version IN NUMBER,
498: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
499: p_commit IN VARCHAR2 := FND_API.G_FALSE,
500: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
501: x_return_status OUT NOCOPY VARCHAR2,
502: x_msg_count OUT NOCOPY NUMBER,
503: x_msg_data OUT NOCOPY VARCHAR2,

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

496: PROCEDURE get_ancestor_group
497: ( p_api_version IN NUMBER,
498: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
499: p_commit IN VARCHAR2 := FND_API.G_FALSE,
500: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
501: x_return_status OUT NOCOPY VARCHAR2,
502: x_msg_count OUT NOCOPY NUMBER,
503: x_msg_data OUT NOCOPY VARCHAR2,
504: p_group IN group_rec_type,

Line 524: IF NOT FND_API.Compatible_API_Call

520: AND (end_date_active IS NULL OR p_group.start_date <= end_date_active)
521: AND (p_group.end_date IS NULL OR p_group.end_date >= start_date_active);
522: BEGIN
523: -- Standard call to check for call compatibility.
524: IF NOT FND_API.Compatible_API_Call
525: (l_api_version ,
526: p_api_version ,
527: l_api_name ,
528: G_PKG_NAME )

Line 530: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

526: p_api_version ,
527: l_api_name ,
528: G_PKG_NAME )
529: THEN
530: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
531: END IF;
532:
533: -- Initialize message list if p_init_msg_list is set to TRUE.
534: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 534: IF FND_API.to_Boolean( p_init_msg_list ) THEN

530: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
531: END IF;
532:
533: -- Initialize message list if p_init_msg_list is set to TRUE.
534: IF FND_API.to_Boolean( p_init_msg_list ) THEN
535: FND_MSG_PUB.initialize;
536: END IF;
537:
538: -- Initialize API return status to success

Line 539: x_return_status := FND_API.G_RET_STS_SUCCESS;

535: FND_MSG_PUB.initialize;
536: END IF;
537:
538: -- Initialize API return status to success
539: x_return_status := FND_API.G_RET_STS_SUCCESS;
540:
541: -- API body
542:
543: FOR eachgroup IN groups_csr LOOP

Line 559: WHEN FND_API.G_EXC_ERROR THEN

555: FND_MSG_PUB.Count_And_Get
556: (p_count => x_msg_count ,
557: p_data => x_msg_data );
558: EXCEPTION
559: WHEN FND_API.G_EXC_ERROR THEN
560: x_return_status := FND_API.G_RET_STS_ERROR ;
561: FND_MSG_PUB.Count_And_Get
562: (p_count => x_msg_count ,
563: p_data => x_msg_data );

Line 560: x_return_status := FND_API.G_RET_STS_ERROR ;

556: (p_count => x_msg_count ,
557: p_data => x_msg_data );
558: EXCEPTION
559: WHEN FND_API.G_EXC_ERROR THEN
560: x_return_status := FND_API.G_RET_STS_ERROR ;
561: FND_MSG_PUB.Count_And_Get
562: (p_count => x_msg_count ,
563: p_data => x_msg_data );
564: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 564: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

560: x_return_status := FND_API.G_RET_STS_ERROR ;
561: FND_MSG_PUB.Count_And_Get
562: (p_count => x_msg_count ,
563: p_data => x_msg_data );
564: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
566: FND_MSG_PUB.Count_And_Get
567: (p_count => x_msg_count ,
568: p_data => x_msg_data );

Line 565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

561: FND_MSG_PUB.Count_And_Get
562: (p_count => x_msg_count ,
563: p_data => x_msg_data );
564: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
566: FND_MSG_PUB.Count_And_Get
567: (p_count => x_msg_count ,
568: p_data => x_msg_data );
569: WHEN OTHERS THEN

Line 570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

566: FND_MSG_PUB.Count_And_Get
567: (p_count => x_msg_count ,
568: p_data => x_msg_data );
569: WHEN OTHERS THEN
570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
571: IF FND_MSG_PUB.Check_Msg_Level
572: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
573: THEN
574: FND_MSG_PUB.Add_Exc_Msg

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

592: -- Pre-reqs : None
593: --
594: -- Parameters :
595: -- IN : p_api_version NUMBER Require
596: -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)
597: -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)
598: -- p_validation_level NUMBER Optional (FND_API.G_VALID_LEVEL_FULL)
599: -- OUT : x_return_status VARCHAR2(1)
600: -- x_msg_count NUMBER

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

593: --
594: -- Parameters :
595: -- IN : p_api_version NUMBER Require
596: -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)
597: -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)
598: -- p_validation_level NUMBER Optional (FND_API.G_VALID_LEVEL_FULL)
599: -- OUT : x_return_status VARCHAR2(1)
600: -- x_msg_count NUMBER
601: -- x_msg_data VARCHAR2(2000)

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

594: -- Parameters :
595: -- IN : p_api_version NUMBER Require
596: -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)
597: -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)
598: -- p_validation_level NUMBER Optional (FND_API.G_VALID_LEVEL_FULL)
599: -- OUT : x_return_status VARCHAR2(1)
600: -- x_msg_count NUMBER
601: -- x_msg_data VARCHAR2(2000)
602: -- Version : Current version 1.0

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

607: -- End of comments
608:
609: PROCEDURE get_descendant_group
610: ( p_api_version IN NUMBER,
611: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
612: p_commit IN VARCHAR2 := FND_API.G_FALSE,
613: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
614: x_return_status OUT NOCOPY VARCHAR2,
615: x_msg_count OUT NOCOPY NUMBER,

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

608:
609: PROCEDURE get_descendant_group
610: ( p_api_version IN NUMBER,
611: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
612: p_commit IN VARCHAR2 := FND_API.G_FALSE,
613: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
614: x_return_status OUT NOCOPY VARCHAR2,
615: x_msg_count OUT NOCOPY NUMBER,
616: x_msg_data OUT NOCOPY VARCHAR2,

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

609: PROCEDURE get_descendant_group
610: ( p_api_version IN NUMBER,
611: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
612: p_commit IN VARCHAR2 := FND_API.G_FALSE,
613: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
614: x_return_status OUT NOCOPY VARCHAR2,
615: x_msg_count OUT NOCOPY NUMBER,
616: x_msg_data OUT NOCOPY VARCHAR2,
617: p_group IN group_rec_type,

Line 637: IF NOT FND_API.Compatible_API_Call

633: AND (end_date_active IS NULL OR p_group.start_date <= end_date_active)
634: AND (p_group.end_date IS NULL OR p_group.end_date >= start_date_active);
635: BEGIN
636: -- Standard call to check for call compatibility.
637: IF NOT FND_API.Compatible_API_Call
638: (l_api_version ,
639: p_api_version ,
640: l_api_name ,
641: G_PKG_NAME )

Line 643: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

639: p_api_version ,
640: l_api_name ,
641: G_PKG_NAME )
642: THEN
643: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
644: END IF;
645:
646: -- Initialize message list if p_init_msg_list is set to TRUE.
647: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 647: IF FND_API.to_Boolean( p_init_msg_list ) THEN

643: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
644: END IF;
645:
646: -- Initialize message list if p_init_msg_list is set to TRUE.
647: IF FND_API.to_Boolean( p_init_msg_list ) THEN
648: FND_MSG_PUB.initialize;
649: END IF;
650:
651: -- Initialize API return status to success

Line 652: x_return_status := FND_API.G_RET_STS_SUCCESS;

648: FND_MSG_PUB.initialize;
649: END IF;
650:
651: -- Initialize API return status to success
652: x_return_status := FND_API.G_RET_STS_SUCCESS;
653:
654: -- API body
655:
656: FOR eachgroup IN groups_csr LOOP

Line 672: WHEN FND_API.G_EXC_ERROR THEN

668: FND_MSG_PUB.Count_And_Get
669: (p_count => x_msg_count ,
670: p_data => x_msg_data );
671: EXCEPTION
672: WHEN FND_API.G_EXC_ERROR THEN
673: x_return_status := FND_API.G_RET_STS_ERROR ;
674: FND_MSG_PUB.Count_And_Get
675: (p_count => x_msg_count ,
676: p_data => x_msg_data );

Line 673: x_return_status := FND_API.G_RET_STS_ERROR ;

669: (p_count => x_msg_count ,
670: p_data => x_msg_data );
671: EXCEPTION
672: WHEN FND_API.G_EXC_ERROR THEN
673: x_return_status := FND_API.G_RET_STS_ERROR ;
674: FND_MSG_PUB.Count_And_Get
675: (p_count => x_msg_count ,
676: p_data => x_msg_data );
677: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 677: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

673: x_return_status := FND_API.G_RET_STS_ERROR ;
674: FND_MSG_PUB.Count_And_Get
675: (p_count => x_msg_count ,
676: p_data => x_msg_data );
677: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
679: FND_MSG_PUB.Count_And_Get
680: (p_count => x_msg_count ,
681: p_data => x_msg_data );

Line 678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

674: FND_MSG_PUB.Count_And_Get
675: (p_count => x_msg_count ,
676: p_data => x_msg_data );
677: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
679: FND_MSG_PUB.Count_And_Get
680: (p_count => x_msg_count ,
681: p_data => x_msg_data );
682: WHEN OTHERS THEN

Line 683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

679: FND_MSG_PUB.Count_And_Get
680: (p_count => x_msg_count ,
681: p_data => x_msg_data );
682: WHEN OTHERS THEN
683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
684: IF FND_MSG_PUB.Check_Msg_Level
685: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
686: THEN
687: FND_MSG_PUB.Add_Exc_Msg

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

705: -- Pre-reqs : None
706: --
707: -- Parameters :
708: -- IN : p_api_version NUMBER Require
709: -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)
710: -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)
711: -- p_validation_level NUMBER Optional (FND_API.G_VALID_LEVEL_FULL)
712: -- OUT : x_return_status VARCHAR2(1)
713: -- x_msg_count NUMBER

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

706: --
707: -- Parameters :
708: -- IN : p_api_version NUMBER Require
709: -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)
710: -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)
711: -- p_validation_level NUMBER Optional (FND_API.G_VALID_LEVEL_FULL)
712: -- OUT : x_return_status VARCHAR2(1)
713: -- x_msg_count NUMBER
714: -- x_msg_data VARCHAR2(2000)

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

707: -- Parameters :
708: -- IN : p_api_version NUMBER Require
709: -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)
710: -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)
711: -- p_validation_level NUMBER Optional (FND_API.G_VALID_LEVEL_FULL)
712: -- OUT : x_return_status VARCHAR2(1)
713: -- x_msg_count NUMBER
714: -- x_msg_data VARCHAR2(2000)
715: --

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

721: -- End of comments
722:
723: PROCEDURE get_ancestor_salesrep
724: ( p_api_version IN NUMBER,
725: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
726: p_commit IN VARCHAR2 := FND_API.G_FALSE,
727: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
728: x_return_status OUT NOCOPY VARCHAR2,
729: x_msg_count OUT NOCOPY NUMBER,

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

722:
723: PROCEDURE get_ancestor_salesrep
724: ( p_api_version IN NUMBER,
725: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
726: p_commit IN VARCHAR2 := FND_API.G_FALSE,
727: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
728: x_return_status OUT NOCOPY VARCHAR2,
729: x_msg_count OUT NOCOPY NUMBER,
730: x_msg_data OUT NOCOPY VARCHAR2,

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

723: PROCEDURE get_ancestor_salesrep
724: ( p_api_version IN NUMBER,
725: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
726: p_commit IN VARCHAR2 := FND_API.G_FALSE,
727: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
728: x_return_status OUT NOCOPY VARCHAR2,
729: x_msg_count OUT NOCOPY NUMBER,
730: x_msg_data OUT NOCOPY VARCHAR2,
731: p_org_id IN NUMBER,

Line 804: IF NOT FND_API.Compatible_API_Call

800: AND (end_date_active IS NULL OR p_start_date <= end_date_active)
801: AND (p_end_date IS NULL OR p_end_date >= start_date_active);
802: BEGIN
803: -- Standard call to check for call compatibility.
804: IF NOT FND_API.Compatible_API_Call
805: (l_api_version ,
806: p_api_version ,
807: l_api_name ,
808: G_PKG_NAME )

Line 810: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

806: p_api_version ,
807: l_api_name ,
808: G_PKG_NAME )
809: THEN
810: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
811: END IF;
812:
813: -- Initialize message list if p_init_msg_list is set to TRUE.
814: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 814: IF FND_API.to_Boolean( p_init_msg_list ) THEN

810: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
811: END IF;
812:
813: -- Initialize message list if p_init_msg_list is set to TRUE.
814: IF FND_API.to_Boolean( p_init_msg_list ) THEN
815: FND_MSG_PUB.initialize;
816: END IF;
817:
818: -- Initialize API return status to success

Line 819: x_return_status := FND_API.G_RET_STS_SUCCESS;

815: FND_MSG_PUB.initialize;
816: END IF;
817:
818: -- Initialize API return status to success
819: x_return_status := FND_API.G_RET_STS_SUCCESS;
820:
821: -- API body
822:
823: l_counter := 0;

Line 849: IF x_return_status = FND_API.g_ret_sts_error THEN

845: x_msg_data => x_msg_data,
846: p_group => l_group,
847: x_group => l_ancestor_group);
848:
849: IF x_return_status = FND_API.g_ret_sts_error THEN
850: RAISE FND_API.g_exc_error;
851: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
852: RAISE FND_API.g_exc_unexpected_error;
853: END IF;

Line 850: RAISE FND_API.g_exc_error;

846: p_group => l_group,
847: x_group => l_ancestor_group);
848:
849: IF x_return_status = FND_API.g_ret_sts_error THEN
850: RAISE FND_API.g_exc_error;
851: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
852: RAISE FND_API.g_exc_unexpected_error;
853: END IF;
854:

Line 851: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

847: x_group => l_ancestor_group);
848:
849: IF x_return_status = FND_API.g_ret_sts_error THEN
850: RAISE FND_API.g_exc_error;
851: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
852: RAISE FND_API.g_exc_unexpected_error;
853: END IF;
854:
855: IF( l_ancestor_group.COUNT > 0) THEN

Line 852: RAISE FND_API.g_exc_unexpected_error;

848:
849: IF x_return_status = FND_API.g_ret_sts_error THEN
850: RAISE FND_API.g_exc_error;
851: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
852: RAISE FND_API.g_exc_unexpected_error;
853: END IF;
854:
855: IF( l_ancestor_group.COUNT > 0) THEN
856: FOR eachgroup IN l_ancestor_group.first .. l_ancestor_group.last LOOP

Line 877: WHEN FND_API.G_EXC_ERROR THEN

873: FND_MSG_PUB.Count_And_Get
874: (p_count => x_msg_count ,
875: p_data => x_msg_data );
876: EXCEPTION
877: WHEN FND_API.G_EXC_ERROR THEN
878: x_return_status := FND_API.G_RET_STS_ERROR ;
879: FND_MSG_PUB.Count_And_Get
880: (p_count => x_msg_count ,
881: p_data => x_msg_data );

Line 878: x_return_status := FND_API.G_RET_STS_ERROR ;

874: (p_count => x_msg_count ,
875: p_data => x_msg_data );
876: EXCEPTION
877: WHEN FND_API.G_EXC_ERROR THEN
878: x_return_status := FND_API.G_RET_STS_ERROR ;
879: FND_MSG_PUB.Count_And_Get
880: (p_count => x_msg_count ,
881: p_data => x_msg_data );
882: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 882: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

878: x_return_status := FND_API.G_RET_STS_ERROR ;
879: FND_MSG_PUB.Count_And_Get
880: (p_count => x_msg_count ,
881: p_data => x_msg_data );
882: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
883: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
884: FND_MSG_PUB.Count_And_Get
885: (p_count => x_msg_count ,
886: p_data => x_msg_data );

Line 883: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

879: FND_MSG_PUB.Count_And_Get
880: (p_count => x_msg_count ,
881: p_data => x_msg_data );
882: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
883: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
884: FND_MSG_PUB.Count_And_Get
885: (p_count => x_msg_count ,
886: p_data => x_msg_data );
887: WHEN OTHERS THEN

Line 888: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

884: FND_MSG_PUB.Count_And_Get
885: (p_count => x_msg_count ,
886: p_data => x_msg_data );
887: WHEN OTHERS THEN
888: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
889: IF FND_MSG_PUB.Check_Msg_Level
890: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
891: THEN
892: FND_MSG_PUB.Add_Exc_Msg

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

910: -- Pre-reqs : None
911: --
912: -- Parameters :
913: -- IN : p_api_version NUMBER Require
914: -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)
915: -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)
916: -- p_validation_level NUMBER Optional (FND_API.G_VALID_LEVEL_FULL)
917: -- OUT : x_return_status VARCHAR2(1)
918: -- x_msg_count NUMBER

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

911: --
912: -- Parameters :
913: -- IN : p_api_version NUMBER Require
914: -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)
915: -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)
916: -- p_validation_level NUMBER Optional (FND_API.G_VALID_LEVEL_FULL)
917: -- OUT : x_return_status VARCHAR2(1)
918: -- x_msg_count NUMBER
919: -- x_msg_data VARCHAR2(2000)

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

912: -- Parameters :
913: -- IN : p_api_version NUMBER Require
914: -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)
915: -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)
916: -- p_validation_level NUMBER Optional (FND_API.G_VALID_LEVEL_FULL)
917: -- OUT : x_return_status VARCHAR2(1)
918: -- x_msg_count NUMBER
919: -- x_msg_data VARCHAR2(2000)
920: --

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

926: -- End of comments
927:
928: PROCEDURE get_descendant_salesrep
929: ( p_api_version IN NUMBER,
930: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
931: p_commit IN VARCHAR2 := FND_API.G_FALSE,
932: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
933: x_return_status OUT NOCOPY VARCHAR2,
934: x_msg_count OUT NOCOPY NUMBER,

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

927:
928: PROCEDURE get_descendant_salesrep
929: ( p_api_version IN NUMBER,
930: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
931: p_commit IN VARCHAR2 := FND_API.G_FALSE,
932: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
933: x_return_status OUT NOCOPY VARCHAR2,
934: x_msg_count OUT NOCOPY NUMBER,
935: x_msg_data OUT NOCOPY VARCHAR2,

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

928: PROCEDURE get_descendant_salesrep
929: ( p_api_version IN NUMBER,
930: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
931: p_commit IN VARCHAR2 := FND_API.G_FALSE,
932: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
933: x_return_status OUT NOCOPY VARCHAR2,
934: x_msg_count OUT NOCOPY NUMBER,
935: x_msg_data OUT NOCOPY VARCHAR2,
936: p_org_id IN NUMBER,

Line 969: IF NOT FND_API.Compatible_API_Call

965: AND (p_srp.end_date IS NULL OR start_date_active <= p_srp.end_date)
966: AND (end_date_active IS NULL OR end_date_active >= p_srp.start_date);
967: BEGIN
968: -- Standard call to check for call compatibility.
969: IF NOT FND_API.Compatible_API_Call
970: (l_api_version ,
971: p_api_version ,
972: l_api_name ,
973: G_PKG_NAME )

Line 975: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

971: p_api_version ,
972: l_api_name ,
973: G_PKG_NAME )
974: THEN
975: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
976: END IF;
977:
978: -- Initialize message list if p_init_msg_list is set to TRUE.
979: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 979: IF FND_API.to_Boolean( p_init_msg_list ) THEN

975: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
976: END IF;
977:
978: -- Initialize message list if p_init_msg_list is set to TRUE.
979: IF FND_API.to_Boolean( p_init_msg_list ) THEN
980: FND_MSG_PUB.initialize;
981: END IF;
982:
983: -- Initialize API return status to success

Line 984: x_return_status := FND_API.G_RET_STS_SUCCESS;

980: FND_MSG_PUB.initialize;
981: END IF;
982:
983: -- Initialize API return status to success
984: x_return_status := FND_API.G_RET_STS_SUCCESS;
985: -- API body
986:
987: -- if p_srp.salesrep_id is a manager, get the other members of his own group
988: OPEN mgr_check;

Line 1019: IF x_return_status = FND_API.g_ret_sts_error THEN

1015: x_msg_data => x_msg_data,
1016: p_group => l_group,
1017: x_group => l_descendant_group);
1018:
1019: IF x_return_status = FND_API.g_ret_sts_error THEN
1020: RAISE FND_API.g_exc_error;
1021: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1022: RAISE FND_API.g_exc_unexpected_error;
1023: END IF;

Line 1020: RAISE FND_API.g_exc_error;

1016: p_group => l_group,
1017: x_group => l_descendant_group);
1018:
1019: IF x_return_status = FND_API.g_ret_sts_error THEN
1020: RAISE FND_API.g_exc_error;
1021: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1022: RAISE FND_API.g_exc_unexpected_error;
1023: END IF;
1024:

Line 1021: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

1017: x_group => l_descendant_group);
1018:
1019: IF x_return_status = FND_API.g_ret_sts_error THEN
1020: RAISE FND_API.g_exc_error;
1021: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1022: RAISE FND_API.g_exc_unexpected_error;
1023: END IF;
1024:
1025: IF (l_descendant_group.COUNT > 0) THEN

Line 1022: RAISE FND_API.g_exc_unexpected_error;

1018:
1019: IF x_return_status = FND_API.g_ret_sts_error THEN
1020: RAISE FND_API.g_exc_error;
1021: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1022: RAISE FND_API.g_exc_unexpected_error;
1023: END IF;
1024:
1025: IF (l_descendant_group.COUNT > 0) THEN
1026: FOR eachgroup IN l_descendant_group.first .. l_descendant_group.last LOOP

Line 1046: WHEN FND_API.G_EXC_ERROR THEN

1042: FND_MSG_PUB.Count_And_Get
1043: (p_count => x_msg_count ,
1044: p_data => x_msg_data );
1045: EXCEPTION
1046: WHEN FND_API.G_EXC_ERROR THEN
1047: x_return_status := FND_API.G_RET_STS_ERROR ;
1048: FND_MSG_PUB.Count_And_Get
1049: (p_count => x_msg_count ,
1050: p_data => x_msg_data );

Line 1047: x_return_status := FND_API.G_RET_STS_ERROR ;

1043: (p_count => x_msg_count ,
1044: p_data => x_msg_data );
1045: EXCEPTION
1046: WHEN FND_API.G_EXC_ERROR THEN
1047: x_return_status := FND_API.G_RET_STS_ERROR ;
1048: FND_MSG_PUB.Count_And_Get
1049: (p_count => x_msg_count ,
1050: p_data => x_msg_data );
1051: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1051: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1047: x_return_status := FND_API.G_RET_STS_ERROR ;
1048: FND_MSG_PUB.Count_And_Get
1049: (p_count => x_msg_count ,
1050: p_data => x_msg_data );
1051: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1053: FND_MSG_PUB.Count_And_Get
1054: (p_count => x_msg_count ,
1055: p_data => x_msg_data );

Line 1052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1048: FND_MSG_PUB.Count_And_Get
1049: (p_count => x_msg_count ,
1050: p_data => x_msg_data );
1051: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1053: FND_MSG_PUB.Count_And_Get
1054: (p_count => x_msg_count ,
1055: p_data => x_msg_data );
1056: WHEN OTHERS THEN

Line 1057: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1053: FND_MSG_PUB.Count_And_Get
1054: (p_count => x_msg_count ,
1055: p_data => x_msg_data );
1056: WHEN OTHERS THEN
1057: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1058: IF FND_MSG_PUB.Check_Msg_Level
1059: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1060: THEN
1061: FND_MSG_PUB.Add_Exc_Msg

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

1079: -- Pre-reqs : None
1080: --
1081: -- Parameters :
1082: -- IN : p_api_version NUMBER Require
1083: -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)
1084: -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)
1085: -- p_validation_level NUMBER Optional (FND_API.G_VALID_LEVEL_FULL)
1086: -- OUT : x_return_status VARCHAR2(1)
1087: -- x_msg_count NUMBER

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

1080: --
1081: -- Parameters :
1082: -- IN : p_api_version NUMBER Require
1083: -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)
1084: -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)
1085: -- p_validation_level NUMBER Optional (FND_API.G_VALID_LEVEL_FULL)
1086: -- OUT : x_return_status VARCHAR2(1)
1087: -- x_msg_count NUMBER
1088: -- x_msg_data VARCHAR2(2000)

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

1081: -- Parameters :
1082: -- IN : p_api_version NUMBER Require
1083: -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)
1084: -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)
1085: -- p_validation_level NUMBER Optional (FND_API.G_VALID_LEVEL_FULL)
1086: -- OUT : x_return_status VARCHAR2(1)
1087: -- x_msg_count NUMBER
1088: -- x_msg_data VARCHAR2(2000)
1089: --

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

1095: -- End of comments
1096:
1097: PROCEDURE get_descendant_salesrep
1098: ( p_api_version IN NUMBER,
1099: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1100: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1101: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
1102: x_return_status OUT NOCOPY VARCHAR2,
1103: x_msg_count OUT NOCOPY NUMBER,

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

1096:
1097: PROCEDURE get_descendant_salesrep
1098: ( p_api_version IN NUMBER,
1099: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1100: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1101: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
1102: x_return_status OUT NOCOPY VARCHAR2,
1103: x_msg_count OUT NOCOPY NUMBER,
1104: x_msg_data OUT NOCOPY VARCHAR2,

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

1097: PROCEDURE get_descendant_salesrep
1098: ( p_api_version IN NUMBER,
1099: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1100: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1101: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
1102: x_return_status OUT NOCOPY VARCHAR2,
1103: x_msg_count OUT NOCOPY NUMBER,
1104: x_msg_data OUT NOCOPY VARCHAR2,
1105: p_org_id IN NUMBER,

Line 1145: IF NOT FND_API.Compatible_API_Call

1141: AND (p_srp.end_date IS NULL OR srp.start_date_active <= p_srp.end_date)
1142: AND (srp.end_date_active IS NULL OR srp.end_date_active >= p_srp.start_date);
1143: BEGIN
1144: -- Standard call to check for call compatibility.
1145: IF NOT FND_API.Compatible_API_Call
1146: (l_api_version ,
1147: p_api_version ,
1148: l_api_name ,
1149: G_PKG_NAME )

Line 1151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1147: p_api_version ,
1148: l_api_name ,
1149: G_PKG_NAME )
1150: THEN
1151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1152: END IF;
1153:
1154: -- Initialize message list if p_init_msg_list is set to TRUE.
1155: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1155: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1152: END IF;
1153:
1154: -- Initialize message list if p_init_msg_list is set to TRUE.
1155: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1156: FND_MSG_PUB.initialize;
1157: END IF;
1158:
1159: -- Initialize API return status to success

Line 1160: x_return_status := FND_API.G_RET_STS_SUCCESS;

1156: FND_MSG_PUB.initialize;
1157: END IF;
1158:
1159: -- Initialize API return status to success
1160: x_return_status := FND_API.G_RET_STS_SUCCESS;
1161: -- API body
1162:
1163: l_counter := 0;
1164:

Line 1197: WHEN FND_API.G_EXC_ERROR THEN

1193: FND_MSG_PUB.Count_And_Get
1194: (p_count => x_msg_count ,
1195: p_data => x_msg_data );
1196: EXCEPTION
1197: WHEN FND_API.G_EXC_ERROR THEN
1198: x_return_status := FND_API.G_RET_STS_ERROR ;
1199: FND_MSG_PUB.Count_And_Get
1200: (p_count => x_msg_count ,
1201: p_data => x_msg_data );

Line 1198: x_return_status := FND_API.G_RET_STS_ERROR ;

1194: (p_count => x_msg_count ,
1195: p_data => x_msg_data );
1196: EXCEPTION
1197: WHEN FND_API.G_EXC_ERROR THEN
1198: x_return_status := FND_API.G_RET_STS_ERROR ;
1199: FND_MSG_PUB.Count_And_Get
1200: (p_count => x_msg_count ,
1201: p_data => x_msg_data );
1202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1198: x_return_status := FND_API.G_RET_STS_ERROR ;
1199: FND_MSG_PUB.Count_And_Get
1200: (p_count => x_msg_count ,
1201: p_data => x_msg_data );
1202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1204: FND_MSG_PUB.Count_And_Get
1205: (p_count => x_msg_count ,
1206: p_data => x_msg_data );

Line 1203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1199: FND_MSG_PUB.Count_And_Get
1200: (p_count => x_msg_count ,
1201: p_data => x_msg_data );
1202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1204: FND_MSG_PUB.Count_And_Get
1205: (p_count => x_msg_count ,
1206: p_data => x_msg_data );
1207: WHEN OTHERS THEN

Line 1208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1204: FND_MSG_PUB.Count_And_Get
1205: (p_count => x_msg_count ,
1206: p_data => x_msg_data );
1207: WHEN OTHERS THEN
1208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1209: IF FND_MSG_PUB.Check_Msg_Level
1210: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1211: THEN
1212: FND_MSG_PUB.Add_Exc_Msg