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

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

22: /* Bug 7504490 - Modified the procedure. Added the parameter p_pn_id and p_revision
23: to create CC entries for an LPN when a short pick was for an allocated lpn */
24: PROCEDURE Create_Unscheduled_Counts
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: x_return_status OUT NOCOPY VARCHAR2 ,
29: x_msg_count OUT NOCOPY NUMBER ,
30: x_msg_data OUT NOCOPY VARCHAR2 ,

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

23: to create CC entries for an LPN when a short pick was for an allocated lpn */
24: PROCEDURE Create_Unscheduled_Counts
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: x_return_status OUT NOCOPY VARCHAR2 ,
29: x_msg_count OUT NOCOPY NUMBER ,
30: x_msg_data OUT NOCOPY VARCHAR2 ,
31: p_organization_id IN NUMBER ,

Line 65: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

61: BEGIN
62: -- Standard Start of API savepoint
63: SAVEPOINT Create_Unscheduled_Counts_PVT;
64: -- Standard call to check for call compatibility.
65: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
66: p_api_version ,
67: l_api_name ,
68: G_PKG_NAME )
69: THEN

Line 72: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

68: G_PKG_NAME )
69: THEN
70: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');
71: FND_MSG_PUB.ADD;
72: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
73: END IF;
74: -- Initialize message list if p_init_msg_list is set to TRUE.
75: IF FND_API.to_Boolean( p_init_msg_list ) THEN
76: FND_MSG_PUB.initialize;

Line 75: IF FND_API.to_Boolean( p_init_msg_list ) THEN

71: FND_MSG_PUB.ADD;
72: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
73: END IF;
74: -- Initialize message list if p_init_msg_list is set to TRUE.
75: IF FND_API.to_Boolean( p_init_msg_list ) THEN
76: FND_MSG_PUB.initialize;
77: END IF;
78: -- Initialize API return status to success
79: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 79: x_return_status := FND_API.G_RET_STS_SUCCESS;

75: IF FND_API.to_Boolean( p_init_msg_list ) THEN
76: FND_MSG_PUB.initialize;
77: END IF;
78: -- Initialize API return status to success
79: x_return_status := FND_API.G_RET_STS_SUCCESS;
80:
81: -- API body
82: /* Validate all inputs */
83:

Line 99: RAISE FND_API.G_EXC_ERROR;

95: l_result := INV_Validate.Organization(l_org);
96: IF (l_result = INV_Validate.F) THEN
97: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_ORG');
98: FND_MSG_PUB.ADD;
99: RAISE FND_API.G_EXC_ERROR;
100: END IF;
101:
102: /* Validate Subinventory */
103: IF (p_subinventory IS NOT NULL) THEN

Line 109: RAISE FND_API.G_EXC_ERROR;

105: l_result := INV_Validate.subinventory(l_sub, l_org);
106: IF (l_result = INV_Validate.F) THEN
107: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_SUB');
108: FND_MSG_PUB.ADD;
109: RAISE FND_API.G_EXC_ERROR;
110: END IF;
111: END IF;
112:
113: /* Validate Locator */

Line 119: RAISE FND_API.G_EXC_ERROR;

115: IF (l_sub.locator_type IN (2,3)) THEN
116: IF (p_locator_id IS NULL) THEN
117: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_MISS_REQ_LOC');
118: FND_MSG_PUB.ADD;
119: RAISE FND_API.G_EXC_ERROR;
120: END IF;
121: l_locator.inventory_location_id := p_locator_id;
122: l_result := INV_Validate.validateLocator(l_locator, l_org, l_sub);
123: IF (l_result = INV_Validate.F) THEN

Line 126: RAISE FND_API.G_EXC_ERROR;

122: l_result := INV_Validate.validateLocator(l_locator, l_org, l_sub);
123: IF (l_result = INV_Validate.F) THEN
124: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_LOC');
125: FND_MSG_PUB.ADD;
126: RAISE FND_API.G_EXC_ERROR;
127: END IF;
128: END IF;
129: END IF;
130:

Line 138: RAISE FND_API.G_EXC_ERROR;

134: ELSE
135: IF (l_org.default_cyc_count_header_id IS NULL) THEN
136: FND_MESSAGE.SET_NAME('INV', 'INV_CCEOI_INVALID_HEADER');
137: FND_MSG_PUB.ADD;
138: RAISE FND_API.G_EXC_ERROR;
139: ELSE
140: l_cycle_count_header_id := l_org.default_cyc_count_header_id;
141: END IF;
142: END IF;

Line 153: RAISE FND_API.G_EXC_ERROR;

149: AND organization_id = p_organization_id;
150: IF (l_unscheduled_count_entry = 2) THEN
151: FND_MESSAGE.SET_NAME('INV', 'INV_CCEOI_NO_UNSCHED_COUNTS');
152: FND_MSG_PUB.ADD;
153: RAISE FND_API.G_EXC_ERROR;
154: END IF;
155: IF (l_debug = 1) THEN
156: print_debug('Finished Validations');
157: END IF;

Line 229: RAISE FND_API.G_EXC_ERROR;

225: IF (l_req_id <= 0 OR l_req_id IS NULL) THEN
226: IF (l_debug = 1) THEN
227: print_debug('Error in calling the generate count requests program');
228: END IF;
229: RAISE FND_API.G_EXC_ERROR;
230: ELSE
231: COMMIT;
232: END IF;
233:

Line 241: x_return_status := FND_API.G_RET_STS_SUCCESS;

237: print_debug('p_lpn_id is not null:' || p_lpn_id);
238: END IF;
239:
240: -- Initialisize API return status to access
241: x_return_status := FND_API.G_RET_STS_SUCCESS;
242: l_errorcode := 0;
243:
244: IF (l_debug = 1) THEN
245: print_debug('Initializing the fields for the record');

Line 293: , p_init_msg_list => FND_API.G_TRUE

289: END IF;
290:
291: MTL_CCEOI_ACTION_PUB.process_lpn_countrequest
292: ( p_api_version => l_api_version_int
293: , p_init_msg_list => FND_API.G_TRUE
294: , p_commit => FND_API.G_TRUE
295: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
296: , x_return_status => x_return_status
297: , x_errorcode => l_errorcode

Line 294: , p_commit => FND_API.G_TRUE

290:
291: MTL_CCEOI_ACTION_PUB.process_lpn_countrequest
292: ( p_api_version => l_api_version_int
293: , p_init_msg_list => FND_API.G_TRUE
294: , p_commit => FND_API.G_TRUE
295: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
296: , x_return_status => x_return_status
297: , x_errorcode => l_errorcode
298: , x_msg_count => x_msg_count

Line 295: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

291: MTL_CCEOI_ACTION_PUB.process_lpn_countrequest
292: ( p_api_version => l_api_version_int
293: , p_init_msg_list => FND_API.G_TRUE
294: , p_commit => FND_API.G_TRUE
295: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
296: , x_return_status => x_return_status
297: , x_errorcode => l_errorcode
298: , x_msg_count => x_msg_count
299: , x_msg_data => x_msg_data

Line 304: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

300: , p_interface_rec => l_interface_rec
301: , x_interface_id_list => l_interface_id_list
302: ) ;
303:
304: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
305: IF (l_debug = 1) THEN
306: print_debug('LPN count request error');
307: END IF;
308: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 308: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

304: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
305: IF (l_debug = 1) THEN
306: print_debug('LPN count request error');
307: END IF;
308: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
309: END IF;
310: ENd IF; --end l_count condition
311: END IF; --End of p_lpn_id condition
312:

Line 343: IF FND_API.To_Boolean( p_commit ) THEN

339: END IF;
340:
341: -- End of API body
342: -- Standard check of p_commit.
343: IF FND_API.To_Boolean( p_commit ) THEN
344: COMMIT WORK;
345: END IF;
346: -- Standard call to get message count and if count is 1,
347: -- get message info.

Line 357: WHEN FND_API.G_EXC_ERROR THEN

353: print_debug('Successfully called the procedure Create_Unscheduled_Counts');
354: END IF;
355:
356: EXCEPTION
357: WHEN FND_API.G_EXC_ERROR THEN
358: ROLLBACK TO Create_Unscheduled_Counts_PVT;
359: x_return_status := FND_API.G_RET_STS_ERROR;
360: IF (l_debug = 1) THEN
361: print_debug('Execution error!');

Line 359: x_return_status := FND_API.G_RET_STS_ERROR;

355:
356: EXCEPTION
357: WHEN FND_API.G_EXC_ERROR THEN
358: ROLLBACK TO Create_Unscheduled_Counts_PVT;
359: x_return_status := FND_API.G_RET_STS_ERROR;
360: IF (l_debug = 1) THEN
361: print_debug('Execution error!');
362: END IF;
363: FND_MSG_PUB.Count_And_Get

Line 367: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

363: FND_MSG_PUB.Count_And_Get
364: ( p_count => x_msg_count,
365: p_data => x_msg_data
366: );
367: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
368: ROLLBACK TO Create_Unscheduled_Counts_PVT;
369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
370: IF (l_debug = 1) THEN
371: print_debug('Unexpected error!');

Line 369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

365: p_data => x_msg_data
366: );
367: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
368: ROLLBACK TO Create_Unscheduled_Counts_PVT;
369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
370: IF (l_debug = 1) THEN
371: print_debug('Unexpected error!');
372: END IF;
373: FND_MSG_PUB.Count_And_Get

Line 379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

375: p_data => x_msg_data
376: );
377: WHEN OTHERS THEN
378: ROLLBACK TO Create_Unscheduled_Counts_PVT;
379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
380: IF (l_debug = 1) THEN
381: print_debug('Others error!');
382: END IF;
383: IF FND_MSG_PUB.Check_Msg_Level