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

Line 43: -- DEFAULT = FND_API.G_FALSE

39: -- p_api_version IN NUMBER (required)
40: -- API Version of this procedure
41: --
42: -- p_init_msg_level IN VARCHAR2 (optional)
43: -- DEFAULT = FND_API.G_FALSE
44: --
45: -- p_commit IN VARCHAR2 (optional)
46: -- DEFAULT = FND_API.G_FALSE
47: --

Line 46: -- DEFAULT = FND_API.G_FALSE

42: -- p_init_msg_level IN VARCHAR2 (optional)
43: -- DEFAULT = FND_API.G_FALSE
44: --
45: -- p_commit IN VARCHAR2 (optional)
46: -- DEFAULT = FND_API.G_FALSE
47: --
48: -- p_validation_level IN NUMBER (optional)
49: -- DEFAULT = FND_API.G_VALID_LEVEL_FULL,
50: --

Line 49: -- DEFAULT = FND_API.G_VALID_LEVEL_FULL,

45: -- p_commit IN VARCHAR2 (optional)
46: -- DEFAULT = FND_API.G_FALSE
47: --
48: -- p_validation_level IN NUMBER (optional)
49: -- DEFAULT = FND_API.G_VALID_LEVEL_FULL,
50: --
51: -- p_organization_id IN NUMBER (required)
52: -- ID OF the organization
53: --

Line 90: IF NOT FND_API.Compatible_API_Call(l_api_version

86: SAVEPOINT Get_Item_Cost;
87: --
88: /*
89: -- Standard Call to check for call compatibility
90: IF NOT FND_API.Compatible_API_Call(l_api_version
91: , p_api_version
92: , l_api_name
93: , G_PKG_NAME) THEN
94: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 94: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

90: IF NOT FND_API.Compatible_API_Call(l_api_version
91: , p_api_version
92: , l_api_name
93: , G_PKG_NAME) THEN
94: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
95: END IF;
96: --
97: -- Initialize message list if p_init_msg_list is set to true
98: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 98: IF FND_API.to_Boolean(p_init_msg_list) THEN

94: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
95: END IF;
96: --
97: -- Initialize message list if p_init_msg_list is set to true
98: IF FND_API.to_Boolean(p_init_msg_list) THEN
99: FND_MSG_PUB.initialize;
100: END IF;
101: --
102: */

Line 104: x_return_status := FND_API.G_RET_STS_SUCCESS;

100: END IF;
101: --
102: */
103: -- Initialisize API return status to access
104: x_return_status := FND_API.G_RET_STS_SUCCESS;
105: --
106: -- API body
107: --
108: -- We doing this for dynamic locator.

Line 136: IF FND_API.to_Boolean(p_commit) THEN

132:
133: -- END of API body
134: /*
135: -- Standard check of p_commit
136: IF FND_API.to_Boolean(p_commit) THEN
137: COMMIT;
138: END IF;
139: -- Standard call to get message count and if count is 1, get message info
140: FND_MSG_PUB.Count_And_Get

Line 145: WHEN FND_API.G_EXC_ERROR THEN

141: (p_count => x_msg_count
142: , p_data => x_msg_data);
143: */
144: EXCEPTION
145: WHEN FND_API.G_EXC_ERROR THEN
146: --
147: ROLLBACK TO Get_Item_Cost;
148: --
149: x_return_status := FND_API.G_RET_STS_ERROR;

Line 149: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 154: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

150: --
151: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
152: , p_data => x_msg_data);
153: --
154: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
155: --
156: ROLLBACK TO Get_Item_Cost;
157: --
158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 167: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

163: WHEN OTHERS THEN
164: --
165: ROLLBACK TO Get_Item_Cost;
166: --
167: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
168: --
169: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
170: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
171: END IF;

Line 212: -- DEFAULT = FND_API.G_FALSE,

208: -- p_api_version IN NUMBER (required)
209: -- API Version of this procedure
210: --
211: -- p_init_msg_list IN VARCHAR2 (optional)
212: -- DEFAULT = FND_API.G_FALSE,
213: --
214: -- p_commit IN VARCHAR2 (optional)
215: -- DEFAULT = FND_API.G_FALSE
216: --

Line 215: -- DEFAULT = FND_API.G_FALSE

211: -- p_init_msg_list IN VARCHAR2 (optional)
212: -- DEFAULT = FND_API.G_FALSE,
213: --
214: -- p_commit IN VARCHAR2 (optional)
215: -- DEFAULT = FND_API.G_FALSE
216: --
217: -- p_validation_level IN NUMBER (optional)
218: -- DEFAULT = FND_API.G_VALID_LEVEL_FULL,
219: --

Line 218: -- DEFAULT = FND_API.G_VALID_LEVEL_FULL,

214: -- p_commit IN VARCHAR2 (optional)
215: -- DEFAULT = FND_API.G_FALSE
216: --
217: -- p_validation_level IN NUMBER (optional)
218: -- DEFAULT = FND_API.G_VALID_LEVEL_FULL,
219: --
220: -- p_serial_number IN VARCHAR2 (required)
221: --
222: -- p_inventory_item_id IN NUMBER (required)

Line 299: IF NOT FND_API.Compatible_API_Call(l_api_version

295: SAVEPOINT Calculate_Systemquantity;
296: --
297: -- for Testing marked by suresh
298: -- Standard Call to check for call compatibility
299: IF NOT FND_API.Compatible_API_Call(l_api_version
300: , p_api_version
301: , l_api_name
302: , G_PKG_NAME) THEN
303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

299: IF NOT FND_API.Compatible_API_Call(l_api_version
300: , p_api_version
301: , l_api_name
302: , G_PKG_NAME) THEN
303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
304: END IF;
305:
306: --
307: IF (l_debug = 1) THEN

Line 311: IF FND_API.to_Boolean(p_init_msg_list) THEN

307: IF (l_debug = 1) THEN
308: MDEBUG( 'Begin of Calculate_Systemquantity2');
309: END IF;
310: -- Initialize message list if p_init_msg_list is set to true
311: IF FND_API.to_Boolean(p_init_msg_list) THEN
312: FND_MSG_PUB.initialize;
313: END IF;
314:
315: --

Line 320: x_return_status := FND_API.G_RET_STS_SUCCESS;

316: IF (l_debug = 1) THEN
317: MDEBUG( 'Begin of Calculate_Systemquantity3');
318: END IF;
319: -- Initialisize API return status to access
320: x_return_status := FND_API.G_RET_STS_SUCCESS;
321: x_system_quantity := NULL;
322: --
323: -- API body
324: --

Line 383: IF FND_API.to_Boolean(p_commit) THEN

379: END IF;
380: --
381: -- END of API body
382: -- Standard check of p_commit
383: IF FND_API.to_Boolean(p_commit) THEN
384: COMMIT;
385: END IF;
386: -- Standard call to get message count and if count is 1, get message info
387: FND_MSG_PUB.Count_And_Get

Line 391: WHEN FND_API.G_EXC_ERROR THEN

387: FND_MSG_PUB.Count_And_Get
388: (p_count => x_msg_count
389: , p_data => x_msg_data);
390: EXCEPTION
391: WHEN FND_API.G_EXC_ERROR THEN
392: --
393: ROLLBACK TO Calculate_Systemquantity;
394: --
395: IF (l_debug = 1) THEN

Line 398: x_return_status := FND_API.G_RET_STS_ERROR;

394: --
395: IF (l_debug = 1) THEN
396: MDEBUG( 'Calc.sys : Exception Error ' || sqlerrm);
397: END IF;
398: x_return_status := FND_API.G_RET_STS_ERROR;
399: --
400: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
401: , p_data => x_msg_data);
402: --

Line 403: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

399: --
400: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
401: , p_data => x_msg_data);
402: --
403: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
404: --
405: ROLLBACK TO Calculate_Systemquantity;
406: --
407: IF (l_debug = 1) THEN

Line 410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

406: --
407: IF (l_debug = 1) THEN
408: MDEBUG( 'Calc.sys : Unexp Exception Error: '|| sqlerrm);
409: END IF;
410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
411: --
412: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
413: , p_data => x_msg_data);
414: --

Line 422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

418: MDEBUG( 'Calc.sys : Others Exception Error ' || sqlerrm);
419: END IF;
420: ROLLBACK TO Calculate_Systemquantity;
421: --
422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
423: --
424: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
425: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
426: END IF;

Line 471: -- DEFAULT = FND_API.G_FALSE,

467: -- p_api_version IN NUMBER (required)
468: -- API Version of this procedure
469: --
470: -- p_init_msg_list IN VARCHAR2 (optional)
471: -- DEFAULT = FND_API.G_FALSE,
472: --
473: -- p_commit IN VARCHAR2 (optional)
474: -- DEFAULT = FND_API.G_FALSE
475: --

Line 474: -- DEFAULT = FND_API.G_FALSE

470: -- p_init_msg_list IN VARCHAR2 (optional)
471: -- DEFAULT = FND_API.G_FALSE,
472: --
473: -- p_commit IN VARCHAR2 (optional)
474: -- DEFAULT = FND_API.G_FALSE
475: --
476: -- p_validation_level IN NUMBER (optional)
477: -- DEFAULT = FND_API.G_VALID_LEVEL_FULL,
478: --

Line 477: -- DEFAULT = FND_API.G_VALID_LEVEL_FULL,

473: -- p_commit IN VARCHAR2 (optional)
474: -- DEFAULT = FND_API.G_FALSE
475: --
476: -- p_validation_level IN NUMBER (optional)
477: -- DEFAULT = FND_API.G_VALID_LEVEL_FULL,
478: --
479: -- p_serial_number IN VARCHAR2 (required)
480: --
481: -- p_inventory_item_id IN NUMBER (required)

Line 583: IF NOT fnd_api.compatible_api_call (l_api_version,

579:
580: --
581: -- for Testing marked by suresh
582: -- Standard Call to check for call compatibility
583: IF NOT fnd_api.compatible_api_call (l_api_version,
584: p_api_version,
585: l_api_name,
586: g_pkg_name
587: )

Line 589: RAISE fnd_api.g_exc_unexpected_error;

585: l_api_name,
586: g_pkg_name
587: )
588: THEN
589: RAISE fnd_api.g_exc_unexpected_error;
590: END IF;
591:
592: --
593: IF (l_debug = 1)

Line 599: IF fnd_api.to_boolean (p_init_msg_list)

595: mdebug ('Begin of Calculate_Systemquantity2');
596: END IF;
597:
598: -- Initialize message list if p_init_msg_list is set to true
599: IF fnd_api.to_boolean (p_init_msg_list)
600: THEN
601: fnd_msg_pub.initialize;
602: END IF;
603:

Line 611: x_return_status := fnd_api.g_ret_sts_success;

607: mdebug ('Begin of Calculate_Systemquantity3');
608: END IF;
609:
610: -- Initialisize API return status to access
611: x_return_status := fnd_api.g_ret_sts_success;
612: x_system_quantity := NULL;
613: x_sec_system_quantity := NULL;
614:
615: --

Line 705: IF fnd_api.to_boolean (p_commit)

701:
702: --
703: -- END of API body
704: -- Standard check of p_commit
705: IF fnd_api.to_boolean (p_commit)
706: THEN
707: COMMIT;
708: END IF;
709:

Line 714: WHEN fnd_api.g_exc_error

710: -- Standard call to get message count and if count is 1, get message info
711: fnd_msg_pub.count_and_get (p_count => x_msg_count,
712: p_data => x_msg_data);
713: EXCEPTION
714: WHEN fnd_api.g_exc_error
715: THEN
716: --
717: ROLLBACK TO calculate_systemquantity;
718:

Line 725: x_return_status := fnd_api.g_ret_sts_error;

721: THEN
722: mdebug ('Calc.sys : Exception Error ' || SQLERRM);
723: END IF;
724:
725: x_return_status := fnd_api.g_ret_sts_error;
726: --
727: fnd_msg_pub.count_and_get (p_count => x_msg_count,
728: p_data => x_msg_data
729: );

Line 731: WHEN fnd_api.g_exc_unexpected_error

727: fnd_msg_pub.count_and_get (p_count => x_msg_count,
728: p_data => x_msg_data
729: );
730: --
731: WHEN fnd_api.g_exc_unexpected_error
732: THEN
733: --
734: ROLLBACK TO calculate_systemquantity;
735:

Line 742: x_return_status := fnd_api.g_ret_sts_unexp_error;

738: THEN
739: mdebug ('Calc.sys : Unexp Exception Error: ' || SQLERRM);
740: END IF;
741:
742: x_return_status := fnd_api.g_ret_sts_unexp_error;
743: --
744: fnd_msg_pub.count_and_get (p_count => x_msg_count,
745: p_data => x_msg_data
746: );

Line 758: x_return_status := fnd_api.g_ret_sts_unexp_error;

754: END IF;
755:
756: ROLLBACK TO calculate_systemquantity;
757: --
758: x_return_status := fnd_api.g_ret_sts_unexp_error;
759:
760: --
761: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
762: THEN

Line 1163: IF NOT FND_API.Compatible_API_Call(l_api_version

1159: -- Standard start of API savepoint
1160: SAVEPOINT Get_LPN_Item_SysQty;
1161:
1162: -- Standard Call to check for call compatibility
1163: IF NOT FND_API.Compatible_API_Call(l_api_version
1164: , p_api_version
1165: , l_api_name
1166: , G_PKG_NAME) THEN
1167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1163: IF NOT FND_API.Compatible_API_Call(l_api_version
1164: , p_api_version
1165: , l_api_name
1166: , G_PKG_NAME) THEN
1167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1168: END IF;
1169:
1170: -- Initialisize API return status to access
1171: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1171: x_return_status := FND_API.G_RET_STS_SUCCESS;

1167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1168: END IF;
1169:
1170: -- Initialisize API return status to access
1171: x_return_status := FND_API.G_RET_STS_SUCCESS;
1172:
1173: -- Validate Inputs
1174: -- Validate Organization ID
1175: IF (p_organization_id IS NOT NULL) THEN

Line 1227: RAISE FND_API.G_EXC_ERROR;

1223: mdebug('invalid lot number');
1224: END IF;
1225: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_LOT');
1226: FND_MSG_PUB.ADD;
1227: RAISE FND_API.G_EXC_ERROR;
1228: END IF;
1229: END IF;
1230: END IF;
1231: END IF;

Line 1244: RAISE FND_API.G_EXC_ERROR;

1240: mdebug('invalid revision number');
1241: END IF;
1242: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_REVISION');
1243: FND_MSG_PUB.ADD;
1244: RAISE FND_API.G_EXC_ERROR;
1245: END IF;
1246: END IF;
1247: END IF;
1248: END IF;

Line 1258: RAISE FND_API.G_EXC_ERROR;

1254: l_sub, l_lot, l_locator, p_revision);
1255: IF (l_result = INV_Validate.F) THEN
1256: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_SERIAL');
1257: FND_MSG_PUB.ADD;
1258: RAISE FND_API.G_EXC_ERROR;
1259: END IF;
1260: END IF;
1261: */
1262:

Line 1328: x_return_status := FND_API.G_RET_STS_ERROR;

1324:
1325: EXCEPTION
1326: WHEN e_Invalid_Inputs THEN
1327: ROLLBACK TO Get_LPN_Item_SysQty;
1328: x_return_status := FND_API.G_RET_STS_ERROR;
1329: FND_MSG_PUB.Count_And_Get
1330: ( p_count => x_msg_count,
1331: p_data => x_msg_data
1332: );

Line 1382: IF NOT fnd_api.compatible_api_call (l_api_version

1378: -- Standard start of API savepoint
1379: SAVEPOINT get_lpn_item_sysqty;
1380:
1381: -- Standard Call to check for call compatibility
1382: IF NOT fnd_api.compatible_api_call (l_api_version
1383: , p_api_version
1384: , l_api_name
1385: , g_pkg_name
1386: ) THEN

Line 1387: RAISE fnd_api.g_exc_unexpected_error;

1383: , p_api_version
1384: , l_api_name
1385: , g_pkg_name
1386: ) THEN
1387: RAISE fnd_api.g_exc_unexpected_error;
1388: END IF;
1389:
1390: -- Initialisize API return status to access
1391: x_return_status := fnd_api.g_ret_sts_success;

Line 1391: x_return_status := fnd_api.g_ret_sts_success;

1387: RAISE fnd_api.g_exc_unexpected_error;
1388: END IF;
1389:
1390: -- Initialisize API return status to access
1391: x_return_status := fnd_api.g_ret_sts_success;
1392:
1393: -- Validate Inputs
1394: -- Validate Organization ID
1395: IF (p_organization_id IS NOT NULL) THEN

Line 1520: x_return_status := fnd_api.g_ret_sts_error;

1516: END IF;
1517: EXCEPTION
1518: WHEN e_invalid_inputs THEN
1519: ROLLBACK TO get_lpn_item_sysqty;
1520: x_return_status := fnd_api.g_ret_sts_error;
1521: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1522:
1523: IF (l_debug = 1) THEN
1524: mdebug ('Invalid Inputs');