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

Line 46: -- and pass p_suggest_serial as fnd_api.true, the engine will filter

42: --
43: -- 2. Serial Number Detailing in Picking
44: -- Currently the serial number detailing is quite simple. If the caller
45: -- gives a range (start, and end) serial numbers in the move order line
46: -- and pass p_suggest_serial as fnd_api.true, the engine will filter
47: -- the locations found from a rule, and suggest unused serial numbers
48: -- in the locator. If p_suggest_serial is passed as fnd_api.g_false
49: -- (default), the engine will not give serial numbers in the output.
50: --

Line 48: -- in the locator. If p_suggest_serial is passed as fnd_api.g_false

44: -- Currently the serial number detailing is quite simple. If the caller
45: -- gives a range (start, and end) serial numbers in the move order line
46: -- and pass p_suggest_serial as fnd_api.true, the engine will filter
47: -- the locations found from a rule, and suggest unused serial numbers
48: -- in the locator. If p_suggest_serial is passed as fnd_api.g_false
49: -- (default), the engine will not give serial numbers in the output.
50: --
51: -- Input Parameters
52: -- p_api_version_number standard input parameter

Line 80: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

76: --
77: PROCEDURE create_suggestions
78: (
79: p_api_version IN NUMBER,
80: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
81: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
82: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_none,
83: x_return_status OUT NOCOPY VARCHAR2,
84: x_msg_count OUT NOCOPY NUMBER,

Line 81: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

77: PROCEDURE create_suggestions
78: (
79: p_api_version IN NUMBER,
80: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
81: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
82: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_none,
83: x_return_status OUT NOCOPY VARCHAR2,
84: x_msg_count OUT NOCOPY NUMBER,
85: x_msg_data OUT NOCOPY VARCHAR2,

Line 82: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_none,

78: (
79: p_api_version IN NUMBER,
80: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
81: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
82: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_none,
83: x_return_status OUT NOCOPY VARCHAR2,
84: x_msg_count OUT NOCOPY NUMBER,
85: x_msg_data OUT NOCOPY VARCHAR2,
86: p_transaction_temp_id IN NUMBER,

Line 88: p_suggest_serial IN VARCHAR2 DEFAULT fnd_api.g_false,

84: x_msg_count OUT NOCOPY NUMBER,
85: x_msg_data OUT NOCOPY VARCHAR2,
86: p_transaction_temp_id IN NUMBER,
87: p_reservations IN inv_reservation_global.mtl_reservation_tbl_type,
88: p_suggest_serial IN VARCHAR2 DEFAULT fnd_api.g_false,
89: p_plan_tasks IN BOOLEAN,
90: p_quick_pick_flag IN VARCHAR2 DEFAULT 'N',
91: p_organization_id IN NUMBER
92: ) is

Line 95: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

91: p_organization_id IN NUMBER
92: ) is
93: l_api_version CONSTANT NUMBER := 1.0;
94: l_api_name CONSTANT VARCHAR2(30) := 'Create_Suggestions';
95: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
96: l_msg_count NUMBER;
97: l_msg_data VARCHAR2(2000);
98: l_wms_installed BOOLEAN;
99: l_org_id NUMBER;

Line 122: IF NOT fnd_api.Compatible_API_Call(l_api_version

118: END IF;
119: -- end of debugging section
120: --
121: -- Standard Call to check for call compatibility
122: IF NOT fnd_api.Compatible_API_Call(l_api_version
123: , p_api_version
124: , l_api_name
125: , g_pkg_name) THEN
126: RAISE fnd_api.g_exc_unexpected_error;

Line 126: RAISE fnd_api.g_exc_unexpected_error;

122: IF NOT fnd_api.Compatible_API_Call(l_api_version
123: , p_api_version
124: , l_api_name
125: , g_pkg_name) THEN
126: RAISE fnd_api.g_exc_unexpected_error;
127: END IF;
128: --
129: -- Initialize message list if p_init_msg_list is set to true
130: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 130: IF fnd_api.to_boolean(p_init_msg_list) THEN

126: RAISE fnd_api.g_exc_unexpected_error;
127: END IF;
128: --
129: -- Initialize message list if p_init_msg_list is set to true
130: IF fnd_api.to_boolean(p_init_msg_list) THEN
131: fnd_msg_pub.initialize;
132: END IF;
133: --
134: -- Initialisize API return status to access

Line 135: x_return_status := fnd_api.g_ret_sts_success;

131: fnd_msg_pub.initialize;
132: END IF;
133: --
134: -- Initialisize API return status to access
135: x_return_status := fnd_api.g_ret_sts_success;
136: --
137: -- Detailing starts here
138: --
139: -- Fix 5264987 : Query DB only if p_organization_id is not passed/-9999

Line 167: RAISE fnd_api.g_exc_unexpected_error;

163: x_msg_data => l_msg_data,
164: p_organization_id => l_org_id); */
165: l_return_value := INV_CACHE.set_wms_installed(l_org_id);
166: If NOT l_return_value Then
167: RAISE fnd_api.g_exc_unexpected_error;
168: End If;
169: l_wms_installed := INV_CACHE.wms_installed;
170: --End of Changes for Bug#3153166
171:

Line 182: p_init_msg_list => fnd_api.g_false,

178: THEN
179: gmi_reservation_util.println('calling inv crreate_sugg');
180: inv_autodetail.create_suggestions
181: ( p_api_version => 1.0,
182: p_init_msg_list => fnd_api.g_false,
183: p_commit => fnd_api.g_false,
184: p_validation_level => p_validation_level,
185: x_return_status => l_return_status,
186: x_msg_count => l_msg_count,

Line 183: p_commit => fnd_api.g_false,

179: gmi_reservation_util.println('calling inv crreate_sugg');
180: inv_autodetail.create_suggestions
181: ( p_api_version => 1.0,
182: p_init_msg_list => fnd_api.g_false,
183: p_commit => fnd_api.g_false,
184: p_validation_level => p_validation_level,
185: x_return_status => l_return_status,
186: x_msg_count => l_msg_count,
187: x_msg_data => l_msg_data,

Line 197: p_init_msg_list => fnd_api.g_false,

193: IF (l_current_release_level >= l_j_release_level ) THEN
194: gmi_reservation_util.println(' calling >=J wms create_sugg, 11511 is included');
195: wms_engine_pvt.create_suggestions
196: ( p_api_version => 1.0,
197: p_init_msg_list => fnd_api.g_false,
198: p_commit => fnd_api.g_false,
199: p_validation_level => p_validation_level,
200: x_return_status => l_return_status,
201: x_msg_count => l_msg_count,

Line 198: p_commit => fnd_api.g_false,

194: gmi_reservation_util.println(' calling >=J wms create_sugg, 11511 is included');
195: wms_engine_pvt.create_suggestions
196: ( p_api_version => 1.0,
197: p_init_msg_list => fnd_api.g_false,
198: p_commit => fnd_api.g_false,
199: p_validation_level => p_validation_level,
200: x_return_status => l_return_status,
201: x_msg_count => l_msg_count,
202: x_msg_data => l_msg_data,

Line 213: p_init_msg_list => fnd_api.g_false,

209: ELSE
210: gmi_reservation_util.println(' calling 211: wms_engine_pvt.create_suggestions
212: ( p_api_version => 1.0,
213: p_init_msg_list => fnd_api.g_false,
214: p_commit => fnd_api.g_false,
215: p_validation_level => p_validation_level,
216: x_return_status => l_return_status,
217: x_msg_count => l_msg_count,

Line 214: p_commit => fnd_api.g_false,

210: gmi_reservation_util.println(' calling 211: wms_engine_pvt.create_suggestions
212: ( p_api_version => 1.0,
213: p_init_msg_list => fnd_api.g_false,
214: p_commit => fnd_api.g_false,
215: p_validation_level => p_validation_level,
216: x_return_status => l_return_status,
217: x_msg_count => l_msg_count,
218: x_msg_data => l_msg_data,

Line 227: IF l_return_status = fnd_api.g_ret_sts_error THEN

223: );
224: END IF;
225: END IF;
226:
227: IF l_return_status = fnd_api.g_ret_sts_error THEN
228: RAISE fnd_api.g_exc_error;
229: END IF;
230: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
231: RAISE fnd_api.g_exc_unexpected_error;

Line 228: RAISE fnd_api.g_exc_error;

224: END IF;
225: END IF;
226:
227: IF l_return_status = fnd_api.g_ret_sts_error THEN
228: RAISE fnd_api.g_exc_error;
229: END IF;
230: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
231: RAISE fnd_api.g_exc_unexpected_error;
232: END IF;

Line 230: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

226:
227: IF l_return_status = fnd_api.g_ret_sts_error THEN
228: RAISE fnd_api.g_exc_error;
229: END IF;
230: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
231: RAISE fnd_api.g_exc_unexpected_error;
232: END IF;
233: -- Standard check of p_commit
234: IF fnd_api.to_boolean(p_commit) THEN

Line 231: RAISE fnd_api.g_exc_unexpected_error;

227: IF l_return_status = fnd_api.g_ret_sts_error THEN
228: RAISE fnd_api.g_exc_error;
229: END IF;
230: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
231: RAISE fnd_api.g_exc_unexpected_error;
232: END IF;
233: -- Standard check of p_commit
234: IF fnd_api.to_boolean(p_commit) THEN
235: COMMIT;

Line 234: IF fnd_api.to_boolean(p_commit) THEN

230: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
231: RAISE fnd_api.g_exc_unexpected_error;
232: END IF;
233: -- Standard check of p_commit
234: IF fnd_api.to_boolean(p_commit) THEN
235: COMMIT;
236: END IF;
237: --
238: -- debugging section

Line 246: WHEN fnd_api.g_exc_error THEN

242: END IF;
243: -- end of debugging section
244: --
245: EXCEPTION
246: WHEN fnd_api.g_exc_error THEN
247: x_return_status := fnd_api.g_ret_sts_error;
248: fnd_msg_pub.Count_And_Get
249: ( p_count => x_msg_count
250: ,p_data => x_msg_data);

Line 247: x_return_status := fnd_api.g_ret_sts_error;

243: -- end of debugging section
244: --
245: EXCEPTION
246: WHEN fnd_api.g_exc_error THEN
247: x_return_status := fnd_api.g_ret_sts_error;
248: fnd_msg_pub.Count_And_Get
249: ( p_count => x_msg_count
250: ,p_data => x_msg_data);
251: --

Line 252: WHEN fnd_api.g_exc_unexpected_error THEN

248: fnd_msg_pub.Count_And_Get
249: ( p_count => x_msg_count
250: ,p_data => x_msg_data);
251: --
252: WHEN fnd_api.g_exc_unexpected_error THEN
253: x_return_status := fnd_api.g_ret_sts_unexp_error;
254: fnd_msg_pub.Count_And_Get
255: ( p_count => x_msg_count
256: ,p_data => x_msg_data);

Line 253: x_return_status := fnd_api.g_ret_sts_unexp_error;

249: ( p_count => x_msg_count
250: ,p_data => x_msg_data);
251: --
252: WHEN fnd_api.g_exc_unexpected_error THEN
253: x_return_status := fnd_api.g_ret_sts_unexp_error;
254: fnd_msg_pub.Count_And_Get
255: ( p_count => x_msg_count
256: ,p_data => x_msg_data);
257: --

Line 259: x_return_status := fnd_api.g_ret_sts_unexp_error;

255: ( p_count => x_msg_count
256: ,p_data => x_msg_data);
257: --
258: WHEN OTHERS THEN
259: x_return_status := fnd_api.g_ret_sts_unexp_error;
260: IF fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
261: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_api_name);
262: END IF;
263: fnd_msg_pub.count_and_get

Line 272: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

268: -- Create_suggestions api is overloaded for Performance bug fix 5264987
269: PROCEDURE create_suggestions
270: (
271: p_api_version IN NUMBER,
272: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
273: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
274: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_none,
275: x_return_status OUT NOCOPY VARCHAR2,
276: x_msg_count OUT NOCOPY NUMBER,

Line 273: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

269: PROCEDURE create_suggestions
270: (
271: p_api_version IN NUMBER,
272: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
273: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
274: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_none,
275: x_return_status OUT NOCOPY VARCHAR2,
276: x_msg_count OUT NOCOPY NUMBER,
277: x_msg_data OUT NOCOPY VARCHAR2,

Line 274: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_none,

270: (
271: p_api_version IN NUMBER,
272: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
273: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
274: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_none,
275: x_return_status OUT NOCOPY VARCHAR2,
276: x_msg_count OUT NOCOPY NUMBER,
277: x_msg_data OUT NOCOPY VARCHAR2,
278: p_transaction_temp_id IN NUMBER,

Line 280: p_suggest_serial IN VARCHAR2 DEFAULT fnd_api.g_false,

276: x_msg_count OUT NOCOPY NUMBER,
277: x_msg_data OUT NOCOPY VARCHAR2,
278: p_transaction_temp_id IN NUMBER,
279: p_reservations IN inv_reservation_global.mtl_reservation_tbl_type,
280: p_suggest_serial IN VARCHAR2 DEFAULT fnd_api.g_false,
281: p_plan_tasks IN BOOLEAN,
282: p_quick_pick_flag IN VARCHAR2 DEFAULT 'N'
283: ) is
284: l_organization_id NUMBER := -9999;