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

Line 16: -- p_init_msg_list (optional, default FND_API.G_FALSE)

12: --
13: -- Input Parameters
14: -- p_api_version
15: -- API version number (current version is 1.0)
16: -- p_init_msg_list (optional, default FND_API.G_FALSE)
17: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
18: -- if set to FND_API.G_TRUE
19: -- initialize error message list
20: -- if set to FND_API.G_FALSE - not initialize error

Line 17: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.

13: -- Input Parameters
14: -- p_api_version
15: -- API version number (current version is 1.0)
16: -- p_init_msg_list (optional, default FND_API.G_FALSE)
17: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
18: -- if set to FND_API.G_TRUE
19: -- initialize error message list
20: -- if set to FND_API.G_FALSE - not initialize error
21: -- message list

Line 18: -- if set to FND_API.G_TRUE

14: -- p_api_version
15: -- API version number (current version is 1.0)
16: -- p_init_msg_list (optional, default FND_API.G_FALSE)
17: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
18: -- if set to FND_API.G_TRUE
19: -- initialize error message list
20: -- if set to FND_API.G_FALSE - not initialize error
21: -- message list
22: -- p_commit (optional, default FND_API.G_FALSE)

Line 20: -- if set to FND_API.G_FALSE - not initialize error

16: -- p_init_msg_list (optional, default FND_API.G_FALSE)
17: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
18: -- if set to FND_API.G_TRUE
19: -- initialize error message list
20: -- if set to FND_API.G_FALSE - not initialize error
21: -- message list
22: -- p_commit (optional, default FND_API.G_FALSE)
23: -- whether or not to commit the changes to database
24: --

Line 22: -- p_commit (optional, default FND_API.G_FALSE)

18: -- if set to FND_API.G_TRUE
19: -- initialize error message list
20: -- if set to FND_API.G_FALSE - not initialize error
21: -- message list
22: -- p_commit (optional, default FND_API.G_FALSE)
23: -- whether or not to commit the changes to database
24: --
25: -- Input parameters for clear cross users informations
26: -- p_VENDOR_ID -- Vendor Id

Line 37: -- fnd_api.g_ret_sts_success;

33: --
34: -- Output Parameters
35: -- x_return_status
36: -- if the process succeeds, the value is
37: -- fnd_api.g_ret_sts_success;
38: -- if there is an expected error, the value is
39: -- fnd_api.g_ret_sts_error;
40: -- if there is an unexpected error, the value is
41: -- fnd_api.g_ret_sts_unexp_error;

Line 39: -- fnd_api.g_ret_sts_error;

35: -- x_return_status
36: -- if the process succeeds, the value is
37: -- fnd_api.g_ret_sts_success;
38: -- if there is an expected error, the value is
39: -- fnd_api.g_ret_sts_error;
40: -- if there is an unexpected error, the value is
41: -- fnd_api.g_ret_sts_unexp_error;
42: -- x_msg_count
43: -- if there is one or more errors, the number of error messages

Line 41: -- fnd_api.g_ret_sts_unexp_error;

37: -- fnd_api.g_ret_sts_success;
38: -- if there is an expected error, the value is
39: -- fnd_api.g_ret_sts_error;
40: -- if there is an unexpected error, the value is
41: -- fnd_api.g_ret_sts_unexp_error;
42: -- x_msg_count
43: -- if there is one or more errors, the number of error messages
44: -- in the buffer
45: -- x_msg_data

Line 47: -- (See fnd_api package for more details about the above output parameters)

43: -- if there is one or more errors, the number of error messages
44: -- in the buffer
45: -- x_msg_data
46: -- if there is one and only one error, the error message
47: -- (See fnd_api package for more details about the above output parameters)
48: -- p_ITM_USER_SEQUENCE_ID - ITM sequence Id ( PK)
49: --*/
50:
51: PROCEDURE Insert_Row

Line 54: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,

50:
51: PROCEDURE Insert_Row
52: (
53: p_api_version IN NUMBER ,
54: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
55: p_commit IN VARCHAR2 := fnd_api.g_false ,
56: x_return_status OUT NOCOPY VARCHAR2 ,
57: x_msg_count OUT NOCOPY NUMBER ,
58: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 55: p_commit IN VARCHAR2 := fnd_api.g_false ,

51: PROCEDURE Insert_Row
52: (
53: p_api_version IN NUMBER ,
54: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
55: p_commit IN VARCHAR2 := fnd_api.g_false ,
56: x_return_status OUT NOCOPY VARCHAR2 ,
57: x_msg_count OUT NOCOPY NUMBER ,
58: x_msg_data OUT NOCOPY VARCHAR2 ,
59: p_VENDOR_ID IN NUMBER,

Line 77: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

73: --dbms_output.put_line('begin api');
74: -- Standard Start of API savepoint
75: SAVEPOINT WSH_ITM_USERS_PKG;
76: -- Standard call to check for call compatibility.
77: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
78: p_api_version ,
79: l_api_name ,
80: G_PKG_NAME )
81: THEN

Line 84: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

80: G_PKG_NAME )
81: THEN
82: FND_MESSAGE.SET_NAME('WSH', 'WSH_INCOMPATIBLE_API_CALL');
83: FND_MSG_PUB.ADD;
84: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
85: END IF;
86: -- Initialize message list if p_init_msg_list is set to TRUE.
87: IF FND_API.to_Boolean( p_init_msg_list ) THEN
88: FND_MSG_PUB.initialize;

Line 87: IF FND_API.to_Boolean( p_init_msg_list ) THEN

83: FND_MSG_PUB.ADD;
84: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
85: END IF;
86: -- Initialize message list if p_init_msg_list is set to TRUE.
87: IF FND_API.to_Boolean( p_init_msg_list ) THEN
88: FND_MSG_PUB.initialize;
89: END IF;
90: -- Initialize API return status to success
91: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 91: x_return_status := FND_API.G_RET_STS_SUCCESS;

87: IF FND_API.to_Boolean( p_init_msg_list ) THEN
88: FND_MSG_PUB.initialize;
89: END IF;
90: -- Initialize API return status to success
91: x_return_status := FND_API.G_RET_STS_SUCCESS;
92: --dbms_output.put_line('begin api-2');
93:
94: select wsh_itm_user_setups_s.nextval into l_ITM_USER_SEQUENCE_ID from dual;
95: /* Validate input parameters if any */

Line 131: x_return_status := FND_API.G_RET_STS_ERROR;

127: ) ;
128: IF SQL%NOTFOUND THEN
129: FND_MESSAGE.SET_NAME('WSH', 'WSH_INSERT_FAILED');
130: FND_MSG_PUB.ADD;
131: x_return_status := FND_API.G_RET_STS_ERROR;
132: RAISE FND_API.G_EXC_ERROR ;
133: END IF;
134: --dbms_output.put_line('Seq Id got it '||l_ITM_USER_SEQUENCE_ID||'success');
135: x_return_status := fnd_api.g_ret_sts_success;

Line 132: RAISE FND_API.G_EXC_ERROR ;

128: IF SQL%NOTFOUND THEN
129: FND_MESSAGE.SET_NAME('WSH', 'WSH_INSERT_FAILED');
130: FND_MSG_PUB.ADD;
131: x_return_status := FND_API.G_RET_STS_ERROR;
132: RAISE FND_API.G_EXC_ERROR ;
133: END IF;
134: --dbms_output.put_line('Seq Id got it '||l_ITM_USER_SEQUENCE_ID||'success');
135: x_return_status := fnd_api.g_ret_sts_success;
136: p_ITM_USER_SEQUENCE_ID := l_ITM_USER_SEQUENCE_ID;

Line 135: x_return_status := fnd_api.g_ret_sts_success;

131: x_return_status := FND_API.G_RET_STS_ERROR;
132: RAISE FND_API.G_EXC_ERROR ;
133: END IF;
134: --dbms_output.put_line('Seq Id got it '||l_ITM_USER_SEQUENCE_ID||'success');
135: x_return_status := fnd_api.g_ret_sts_success;
136: p_ITM_USER_SEQUENCE_ID := l_ITM_USER_SEQUENCE_ID;
137: -- End of API body
138: -- Standard check of p_commit.
139: IF FND_API.To_Boolean( p_commit ) THEN

Line 139: IF FND_API.To_Boolean( p_commit ) THEN

135: x_return_status := fnd_api.g_ret_sts_success;
136: p_ITM_USER_SEQUENCE_ID := l_ITM_USER_SEQUENCE_ID;
137: -- End of API body
138: -- Standard check of p_commit.
139: IF FND_API.To_Boolean( p_commit ) THEN
140: COMMIT WORK;
141: END IF;
142: -- Standard call to get message count and if count is 1,
143: -- get message info.

Line 150: WHEN FND_API.G_EXC_ERROR THEN

146: p_data => x_msg_data
147: );
148:
149: EXCEPTION
150: WHEN FND_API.G_EXC_ERROR THEN
151: ROLLBACK TO WSH_ITM_USERS_PKG;
152: x_return_status := FND_API.G_RET_STS_ERROR;
153: FND_MSG_PUB.Count_And_Get
154: ( p_count => x_msg_count,

Line 152: x_return_status := FND_API.G_RET_STS_ERROR;

148:
149: EXCEPTION
150: WHEN FND_API.G_EXC_ERROR THEN
151: ROLLBACK TO WSH_ITM_USERS_PKG;
152: x_return_status := FND_API.G_RET_STS_ERROR;
153: FND_MSG_PUB.Count_And_Get
154: ( p_count => x_msg_count,
155: p_data => x_msg_data
156: );

Line 157: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

153: FND_MSG_PUB.Count_And_Get
154: ( p_count => x_msg_count,
155: p_data => x_msg_data
156: );
157: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
158: ROLLBACK TO WSH_ITM_USERS_PKG;
159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
160: FND_MSG_PUB.Count_And_Get
161: ( p_count => x_msg_count,

Line 159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

155: p_data => x_msg_data
156: );
157: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
158: ROLLBACK TO WSH_ITM_USERS_PKG;
159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
160: FND_MSG_PUB.Count_And_Get
161: ( p_count => x_msg_count,
162: p_data => x_msg_data
163: );

Line 166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

162: p_data => x_msg_data
163: );
164: WHEN OTHERS THEN
165: ROLLBACK TO WSH_ITM_USERS_PKG;
166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
167: IF FND_MSG_PUB.Check_Msg_Level
168: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
169: THEN
170: FND_MSG_PUB.Add_Exc_Msg

Line 192: -- p_init_msg_list (optional, default FND_API.G_FALSE)

188: --
189: -- Input Parameters
190: -- p_api_version
191: -- API version number (current version is 1.0)
192: -- p_init_msg_list (optional, default FND_API.G_FALSE)
193: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
194: -- if set to FND_API.G_TRUE
195: -- initialize error message list
196: -- if set to FND_API.G_FALSE - not initialize error

Line 193: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.

189: -- Input Parameters
190: -- p_api_version
191: -- API version number (current version is 1.0)
192: -- p_init_msg_list (optional, default FND_API.G_FALSE)
193: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
194: -- if set to FND_API.G_TRUE
195: -- initialize error message list
196: -- if set to FND_API.G_FALSE - not initialize error
197: -- message list

Line 194: -- if set to FND_API.G_TRUE

190: -- p_api_version
191: -- API version number (current version is 1.0)
192: -- p_init_msg_list (optional, default FND_API.G_FALSE)
193: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
194: -- if set to FND_API.G_TRUE
195: -- initialize error message list
196: -- if set to FND_API.G_FALSE - not initialize error
197: -- message list
198: -- p_commit (optional, default FND_API.G_FALSE)

Line 196: -- if set to FND_API.G_FALSE - not initialize error

192: -- p_init_msg_list (optional, default FND_API.G_FALSE)
193: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
194: -- if set to FND_API.G_TRUE
195: -- initialize error message list
196: -- if set to FND_API.G_FALSE - not initialize error
197: -- message list
198: -- p_commit (optional, default FND_API.G_FALSE)
199: -- whether or not to commit the changes to database
200: --

Line 198: -- p_commit (optional, default FND_API.G_FALSE)

194: -- if set to FND_API.G_TRUE
195: -- initialize error message list
196: -- if set to FND_API.G_FALSE - not initialize error
197: -- message list
198: -- p_commit (optional, default FND_API.G_FALSE)
199: -- whether or not to commit the changes to database
200: --
201: -- Input parameters for clear cross users informations
202: -- p_VENDOR_ID

Line 215: -- fnd_api.g_ret_sts_success;

211: --
212: -- Output Parameters
213: -- x_return_status
214: -- if the process succeeds, the value is
215: -- fnd_api.g_ret_sts_success;
216: -- if there is an expected error, the value is
217: -- fnd_api.g_ret_sts_error;
218: -- if there is an unexpected error, the value is
219: -- fnd_api.g_ret_sts_unexp_error;

Line 217: -- fnd_api.g_ret_sts_error;

213: -- x_return_status
214: -- if the process succeeds, the value is
215: -- fnd_api.g_ret_sts_success;
216: -- if there is an expected error, the value is
217: -- fnd_api.g_ret_sts_error;
218: -- if there is an unexpected error, the value is
219: -- fnd_api.g_ret_sts_unexp_error;
220: -- x_msg_count
221: -- if there is one or more errors, the number of error messages

Line 219: -- fnd_api.g_ret_sts_unexp_error;

215: -- fnd_api.g_ret_sts_success;
216: -- if there is an expected error, the value is
217: -- fnd_api.g_ret_sts_error;
218: -- if there is an unexpected error, the value is
219: -- fnd_api.g_ret_sts_unexp_error;
220: -- x_msg_count
221: -- if there is one or more errors, the number of error messages
222: -- in the buffer
223: -- x_msg_data

Line 225: -- (See fnd_api package for more details about the above output parameters)

221: -- if there is one or more errors, the number of error messages
222: -- in the buffer
223: -- x_msg_data
224: -- if there is one and only one error, the error message
225: -- (See fnd_api package for more details about the above output parameters)
226:
227: --*/
228: PROCEDURE Update_Row
229: (

Line 231: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,

227: --*/
228: PROCEDURE Update_Row
229: (
230: p_api_version IN NUMBER ,
231: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
232: p_commit IN VARCHAR2 := fnd_api.g_false ,
233: x_return_status OUT NOCOPY VARCHAR2 ,
234: x_msg_count OUT NOCOPY NUMBER ,
235: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 232: p_commit IN VARCHAR2 := fnd_api.g_false ,

228: PROCEDURE Update_Row
229: (
230: p_api_version IN NUMBER ,
231: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
232: p_commit IN VARCHAR2 := fnd_api.g_false ,
233: x_return_status OUT NOCOPY VARCHAR2 ,
234: x_msg_count OUT NOCOPY NUMBER ,
235: x_msg_data OUT NOCOPY VARCHAR2 ,
236: p_VENDOR_ID IN NUMBER,

Line 254: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

250: --dbms_output.put_line('begin');
251: -- Standard Start of API savepoint
252: SAVEPOINT WSH_ITM_USERS_PKG;
253: -- Standard call to check for call compatibility.
254: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
255: p_api_version ,
256: l_api_name ,
257: G_PKG_NAME )
258: THEN

Line 261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

257: G_PKG_NAME )
258: THEN
259: FND_MESSAGE.SET_NAME('WSH', 'WSH_INCOMPATIBLE_API_CALL');
260: FND_MSG_PUB.ADD;
261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
262: END IF;
263:
264: -- Initialize message list if p_init_msg_list is set to TRUE.
265: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 265: IF FND_API.to_Boolean( p_init_msg_list ) THEN

261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
262: END IF;
263:
264: -- Initialize message list if p_init_msg_list is set to TRUE.
265: IF FND_API.to_Boolean( p_init_msg_list ) THEN
266: FND_MSG_PUB.initialize;
267: END IF;
268:
269: -- Initialize API return status to success

Line 270: x_return_status := FND_API.G_RET_STS_SUCCESS;

266: FND_MSG_PUB.initialize;
267: END IF;
268:
269: -- Initialize API return status to success
270: x_return_status := FND_API.G_RET_STS_SUCCESS;
271:
272:
273: -- Update a row into wsh_itm_users entity with all detail information
274: -- for the given seq id

Line 294: x_return_status := FND_API.G_RET_STS_ERROR;

290:
291: IF SQL%NOTFOUND THEN
292: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_FAILED');
293: FND_MSG_PUB.ADD;
294: x_return_status := FND_API.G_RET_STS_ERROR;
295: RAISE FND_API.G_EXC_ERROR ;
296: END IF;
297:
298: x_return_status := fnd_api.g_ret_sts_success;

Line 295: RAISE FND_API.G_EXC_ERROR ;

291: IF SQL%NOTFOUND THEN
292: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_FAILED');
293: FND_MSG_PUB.ADD;
294: x_return_status := FND_API.G_RET_STS_ERROR;
295: RAISE FND_API.G_EXC_ERROR ;
296: END IF;
297:
298: x_return_status := fnd_api.g_ret_sts_success;
299:

Line 298: x_return_status := fnd_api.g_ret_sts_success;

294: x_return_status := FND_API.G_RET_STS_ERROR;
295: RAISE FND_API.G_EXC_ERROR ;
296: END IF;
297:
298: x_return_status := fnd_api.g_ret_sts_success;
299:
300: -- End of API body
301: -- Standard check of p_commit.
302:

Line 303: IF FND_API.To_Boolean( p_commit ) THEN

299:
300: -- End of API body
301: -- Standard check of p_commit.
302:
303: IF FND_API.To_Boolean( p_commit ) THEN
304: COMMIT WORK;
305: END IF;
306:
307: -- Standard call to get message count and if count is 1,

Line 316: WHEN FND_API.G_EXC_ERROR THEN

312: p_data => x_msg_data
313: );
314:
315: EXCEPTION
316: WHEN FND_API.G_EXC_ERROR THEN
317: ROLLBACK TO WSH_ITM_USERS_PKG;
318: x_return_status := FND_API.G_RET_STS_ERROR;
319: FND_MSG_PUB.Count_And_Get
320: ( p_count => x_msg_count,

Line 318: x_return_status := FND_API.G_RET_STS_ERROR;

314:
315: EXCEPTION
316: WHEN FND_API.G_EXC_ERROR THEN
317: ROLLBACK TO WSH_ITM_USERS_PKG;
318: x_return_status := FND_API.G_RET_STS_ERROR;
319: FND_MSG_PUB.Count_And_Get
320: ( p_count => x_msg_count,
321: p_data => x_msg_data
322: );

Line 324: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

320: ( p_count => x_msg_count,
321: p_data => x_msg_data
322: );
323:
324: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
325: ROLLBACK TO WSH_ITM_USERS_PKG;
326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
327: FND_MSG_PUB.Count_And_Get
328: ( p_count => x_msg_count,

Line 326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

322: );
323:
324: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
325: ROLLBACK TO WSH_ITM_USERS_PKG;
326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
327: FND_MSG_PUB.Count_And_Get
328: ( p_count => x_msg_count,
329: p_data => x_msg_data
330: );

Line 361: -- p_init_msg_list (optional, default FND_API.G_FALSE)

357: --
358: -- Input Parameters
359: -- p_api_version
360: -- API version number (current version is 1.0)
361: -- p_init_msg_list (optional, default FND_API.G_FALSE)
362: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
363: -- if set to FND_API.G_TRUE
364: -- initialize error message list
365: -- if set to FND_API.G_FALSE - not initialize error

Line 362: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.

358: -- Input Parameters
359: -- p_api_version
360: -- API version number (current version is 1.0)
361: -- p_init_msg_list (optional, default FND_API.G_FALSE)
362: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
363: -- if set to FND_API.G_TRUE
364: -- initialize error message list
365: -- if set to FND_API.G_FALSE - not initialize error
366: -- message list

Line 363: -- if set to FND_API.G_TRUE

359: -- p_api_version
360: -- API version number (current version is 1.0)
361: -- p_init_msg_list (optional, default FND_API.G_FALSE)
362: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
363: -- if set to FND_API.G_TRUE
364: -- initialize error message list
365: -- if set to FND_API.G_FALSE - not initialize error
366: -- message list
367: -- p_commit (optional, default FND_API.G_FALSE)

Line 365: -- if set to FND_API.G_FALSE - not initialize error

361: -- p_init_msg_list (optional, default FND_API.G_FALSE)
362: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
363: -- if set to FND_API.G_TRUE
364: -- initialize error message list
365: -- if set to FND_API.G_FALSE - not initialize error
366: -- message list
367: -- p_commit (optional, default FND_API.G_FALSE)
368: -- whether or not to commit the changes to database
369: --

Line 367: -- p_commit (optional, default FND_API.G_FALSE)

363: -- if set to FND_API.G_TRUE
364: -- initialize error message list
365: -- if set to FND_API.G_FALSE - not initialize error
366: -- message list
367: -- p_commit (optional, default FND_API.G_FALSE)
368: -- whether or not to commit the changes to database
369: --
370: -- Input parameters for clear cross users informations
371: -- p_ITM_USER_SEQUENCE_ID -- ITM Seq Id

Line 377: -- fnd_api.g_ret_sts_success;

373: --
374: -- Output Parameters
375: -- x_return_status
376: -- if the process succeeds, the value is
377: -- fnd_api.g_ret_sts_success;
378: -- if there is an expected error, the value is
379: -- fnd_api.g_ret_sts_error;
380: -- if there is an unexpected error, the value is
381: -- fnd_api.g_ret_sts_unexp_error;

Line 379: -- fnd_api.g_ret_sts_error;

375: -- x_return_status
376: -- if the process succeeds, the value is
377: -- fnd_api.g_ret_sts_success;
378: -- if there is an expected error, the value is
379: -- fnd_api.g_ret_sts_error;
380: -- if there is an unexpected error, the value is
381: -- fnd_api.g_ret_sts_unexp_error;
382: -- x_msg_count
383: -- if there is one or more errors, the number of error messages

Line 381: -- fnd_api.g_ret_sts_unexp_error;

377: -- fnd_api.g_ret_sts_success;
378: -- if there is an expected error, the value is
379: -- fnd_api.g_ret_sts_error;
380: -- if there is an unexpected error, the value is
381: -- fnd_api.g_ret_sts_unexp_error;
382: -- x_msg_count
383: -- if there is one or more errors, the number of error messages
384: -- in the buffer
385: -- x_msg_data

Line 387: -- (See fnd_api package for more details about the above output parameters)

383: -- if there is one or more errors, the number of error messages
384: -- in the buffer
385: -- x_msg_data
386: -- if there is one and only one error, the error message
387: -- (See fnd_api package for more details about the above output parameters)
388:
389: --*/
390: PROCEDURE Delete_Row
391: (

Line 393: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,

389: --*/
390: PROCEDURE Delete_Row
391: (
392: p_api_version IN NUMBER ,
393: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
394: p_commit IN VARCHAR2 := fnd_api.g_false ,
395: x_return_status OUT NOCOPY VARCHAR2 ,
396: x_msg_count OUT NOCOPY NUMBER ,
397: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 394: p_commit IN VARCHAR2 := fnd_api.g_false ,

390: PROCEDURE Delete_Row
391: (
392: p_api_version IN NUMBER ,
393: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
394: p_commit IN VARCHAR2 := fnd_api.g_false ,
395: x_return_status OUT NOCOPY VARCHAR2 ,
396: x_msg_count OUT NOCOPY NUMBER ,
397: x_msg_data OUT NOCOPY VARCHAR2 ,
398: p_ITM_USER_SEQUENCE_ID IN NUMBER

Line 408: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

404: --dbms_output.put_line('begin');
405: -- Standard Start of API savepoint
406: SAVEPOINT WSH_ITM_USERS_PKG;
407: -- Standard call to check for call compatibility.
408: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
409: p_api_version ,
410: l_api_name ,
411: G_PKG_NAME )
412: THEN

Line 415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

411: G_PKG_NAME )
412: THEN
413: FND_MESSAGE.SET_NAME('WSH', 'WSH_INCOMPATIBLE_API_CALL');
414: FND_MSG_PUB.ADD;
415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
416: END IF;
417: -- Initialize message list if p_init_msg_list is set to TRUE.
418: IF FND_API.to_Boolean( p_init_msg_list ) THEN
419: FND_MSG_PUB.initialize;

Line 418: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 422: x_return_status := FND_API.G_RET_STS_SUCCESS;

418: IF FND_API.to_Boolean( p_init_msg_list ) THEN
419: FND_MSG_PUB.initialize;
420: END IF;
421: -- Initialize API return status to success
422: x_return_status := FND_API.G_RET_STS_SUCCESS;
423:
424: -- Delete a row from wsh_itm_users entity
425: -- for the given cc seq id
426:

Line 432: x_return_status := FND_API.G_RET_STS_ERROR;

428: WHERE itm_user_sequence_id = p_itm_user_sequence_id ;
429: IF SQL%NOTFOUND THEN
430: FND_MESSAGE.SET_NAME('WSH', 'WSH_DELETE_FAILED');
431: FND_MSG_PUB.ADD;
432: x_return_status := FND_API.G_RET_STS_ERROR;
433: RAISE FND_API.G_EXC_ERROR ;
434: END IF;
435: --dbms_output.put_line('begin-5');
436: x_return_status := fnd_api.g_ret_sts_success;

Line 433: RAISE FND_API.G_EXC_ERROR ;

429: IF SQL%NOTFOUND THEN
430: FND_MESSAGE.SET_NAME('WSH', 'WSH_DELETE_FAILED');
431: FND_MSG_PUB.ADD;
432: x_return_status := FND_API.G_RET_STS_ERROR;
433: RAISE FND_API.G_EXC_ERROR ;
434: END IF;
435: --dbms_output.put_line('begin-5');
436: x_return_status := fnd_api.g_ret_sts_success;
437:

Line 436: x_return_status := fnd_api.g_ret_sts_success;

432: x_return_status := FND_API.G_RET_STS_ERROR;
433: RAISE FND_API.G_EXC_ERROR ;
434: END IF;
435: --dbms_output.put_line('begin-5');
436: x_return_status := fnd_api.g_ret_sts_success;
437:
438: -- End of API body
439: -- Standard check of p_commit.
440: IF FND_API.To_Boolean( p_commit ) THEN

Line 440: IF FND_API.To_Boolean( p_commit ) THEN

436: x_return_status := fnd_api.g_ret_sts_success;
437:
438: -- End of API body
439: -- Standard check of p_commit.
440: IF FND_API.To_Boolean( p_commit ) THEN
441: COMMIT WORK;
442: END IF;
443: -- Standard call to get message count and if count is 1,
444: -- get message info.

Line 451: WHEN FND_API.G_EXC_ERROR THEN

447: p_data => x_msg_data
448: );
449:
450: EXCEPTION
451: WHEN FND_API.G_EXC_ERROR THEN
452: --dbms_output.put_line(sqlerrm);
453: ROLLBACK TO WSH_ITM_USERS_PKG;
454: x_return_status := FND_API.G_RET_STS_ERROR;
455: FND_MSG_PUB.Count_And_Get

Line 454: x_return_status := FND_API.G_RET_STS_ERROR;

450: EXCEPTION
451: WHEN FND_API.G_EXC_ERROR THEN
452: --dbms_output.put_line(sqlerrm);
453: ROLLBACK TO WSH_ITM_USERS_PKG;
454: x_return_status := FND_API.G_RET_STS_ERROR;
455: FND_MSG_PUB.Count_And_Get
456: ( p_count => x_msg_count,
457: p_data => x_msg_data
458: );

Line 459: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

455: FND_MSG_PUB.Count_And_Get
456: ( p_count => x_msg_count,
457: p_data => x_msg_data
458: );
459: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
460: --dbms_output.put_line(sqlerrm);
461: ROLLBACK TO WSH_ITM_USERS_PKG;
462: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
463: FND_MSG_PUB.Count_And_Get

Line 462: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

458: );
459: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
460: --dbms_output.put_line(sqlerrm);
461: ROLLBACK TO WSH_ITM_USERS_PKG;
462: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
463: FND_MSG_PUB.Count_And_Get
464: ( p_count => x_msg_count,
465: p_data => x_msg_data
466: );

Line 496: -- p_init_msg_list (optional, default FND_API.G_FALSE)

492: --
493: -- Input Parameters
494: -- p_api_version
495: -- API version number (current version is 1.0)
496: -- p_init_msg_list (optional, default FND_API.G_FALSE)
497: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
498: -- if set to FND_API.G_TRUE
499: -- initialize error message list
500: -- if set to FND_API.G_FALSE - not initialize error

Line 497: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.

493: -- Input Parameters
494: -- p_api_version
495: -- API version number (current version is 1.0)
496: -- p_init_msg_list (optional, default FND_API.G_FALSE)
497: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
498: -- if set to FND_API.G_TRUE
499: -- initialize error message list
500: -- if set to FND_API.G_FALSE - not initialize error
501: -- message list

Line 498: -- if set to FND_API.G_TRUE

494: -- p_api_version
495: -- API version number (current version is 1.0)
496: -- p_init_msg_list (optional, default FND_API.G_FALSE)
497: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
498: -- if set to FND_API.G_TRUE
499: -- initialize error message list
500: -- if set to FND_API.G_FALSE - not initialize error
501: -- message list
502: -- p_commit (optional, default FND_API.G_FALSE)

Line 500: -- if set to FND_API.G_FALSE - not initialize error

496: -- p_init_msg_list (optional, default FND_API.G_FALSE)
497: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
498: -- if set to FND_API.G_TRUE
499: -- initialize error message list
500: -- if set to FND_API.G_FALSE - not initialize error
501: -- message list
502: -- p_commit (optional, default FND_API.G_FALSE)
503: -- whether or not to commit the changes to database
504: --

Line 502: -- p_commit (optional, default FND_API.G_FALSE)

498: -- if set to FND_API.G_TRUE
499: -- initialize error message list
500: -- if set to FND_API.G_FALSE - not initialize error
501: -- message list
502: -- p_commit (optional, default FND_API.G_FALSE)
503: -- whether or not to commit the changes to database
504: --
505: -- Input parameters for clear cross users informations
506: -- p_VENDOR_ID --Vendor Id

Line 519: -- fnd_api.g_ret_sts_success;

515: --
516: -- Output Parameters
517: -- x_return_status
518: -- if the process succeeds, the value is
519: -- fnd_api.g_ret_sts_success;
520: -- if there is an expected error, the value is
521: -- fnd_api.g_ret_sts_error;
522: -- if there is an unexpected error, the value is
523: -- fnd_api.g_ret_sts_unexp_error;

Line 521: -- fnd_api.g_ret_sts_error;

517: -- x_return_status
518: -- if the process succeeds, the value is
519: -- fnd_api.g_ret_sts_success;
520: -- if there is an expected error, the value is
521: -- fnd_api.g_ret_sts_error;
522: -- if there is an unexpected error, the value is
523: -- fnd_api.g_ret_sts_unexp_error;
524: -- x_msg_count
525: -- if there is one or more errors, the number of error messages

Line 523: -- fnd_api.g_ret_sts_unexp_error;

519: -- fnd_api.g_ret_sts_success;
520: -- if there is an expected error, the value is
521: -- fnd_api.g_ret_sts_error;
522: -- if there is an unexpected error, the value is
523: -- fnd_api.g_ret_sts_unexp_error;
524: -- x_msg_count
525: -- if there is one or more errors, the number of error messages
526: -- in the buffer
527: -- x_msg_data

Line 529: -- (See fnd_api package for more details about the above output parameters)

525: -- if there is one or more errors, the number of error messages
526: -- in the buffer
527: -- x_msg_data
528: -- if there is one and only one error, the error message
529: -- (See fnd_api package for more details about the above output parameters)
530:
531: --*/
532: PROCEDURE Lock_Row
533: (

Line 535: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,

531: --*/
532: PROCEDURE Lock_Row
533: (
534: p_api_version IN NUMBER ,
535: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
536: p_commit IN VARCHAR2 := fnd_api.g_false ,
537: x_return_status OUT NOCOPY VARCHAR2 ,
538: x_msg_count OUT NOCOPY NUMBER ,
539: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 536: p_commit IN VARCHAR2 := fnd_api.g_false ,

532: PROCEDURE Lock_Row
533: (
534: p_api_version IN NUMBER ,
535: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
536: p_commit IN VARCHAR2 := fnd_api.g_false ,
537: x_return_status OUT NOCOPY VARCHAR2 ,
538: x_msg_count OUT NOCOPY NUMBER ,
539: x_msg_data OUT NOCOPY VARCHAR2 ,
540: p_VENDOR_ID IN NUMBER,

Line 567: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

563:
564: -- Standard Start of API savepoint
565: SAVEPOINT WSH_ITM_USERS_PKG;
566: -- Standard call to check for call compatibility.
567: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
568: p_api_version ,
569: l_api_name ,
570: G_PKG_NAME )
571: THEN

Line 574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

570: G_PKG_NAME )
571: THEN
572: FND_MESSAGE.SET_NAME('WSH', 'WSH_INCOMPATIBLE_API_CALL');
573: FND_MSG_PUB.ADD;
574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
575: END IF;
576:
577: -- Initialize message list if p_init_msg_list is set to TRUE.
578: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 578: IF FND_API.to_Boolean( p_init_msg_list ) THEN

574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
575: END IF;
576:
577: -- Initialize message list if p_init_msg_list is set to TRUE.
578: IF FND_API.to_Boolean( p_init_msg_list ) THEN
579: FND_MSG_PUB.initialize;
580: END IF;
581:
582: -- Initialize API return status to success

Line 583: x_return_status := FND_API.G_RET_STS_SUCCESS;

579: FND_MSG_PUB.initialize;
580: END IF;
581:
582: -- Initialize API return status to success
583: x_return_status := FND_API.G_RET_STS_SUCCESS;
584:
585: -- Check Lock a row into wsh_itm_users entity with all detail information
586:
587: OPEN lock_row;