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

Line 158: -- with each other; it returs FND_API.G_RET_STS_SUCCESS if the

154: -- PARAMETERS: p_data_set_name data_set_name
155: -- x_return_status return status
156: -- COMMENT : this procedures checks that the data set name is unique and
157: -- reserves it to prevent parallel requests from interfering
158: -- with each other; it returs FND_API.G_RET_STS_SUCCESS if the
159: -- reservation is successful; FND_API.G_RET_STS_ERROR otherwise;
160: -- the reservation is achieved by:
161: -- - locking the table
162: -- - checking for the existance of rows with the same data set

Line 159: -- reservation is successful; FND_API.G_RET_STS_ERROR otherwise;

155: -- x_return_status return status
156: -- COMMENT : this procedures checks that the data set name is unique and
157: -- reserves it to prevent parallel requests from interfering
158: -- with each other; it returs FND_API.G_RET_STS_SUCCESS if the
159: -- reservation is successful; FND_API.G_RET_STS_ERROR otherwise;
160: -- the reservation is achieved by:
161: -- - locking the table
162: -- - checking for the existance of rows with the same data set
163: -- name

Line 164: -- - if a row exists, FND_API.G_RET_STS_ERROR is returned

160: -- the reservation is achieved by:
161: -- - locking the table
162: -- - checking for the existance of rows with the same data set
163: -- name
164: -- - if a row exists, FND_API.G_RET_STS_ERROR is returned
165: -- - otherwise, a dummy row is created and committed (which
166: -- releases the lock
167: -- the dummy row created by the reservation needs to be removed
168: -- at the end of the process by calling Release_Data_Set_Name.

Line 190: x_return_status := FND_API.G_RET_STS_ERROR;

186:
187: IF Data_Set_Exists(p_data_set_name) THEN
188:
189: ROLLBACK;
190: x_return_status := FND_API.G_RET_STS_ERROR;
191:
192: ELSE
193:
194: MTL_MGD_INV_POSITIONS_PKG.Insert_Row

Line 216: x_return_status := FND_API.G_RET_STS_SUCCESS;

212: , p_org_delta_qty => 0
213: , p_org_end_on_hand_qty => 0
214: );
215: COMMIT;
216: x_return_status := FND_API.G_RET_STS_SUCCESS;
217:
218: END IF;
219:
220: IF G_DEBUG = 'Y' THEN

Line 1109: ( p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

1105: -- COMMENT : Inventory Position Build processor
1106: -- PRE-COND : all organization in hierarchy share same item master
1107: --========================================================================
1108: PROCEDURE Build
1109: ( p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
1110: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1111: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1112: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1113: , p_data_set_name IN VARCHAR2

Line 1145: IF FND_API.to_Boolean(p_init_msg_list)

1141: );
1142: END IF;
1143:
1144: -- Initialize message stack if required
1145: IF FND_API.to_Boolean(p_init_msg_list)
1146: THEN
1147: FND_MSG_PUB.initialize;
1148: END IF;
1149:

Line 1155: IF NOT l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1151: Reserve_Data_Set_Name
1152: ( p_data_set_name => p_data_set_name
1153: , x_return_status => l_return_status
1154: );
1155: IF NOT l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1156: RAISE l_dupl_data_set_name;
1157: END IF;
1158:
1159: -- Get context

Line 1214: x_return_status := FND_API.G_RET_STS_SUCCESS;

1210: IF NOT Data_Set_Exists(p_data_set_name => p_data_set_name) THEN
1211: RAISE l_empty_data_set;
1212: END IF;
1213:
1214: x_return_status := FND_API.G_RET_STS_SUCCESS;
1215: -- Get message count and data
1216: FND_MSG_PUB.Count_And_Get
1217: ( p_encoded => FND_API.G_FALSE
1218: , p_count => x_msg_count

Line 1217: ( p_encoded => FND_API.G_FALSE

1213:
1214: x_return_status := FND_API.G_RET_STS_SUCCESS;
1215: -- Get message count and data
1216: FND_MSG_PUB.Count_And_Get
1217: ( p_encoded => FND_API.G_FALSE
1218: , p_count => x_msg_count
1219: , p_data => x_msg_data
1220: );
1221:

Line 1233: x_return_status := FND_API.G_RET_STS_ERROR;

1229:
1230: EXCEPTION
1231:
1232: WHEN l_empty_data_set THEN
1233: x_return_status := FND_API.G_RET_STS_ERROR;
1234: -- generate proper error message
1235: FND_MESSAGE.set_name
1236: ( application => 'INV'
1237: , name => 'INV_MGD_IPBD_EMPTY_DATASET'

Line 1241: ( p_encoded => FND_API.G_FALSE

1237: , name => 'INV_MGD_IPBD_EMPTY_DATASET'
1238: );
1239: FND_MSG_PUB.Add;
1240: FND_MSG_PUB.Count_And_Get
1241: ( p_encoded => FND_API.G_FALSE
1242: , p_count => x_msg_count
1243: , p_data => x_msg_data
1244: );
1245:

Line 1247: x_return_status := FND_API.G_RET_STS_ERROR;

1243: , p_data => x_msg_data
1244: );
1245:
1246: WHEN l_dupl_data_set_name THEN
1247: x_return_status := FND_API.G_RET_STS_ERROR;
1248: -- generate proper error message
1249: FND_MESSAGE.set_name
1250: ( application => 'INV'
1251: , name => 'INV_MGD_IPBD_DUPL_DATASET'

Line 1255: ( p_encoded => FND_API.G_FALSE

1251: , name => 'INV_MGD_IPBD_DUPL_DATASET'
1252: );
1253: FND_MSG_PUB.Add;
1254: FND_MSG_PUB.Count_And_Get
1255: ( p_encoded => FND_API.G_FALSE
1256: , p_count => x_msg_count
1257: , p_data => x_msg_data
1258: );
1259:

Line 1260: WHEN FND_API.G_EXC_ERROR THEN

1256: , p_count => x_msg_count
1257: , p_data => x_msg_data
1258: );
1259:
1260: WHEN FND_API.G_EXC_ERROR THEN
1261: x_return_status := FND_API.G_RET_STS_ERROR;
1262: -- Get message count and data
1263: FND_MSG_PUB.Count_And_Get
1264: ( p_encoded => FND_API.G_FALSE

Line 1261: x_return_status := FND_API.G_RET_STS_ERROR;

1257: , p_data => x_msg_data
1258: );
1259:
1260: WHEN FND_API.G_EXC_ERROR THEN
1261: x_return_status := FND_API.G_RET_STS_ERROR;
1262: -- Get message count and data
1263: FND_MSG_PUB.Count_And_Get
1264: ( p_encoded => FND_API.G_FALSE
1265: , p_count => x_msg_count

Line 1264: ( p_encoded => FND_API.G_FALSE

1260: WHEN FND_API.G_EXC_ERROR THEN
1261: x_return_status := FND_API.G_RET_STS_ERROR;
1262: -- Get message count and data
1263: FND_MSG_PUB.Count_And_Get
1264: ( p_encoded => FND_API.G_FALSE
1265: , p_count => x_msg_count
1266: , p_data => x_msg_data
1267: );
1268:

Line 1269: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1265: , p_count => x_msg_count
1266: , p_data => x_msg_data
1267: );
1268:
1269: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1271: -- Get message count and data
1272: FND_MSG_PUB.Count_And_Get
1273: ( p_encoded => FND_API.G_FALSE

Line 1270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1266: , p_data => x_msg_data
1267: );
1268:
1269: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1271: -- Get message count and data
1272: FND_MSG_PUB.Count_And_Get
1273: ( p_encoded => FND_API.G_FALSE
1274: , p_count => x_msg_count

Line 1273: ( p_encoded => FND_API.G_FALSE

1269: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1271: -- Get message count and data
1272: FND_MSG_PUB.Count_And_Get
1273: ( p_encoded => FND_API.G_FALSE
1274: , p_count => x_msg_count
1275: , p_data => x_msg_data
1276: );
1277:

Line 1279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1275: , p_data => x_msg_data
1276: );
1277:
1278: WHEN OTHERS THEN
1279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1280: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1281: THEN
1282: FND_MSG_PUB.Add_Exc_Msg
1283: ( G_PKG_NAME

Line 1289: ( p_encoded => FND_API.G_FALSE

1285: );
1286: END IF;
1287: -- Get message count and data
1288: FND_MSG_PUB.Count_And_Get
1289: ( p_encoded => FND_API.G_FALSE
1290: , p_count => x_msg_count
1291: , p_data => x_msg_data
1292: );
1293:

Line 1311: ( p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

1307: -- COMMENT : Inventory Position Purge concurrent program; p_purge_all takes
1308: -- priority over other parameters
1309: --========================================================================
1310: PROCEDURE Purge
1311: ( p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
1312: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1313: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1314: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1315: , p_purge_all IN VARCHAR2

Line 1347: x_return_status := FND_API.G_RET_STS_SUCCESS;

1343: );
1344:
1345: END IF;
1346:
1347: x_return_status := FND_API.G_RET_STS_SUCCESS;
1348: -- Get message count and data
1349: FND_MSG_PUB.Count_And_Get
1350: ( p_encoded => FND_API.G_FALSE
1351: , p_count => x_msg_count

Line 1350: ( p_encoded => FND_API.G_FALSE

1346:
1347: x_return_status := FND_API.G_RET_STS_SUCCESS;
1348: -- Get message count and data
1349: FND_MSG_PUB.Count_And_Get
1350: ( p_encoded => FND_API.G_FALSE
1351: , p_count => x_msg_count
1352: , p_data => x_msg_data
1353: );
1354:

Line 1364: WHEN FND_API.G_EXC_ERROR THEN

1360: END IF;
1361:
1362: EXCEPTION
1363:
1364: WHEN FND_API.G_EXC_ERROR THEN
1365: x_return_status := FND_API.G_RET_STS_ERROR;
1366: -- Get message count and data
1367: FND_MSG_PUB.Count_And_Get
1368: ( p_encoded => FND_API.G_FALSE

Line 1365: x_return_status := FND_API.G_RET_STS_ERROR;

1361:
1362: EXCEPTION
1363:
1364: WHEN FND_API.G_EXC_ERROR THEN
1365: x_return_status := FND_API.G_RET_STS_ERROR;
1366: -- Get message count and data
1367: FND_MSG_PUB.Count_And_Get
1368: ( p_encoded => FND_API.G_FALSE
1369: , p_count => x_msg_count

Line 1368: ( p_encoded => FND_API.G_FALSE

1364: WHEN FND_API.G_EXC_ERROR THEN
1365: x_return_status := FND_API.G_RET_STS_ERROR;
1366: -- Get message count and data
1367: FND_MSG_PUB.Count_And_Get
1368: ( p_encoded => FND_API.G_FALSE
1369: , p_count => x_msg_count
1370: , p_data => x_msg_data
1371: );
1372:

Line 1373: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1369: , p_count => x_msg_count
1370: , p_data => x_msg_data
1371: );
1372:
1373: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1374: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1375: -- Get message count and data
1376: FND_MSG_PUB.Count_And_Get
1377: ( p_encoded => FND_API.G_FALSE

Line 1374: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1370: , p_data => x_msg_data
1371: );
1372:
1373: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1374: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1375: -- Get message count and data
1376: FND_MSG_PUB.Count_And_Get
1377: ( p_encoded => FND_API.G_FALSE
1378: , p_count => x_msg_count

Line 1377: ( p_encoded => FND_API.G_FALSE

1373: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1374: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1375: -- Get message count and data
1376: FND_MSG_PUB.Count_And_Get
1377: ( p_encoded => FND_API.G_FALSE
1378: , p_count => x_msg_count
1379: , p_data => x_msg_data
1380: );
1381:

Line 1383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1379: , p_data => x_msg_data
1380: );
1381:
1382: WHEN OTHERS THEN
1383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1384: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1385: THEN
1386: FND_MSG_PUB.Add_Exc_Msg
1387: ( G_PKG_NAME

Line 1393: ( p_encoded => FND_API.G_FALSE

1389: );
1390: END IF;
1391: -- Get message count and data
1392: FND_MSG_PUB.Count_And_Get
1393: ( p_encoded => FND_API.G_FALSE
1394: , p_count => x_msg_count
1395: , p_data => x_msg_data
1396: );
1397: