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

Line 26: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

22:
23: ---------------------------------------------------------------
24: -- API Return Status . --
25: ---------------------------------------------------------------
26: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
27: G_RET_STS_WARNING CONSTANT VARCHAR2(1) := 'W';
28: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
29: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
30:

Line 28: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

24: -- API Return Status . --
25: ---------------------------------------------------------------
26: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
27: G_RET_STS_WARNING CONSTANT VARCHAR2(1) := 'W';
28: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
29: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
30:
31: ---------------------------------------------------------------
32: -- Used for Error Reporting. --

Line 29: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

25: ---------------------------------------------------------------
26: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
27: G_RET_STS_WARNING CONSTANT VARCHAR2(1) := 'W';
28: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
29: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
30:
31: ---------------------------------------------------------------
32: -- Used for Error Reporting. --
33: ---------------------------------------------------------------

Line 298: IF (G_DEBUG = 1 OR FND_API.to_Boolean(p_debug)) THEN

294: BEGIN
295: ----------------------------------------------------------------
296: -- Open the Debug Log Session, only if Profile is set to TRUE --
297: ----------------------------------------------------------------
298: IF (G_DEBUG = 1 OR FND_API.to_Boolean(p_debug)) THEN
299:
300:
301: G_OUTPUT_DIR := p_output_dir ;
302: G_ERROR_FILE_NAME := p_file_name ;

Line 435: RAISE FND_API.G_EXC_ERROR;

431:
432: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
433: FND_MESSAGE.Set_Token('OBJECT_NAME', 'GetChangeId:'|| 'no change Id');
434: FND_MSG_PUB.Add;
435: RAISE FND_API.G_EXC_ERROR;
436:
437: END IF ;
438:
439: RETURN l_change_id ;

Line 1094: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE

1090:
1091:
1092: PROCEDURE impl_item_changes
1093: ( p_api_version IN NUMBER
1094: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
1095: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
1096: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
1097: , x_return_status OUT NOCOPY VARCHAR2
1098: , x_msg_count OUT NOCOPY NUMBER

Line 1095: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE

1091:
1092: PROCEDURE impl_item_changes
1093: ( p_api_version IN NUMBER
1094: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
1095: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
1096: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
1097: , x_return_status OUT NOCOPY VARCHAR2
1098: , x_msg_count OUT NOCOPY NUMBER
1099: , x_msg_data OUT NOCOPY VARCHAR2

Line 1096: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL

1092: PROCEDURE impl_item_changes
1093: ( p_api_version IN NUMBER
1094: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
1095: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
1096: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
1097: , x_return_status OUT NOCOPY VARCHAR2
1098: , x_msg_count OUT NOCOPY NUMBER
1099: , x_msg_data OUT NOCOPY VARCHAR2
1100: , p_api_caller IN VARCHAR2 := NULL

Line 1101: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE

1097: , x_return_status OUT NOCOPY VARCHAR2
1098: , x_msg_count OUT NOCOPY NUMBER
1099: , x_msg_data OUT NOCOPY VARCHAR2
1100: , p_api_caller IN VARCHAR2 := NULL
1101: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE
1102: , p_output_dir IN VARCHAR2 := NULL
1103: , p_debug_filename IN VARCHAR2 := NULL
1104: , p_change_id IN NUMBER := NULL
1105: , p_change_line_id IN NUMBER

Line 1141: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

1137:
1138:
1139: BEGIN
1140: -- Standard call to check for call compatibility.
1141: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1142: p_api_version ,
1143: l_api_name ,
1144: G_PKG_NAME )
1145: THEN

Line 1146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1142: p_api_version ,
1143: l_api_name ,
1144: G_PKG_NAME )
1145: THEN
1146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1147: END IF;
1148:
1149: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
1150: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;

Line 1149: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;

1145: THEN
1146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1147: END IF;
1148:
1149: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
1150: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
1151: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
1152:
1153:

Line 1150: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;

1146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1147: END IF;
1148:
1149: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
1150: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
1151: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
1152:
1153:
1154: IF FND_API.To_Boolean( l_commit ) THEN

Line 1151: l_commit := NVL(p_commit,FND_API.G_FALSE) ;

1147: END IF;
1148:
1149: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
1150: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
1151: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
1152:
1153:
1154: IF FND_API.To_Boolean( l_commit ) THEN
1155: SAVEPOINT IMPL_ITEM_CHANGES;

Line 1154: IF FND_API.To_Boolean( l_commit ) THEN

1150: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
1151: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
1152:
1153:
1154: IF FND_API.To_Boolean( l_commit ) THEN
1155: SAVEPOINT IMPL_ITEM_CHANGES;
1156: END IF;
1157:
1158:

Line 1160: IF FND_API.to_Boolean( l_init_msg_list ) THEN

1156: END IF;
1157:
1158:
1159: -- Initialize message list if p_init_msg_list is set to TRUE.
1160: IF FND_API.to_Boolean( l_init_msg_list ) THEN
1161: FND_MSG_PUB.initialize;
1162: END IF;
1163:
1164: -- Open Debug Session by a give param or profile option.

Line 1215: ,p_commit => FND_API.G_FALSE

1211:
1212: impl_rev_item_user_attr_chgs
1213: (
1214: p_api_version => 1.0
1215: ,p_commit => FND_API.G_FALSE
1216: ,x_return_status => l_return_status
1217: ,x_msg_count => l_msg_count
1218: ,x_msg_data => l_msg_data
1219: ,p_change_id => l_change_id

Line 1227: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

1223:
1224: Write_Debug('After Calling impl_rev_item_user_attr_chgs, Return Status: ' || l_return_status);
1225:
1226:
1227: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
1228: THEN
1229:
1230: x_return_status := l_return_status;
1231: x_msg_count := l_msg_count;

Line 1237: RAISE FND_API.G_EXC_ERROR;

1233: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
1234: FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_IMPL_ITEM_CHANGES_PKG.impl_rev_item_user_attr_chgs');
1235: FND_MSG_PUB.Add;
1236:
1237: RAISE FND_API.G_EXC_ERROR;
1238:
1239: END IF;
1240:
1241:

Line 1249: ,p_commit => FND_API.G_FALSE

1245:
1246: impl_rev_item_attr_changes
1247: (
1248: p_api_version => 1.0
1249: ,p_commit => FND_API.G_FALSE
1250: ,x_return_status => l_return_status
1251: ,x_msg_count => l_msg_count
1252: ,x_msg_data => l_msg_data
1253: ,p_change_id => l_change_id

Line 1262: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

1258: Write_Debug('After Calling impl_rev_item_attr_changes, Return Status: ' || l_return_status);
1259:
1260:
1261:
1262: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
1263: THEN
1264:
1265: x_return_status := l_return_status;
1266: x_msg_count := l_msg_count;

Line 1268: RAISE FND_API.G_EXC_ERROR;

1264:
1265: x_return_status := l_return_status;
1266: x_msg_count := l_msg_count;
1267: x_msg_data := l_msg_data;
1268: RAISE FND_API.G_EXC_ERROR;
1269:
1270: END IF;
1271:
1272: impl_rev_item_gdsn_attr_chgs

Line 1275: ,p_commit => FND_API.G_FALSE

1271:
1272: impl_rev_item_gdsn_attr_chgs
1273: (
1274: p_api_version => 1.0
1275: ,p_commit => FND_API.G_FALSE
1276: ,x_return_status => l_return_status
1277: ,x_msg_count => l_msg_count
1278: ,x_msg_data => l_msg_data
1279: ,p_change_id => l_change_id

Line 1287: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

1283:
1284: Write_Debug('After Calling impl_rev_item_gdsn_attr_chgs, Return Status: ' || l_return_status);
1285:
1286:
1287: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
1288: THEN
1289:
1290: x_return_status := l_return_status;
1291: x_msg_count := l_msg_count;

Line 1297: RAISE FND_API.G_EXC_ERROR;

1293: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
1294: FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_IMPL_ITEM_CHANGES_PKG.impl_rev_item_gdsn_attr_chgs');
1295: FND_MSG_PUB.Add;
1296:
1297: RAISE FND_API.G_EXC_ERROR;
1298:
1299: END IF;
1300:
1301:

Line 1308: ,p_commit => FND_API.G_FALSE

1304:
1305: impl_rev_item_aml_changes
1306: (
1307: p_api_version => 1.0
1308: ,p_commit => FND_API.G_FALSE
1309: ,x_return_status => l_return_status
1310: ,x_msg_count => l_msg_count
1311: ,x_msg_data => l_msg_data
1312: ,p_change_id => l_change_id

Line 1320: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

1316:
1317: Write_Debug('After calling impl_rev_item_aml_changes, Return Status: ' || l_return_status);
1318:
1319:
1320: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
1321: THEN
1322:
1323: x_return_status := l_return_status;
1324: x_msg_count := l_msg_count;

Line 1331: RAISE FND_API.G_EXC_ERROR;

1327: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
1328: FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_IMPL_ITEM_CHANGES_PKG.impl_rev_item_aml_changes');
1329: FND_MSG_PUB.Add;
1330:
1331: RAISE FND_API.G_EXC_ERROR;
1332:
1333: END IF;
1334:
1335:

Line 1342: IF FND_API.To_Boolean( l_commit ) THEN

1338: -- End of API body.
1339:
1340:
1341: -- Standard check of p_commit.
1342: IF FND_API.To_Boolean( l_commit ) THEN
1343:
1344: Write_Debug('Commit impl_item_changes. . . ' );
1345:
1346: COMMIT WORK;

Line 1374: WHEN FND_API.G_EXC_ERROR THEN

1370: Close_Debug_Session;
1371:
1372:
1373: EXCEPTION
1374: WHEN FND_API.G_EXC_ERROR THEN
1375: Write_Debug('When G_EXC_ERROR Exception in impl_item_changes');
1376:
1377: x_return_status := G_RET_STS_ERROR ;
1378:

Line 1380: IF FND_API.To_Boolean( l_commit ) THEN

1376:
1377: x_return_status := G_RET_STS_ERROR ;
1378:
1379:
1380: IF FND_API.To_Boolean( l_commit ) THEN
1381: Write_Debug('ROLLBACK Impl Item Changes to IMPL_ITEM_CHANGES. . ');
1382: ROLLBACK TO IMPL_ITEM_CHANGES;
1383: END IF;
1384:

Line 1406: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1402: -- Close Error Handler Debug Session.
1403: -----------------------------------------------------
1404: Close_Debug_Session;
1405:
1406: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1407:
1408: Write_Debug('When G_EXC_UNEXPECTED_ERROR Exception in impl_item_changes');
1409: x_return_status := G_RET_STS_UNEXP_ERROR ;
1410:

Line 1411: IF FND_API.To_Boolean( l_commit ) THEN

1407:
1408: Write_Debug('When G_EXC_UNEXPECTED_ERROR Exception in impl_item_changes');
1409: x_return_status := G_RET_STS_UNEXP_ERROR ;
1410:
1411: IF FND_API.To_Boolean( l_commit ) THEN
1412: Write_Debug('ROLLBACK Impl Item Changes to IMPL_ITEM_CHANGES. . ');
1413: ROLLBACK TO IMPL_ITEM_CHANGES;
1414: END IF;
1415:

Line 1438: IF FND_API.To_Boolean( l_commit ) THEN

1434: WHEN OTHERS THEN
1435: Write_Debug('When OTHERS Exception in impl_item_changes');
1436: x_return_status := G_RET_STS_UNEXP_ERROR ;
1437:
1438: IF FND_API.To_Boolean( l_commit ) THEN
1439: Write_Debug('ROLLBACK Impl Item Changes to IMPL_ITEM_CHANGES. . ');
1440: ROLLBACK TO IMPL_ITEM_CHANGES;
1441: END IF;
1442:

Line 1522: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE

1518:
1519:
1520: PROCEDURE impl_rev_item_attr_changes
1521: ( p_api_version IN NUMBER
1522: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
1523: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
1524: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
1525: , x_return_status OUT NOCOPY VARCHAR2
1526: , x_msg_count OUT NOCOPY NUMBER

Line 1523: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE

1519:
1520: PROCEDURE impl_rev_item_attr_changes
1521: ( p_api_version IN NUMBER
1522: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
1523: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
1524: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
1525: , x_return_status OUT NOCOPY VARCHAR2
1526: , x_msg_count OUT NOCOPY NUMBER
1527: , x_msg_data OUT NOCOPY VARCHAR2

Line 1524: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL

1520: PROCEDURE impl_rev_item_attr_changes
1521: ( p_api_version IN NUMBER
1522: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
1523: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
1524: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
1525: , x_return_status OUT NOCOPY VARCHAR2
1526: , x_msg_count OUT NOCOPY NUMBER
1527: , x_msg_data OUT NOCOPY VARCHAR2
1528: , p_api_caller IN VARCHAR2 := NULL

Line 1529: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE

1525: , x_return_status OUT NOCOPY VARCHAR2
1526: , x_msg_count OUT NOCOPY NUMBER
1527: , x_msg_data OUT NOCOPY VARCHAR2
1528: , p_api_caller IN VARCHAR2 := NULL
1529: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE
1530: , p_output_dir IN VARCHAR2 := NULL
1531: , p_debug_filename IN VARCHAR2 := NULL
1532: , p_change_id IN NUMBER := NULL
1533: , p_change_line_id IN NUMBER

Line 1625: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

1621:
1622: BEGIN
1623:
1624: -- Standard call to check for call compatibility.
1625: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1626: p_api_version ,
1627: l_api_name ,
1628: G_PKG_NAME )
1629: THEN

Line 1630: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1626: p_api_version ,
1627: l_api_name ,
1628: G_PKG_NAME )
1629: THEN
1630: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1631: END IF;
1632:
1633: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
1634: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;

Line 1633: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;

1629: THEN
1630: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1631: END IF;
1632:
1633: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
1634: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
1635: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
1636:
1637: --IF FND_API.To_Boolean( l_commit ) THEN

Line 1634: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;

1630: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1631: END IF;
1632:
1633: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
1634: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
1635: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
1636:
1637: --IF FND_API.To_Boolean( l_commit ) THEN
1638: -- Standard Start of API savepoint

Line 1635: l_commit := NVL(p_commit,FND_API.G_FALSE) ;

1631: END IF;
1632:
1633: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
1634: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
1635: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
1636:
1637: --IF FND_API.To_Boolean( l_commit ) THEN
1638: -- Standard Start of API savepoint
1639: SAVEPOINT IMPL_REV_ITEM_ATTR_CHGS;

Line 1637: --IF FND_API.To_Boolean( l_commit ) THEN

1633: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
1634: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
1635: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
1636:
1637: --IF FND_API.To_Boolean( l_commit ) THEN
1638: -- Standard Start of API savepoint
1639: SAVEPOINT IMPL_REV_ITEM_ATTR_CHGS;
1640: --END IF;
1641:

Line 1644: IF FND_API.to_Boolean( l_init_msg_list ) THEN

1640: --END IF;
1641:
1642:
1643: -- Initialize message list if p_init_msg_list is set to TRUE.
1644: IF FND_API.to_Boolean( l_init_msg_list ) THEN
1645: FND_MSG_PUB.initialize;
1646: END IF;
1647:
1648: -- Open Debug Session by a give param or profile option.

Line 2148: RAISE FND_API.G_EXC_ERROR;

2144: -- We don't support this in R12
2145: FND_MESSAGE.Set_Name('ENG','ENG_IMPL_INVALID_ACD_TYPE');
2146: FND_MESSAGE.Set_Token('ACD_TYPE', l_current_acd_type);
2147: FND_MSG_PUB.Add;
2148: RAISE FND_API.G_EXC_ERROR;
2149:
2150: END IF;
2151:
2152:

Line 2247: ' ,p_init_msg_list => FND_API.G_FALSE ' ||

2243: ' BEGIN ' ||
2244: ' EGO_ITEM_PUB.Process_Item ' ||
2245: ' ( ' ||
2246: ' p_api_version => 1' ||
2247: ' ,p_init_msg_list => FND_API.G_FALSE ' ||
2248: ' ,p_commit => FND_API.G_FALSE ' ||
2249: ' ,p_transaction_type => :l_mode_for_current_row ' ||
2250: -- ' ,p_Language_Code => :l_current_row_language ' ||
2251: ' ,p_inventory_item_id => :l_inventory_item_id ' ||

Line 2248: ' ,p_commit => FND_API.G_FALSE ' ||

2244: ' EGO_ITEM_PUB.Process_Item ' ||
2245: ' ( ' ||
2246: ' p_api_version => 1' ||
2247: ' ,p_init_msg_list => FND_API.G_FALSE ' ||
2248: ' ,p_commit => FND_API.G_FALSE ' ||
2249: ' ,p_transaction_type => :l_mode_for_current_row ' ||
2250: -- ' ,p_Language_Code => :l_current_row_language ' ||
2251: ' ,p_inventory_item_id => :l_inventory_item_id ' ||
2252: ' ,p_item_number => :l_item_number ' ||

Line 2370: WHEN FND_API.G_EXC_ERROR THEN

2366: Write_Debug('---------------------------------- ' );
2367:
2368: EXCEPTION
2369:
2370: WHEN FND_API.G_EXC_ERROR THEN
2371: x_return_status := l_return_status ;
2372: RAISE FND_API.G_EXC_ERROR;
2373:
2374: WHEN OTHERS THEN

Line 2372: RAISE FND_API.G_EXC_ERROR;

2368: EXCEPTION
2369:
2370: WHEN FND_API.G_EXC_ERROR THEN
2371: x_return_status := l_return_status ;
2372: RAISE FND_API.G_EXC_ERROR;
2373:
2374: WHEN OTHERS THEN
2375:
2376: FND_MSG_PUB.Add_Exc_Msg

Line 2388: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2384: FND_MESSAGE.Set_Token('OBJECT_NAME', 'EGO_ITEM_PUB.Process_Item');
2385: FND_MSG_PUB.Add;
2386:
2387: Write_Debug('When Others Exception while calling EGO_ITEM_PUB.Process_Item' || Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240));
2388: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2389:
2390: END ;
2391:
2392:

Line 2393: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

2389:
2390: END ;
2391:
2392:
2393: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
2394: THEN
2395:
2396: -- Get message list from Error_Hanlder
2397: Error_Handler.Get_Message_List(x_Message_List => l_message_list ) ;

Line 2434: RAISE FND_API.G_EXC_ERROR ;

2430: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
2431: FND_MESSAGE.Set_Token('OBJECT_NAME', 'EGO_ITEM_PUB.Process_Item');
2432: FND_MSG_PUB.Add;
2433:
2434: RAISE FND_API.G_EXC_ERROR ;
2435:
2436: END IF;
2437:
2438: END IF; -- l_mode_for_current_row <> 'SKIP'

Line 2472: IF FND_API.To_Boolean( l_commit ) THEN

2468: -- End of API body.
2469:
2470:
2471: -- Standard check of p_commit.
2472: IF FND_API.To_Boolean( l_commit ) THEN
2473:
2474: Write_Debug('Commit Item Attribute Change Implementation ');
2475:
2476: COMMIT WORK;

Line 2491: IF FND_API.to_Boolean(p_debug)

2487: -- Close Error Handler Debug Session.
2488: -----------------------------------------------------
2489: -- Close debug session only explicitly open the debug session for
2490: -- this API.
2491: IF FND_API.to_Boolean(p_debug)
2492: THEN
2493: Close_Debug_Session;
2494: END IF ;
2495:

Line 2498: WHEN FND_API.G_EXC_ERROR THEN

2494: END IF ;
2495:
2496:
2497: EXCEPTION
2498: WHEN FND_API.G_EXC_ERROR THEN
2499: Write_Debug('When G_EXC_ERROR Exception in impl_rev_item_attr_changes');
2500:
2501: x_return_status := G_RET_STS_ERROR ;
2502:

Line 2503: --IF FND_API.To_Boolean( l_commit ) THEN --commentted by bug 13680409, history record will be insert even process_item failed if not rollback

2499: Write_Debug('When G_EXC_ERROR Exception in impl_rev_item_attr_changes');
2500:
2501: x_return_status := G_RET_STS_ERROR ;
2502:
2503: --IF FND_API.To_Boolean( l_commit ) THEN --commentted by bug 13680409, history record will be insert even process_item failed if not rollback
2504: Write_Debug('Rollback to IMPL_REV_ITEM_ATTR_CHGS Item Attribute Change Implementation ');
2505: ROLLBACK TO IMPL_REV_ITEM_ATTR_CHGS;
2506: --END IF;
2507:

Line 2523: IF FND_API.to_Boolean(p_debug)

2519: -- Close Error Handler Debug Session.
2520: -----------------------------------------------------
2521: -- Close debug session only explicitly open the debug session for
2522: -- this API.
2523: IF FND_API.to_Boolean(p_debug)
2524: THEN
2525: Close_Debug_Session;
2526: END IF ;
2527:

Line 2528: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2524: THEN
2525: Close_Debug_Session;
2526: END IF ;
2527:
2528: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2529: Write_Debug('When G_EXC_UNEXPECTED_ERROR Exception in impl_rev_item_attr_changes');
2530:
2531: x_return_status := G_RET_STS_UNEXP_ERROR ;
2532:

Line 2533: --IF FND_API.To_Boolean( l_commit ) THEN --commentted by bug 13680409, history record will be insert even process_item failed if not rollback

2529: Write_Debug('When G_EXC_UNEXPECTED_ERROR Exception in impl_rev_item_attr_changes');
2530:
2531: x_return_status := G_RET_STS_UNEXP_ERROR ;
2532:
2533: --IF FND_API.To_Boolean( l_commit ) THEN --commentted by bug 13680409, history record will be insert even process_item failed if not rollback
2534: Write_Debug('Rollback to IMPL_REV_ITEM_ATTR_CHGS Item Attribute Change Implementation ');
2535: ROLLBACK TO IMPL_REV_ITEM_ATTR_CHGS;
2536: --END IF;
2537:

Line 2553: IF FND_API.to_Boolean(p_debug)

2549: -- Close Error Handler Debug Session.
2550: -----------------------------------------------------
2551: -- Close debug session only explicitly open the debug session for
2552: -- this API.
2553: IF FND_API.to_Boolean(p_debug)
2554: THEN
2555: Close_Debug_Session;
2556: END IF ;
2557:

Line 2565: --IF FND_API.To_Boolean( l_commit ) THEN --commentted by bug 13680409, history record will be insert even process_item failed if not rollback

2561: x_return_status := G_RET_STS_UNEXP_ERROR ;
2562:
2563: Write_Debug('Rollback to IMPL_REV_ITEM_ATTR_CHGS Item Attribute Change Implementation ');
2564:
2565: --IF FND_API.To_Boolean( l_commit ) THEN --commentted by bug 13680409, history record will be insert even process_item failed if not rollback
2566: Write_Debug('Rollback to IMPL_REV_ITEM_ATTR_CHGS Item Attribute Change Implementation ');
2567: ROLLBACK TO IMPL_REV_ITEM_ATTR_CHGS;
2568: --END IF;
2569:

Line 2598: IF FND_API.to_Boolean(p_debug)

2594: -- Close Error Handler Debug Session.
2595: -----------------------------------------------------
2596: -- Close debug session only explicitly open the debug session for
2597: -- this API.
2598: IF FND_API.to_Boolean(p_debug)
2599: THEN
2600: Close_Debug_Session;
2601: END IF ;
2602:

Line 2611: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE

2607:
2608:
2609: PROCEDURE impl_rev_item_aml_changes
2610: ( p_api_version IN NUMBER
2611: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
2612: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
2613: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
2614: , x_return_status OUT NOCOPY VARCHAR2
2615: , x_msg_count OUT NOCOPY NUMBER

Line 2612: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE

2608:
2609: PROCEDURE impl_rev_item_aml_changes
2610: ( p_api_version IN NUMBER
2611: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
2612: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
2613: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
2614: , x_return_status OUT NOCOPY VARCHAR2
2615: , x_msg_count OUT NOCOPY NUMBER
2616: , x_msg_data OUT NOCOPY VARCHAR2

Line 2613: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL

2609: PROCEDURE impl_rev_item_aml_changes
2610: ( p_api_version IN NUMBER
2611: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
2612: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
2613: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
2614: , x_return_status OUT NOCOPY VARCHAR2
2615: , x_msg_count OUT NOCOPY NUMBER
2616: , x_msg_data OUT NOCOPY VARCHAR2
2617: , p_api_caller IN VARCHAR2 := NULL

Line 2618: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE

2614: , x_return_status OUT NOCOPY VARCHAR2
2615: , x_msg_count OUT NOCOPY NUMBER
2616: , x_msg_data OUT NOCOPY VARCHAR2
2617: , p_api_caller IN VARCHAR2 := NULL
2618: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE
2619: , p_output_dir IN VARCHAR2 := NULL
2620: , p_debug_filename IN VARCHAR2 := NULL
2621: , p_change_id IN NUMBER := NULL
2622: , p_change_line_id IN NUMBER

Line 2651: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

2647: BEGIN
2648:
2649:
2650: -- Standard call to check for call compatibility.
2651: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
2652: p_api_version ,
2653: l_api_name ,
2654: G_PKG_NAME )
2655: THEN

Line 2656: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2652: p_api_version ,
2653: l_api_name ,
2654: G_PKG_NAME )
2655: THEN
2656: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2657: END IF;
2658:
2659: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
2660: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;

Line 2659: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;

2655: THEN
2656: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2657: END IF;
2658:
2659: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
2660: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
2661: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
2662:
2663: IF FND_API.To_Boolean( l_commit ) THEN

Line 2660: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;

2656: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2657: END IF;
2658:
2659: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
2660: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
2661: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
2662:
2663: IF FND_API.To_Boolean( l_commit ) THEN
2664: -- Standard Start of API savepoint

Line 2661: l_commit := NVL(p_commit,FND_API.G_FALSE) ;

2657: END IF;
2658:
2659: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
2660: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
2661: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
2662:
2663: IF FND_API.To_Boolean( l_commit ) THEN
2664: -- Standard Start of API savepoint
2665: SAVEPOINT IMPL_REV_ITEM_AML_CHANGES;

Line 2663: IF FND_API.To_Boolean( l_commit ) THEN

2659: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
2660: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
2661: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
2662:
2663: IF FND_API.To_Boolean( l_commit ) THEN
2664: -- Standard Start of API savepoint
2665: SAVEPOINT IMPL_REV_ITEM_AML_CHANGES;
2666: END IF;
2667:

Line 2669: IF FND_API.to_Boolean( l_init_msg_list ) THEN

2665: SAVEPOINT IMPL_REV_ITEM_AML_CHANGES;
2666: END IF;
2667:
2668: -- Initialize message list if p_init_msg_list is set to TRUE.
2669: IF FND_API.to_Boolean( l_init_msg_list ) THEN
2670: FND_MSG_PUB.initialize;
2671: END IF;
2672:
2673: -- Open Debug Session by a give param or profile option.

Line 2740: FND_API.G_FALSE,

2736:
2737: EXECUTE IMMEDIATE plsql_block USING
2738: '1',
2739: '',
2740: FND_API.G_FALSE,
2741: p_change_id,
2742: p_change_line_id,
2743: OUT l_return_status,
2744: OUT l_msg_count,

Line 2772: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2768: FND_MESSAGE.Set_Token('OBJECT_NAME', 'EGO_ITEM_AML_PUB.Implement_AML_Changes');
2769: FND_MSG_PUB.Add;
2770:
2771: Write_Debug('When Others Exception while calling EGO_ITEM_AML_PUB.Implement_AML_Changes:' || Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240));
2772: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2773: END ;
2774:
2775: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
2776: THEN

Line 2775: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

2771: Write_Debug('When Others Exception while calling EGO_ITEM_AML_PUB.Implement_AML_Changes:' || Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240));
2772: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2773: END ;
2774:
2775: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
2776: THEN
2777: x_return_status := l_return_status;
2778: x_msg_count := l_msg_count;
2779: x_msg_data := l_msg_data;

Line 2791: RAISE FND_API.G_EXC_ERROR;

2787: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
2788: FND_MESSAGE.Set_Token('OBJECT_NAME', 'EGO_ITEM_AML_PUB.Implement_AML_Changes');
2789: FND_MSG_PUB.Add;
2790:
2791: RAISE FND_API.G_EXC_ERROR;
2792: END IF;
2793:
2794:
2795: -- End of API body.

Line 2799: IF FND_API.To_Boolean( p_commit ) THEN

2795: -- End of API body.
2796:
2797:
2798: -- Standard check of p_commit.
2799: IF FND_API.To_Boolean( p_commit ) THEN
2800: Write_Debug('COMMIT Item AML Changes implementation');
2801:
2802: COMMIT WORK;
2803: END IF;

Line 2817: IF FND_API.to_Boolean(p_debug)

2813: -- Close Error Handler Debug Session.
2814: -----------------------------------------------------
2815: -- Close debug session only explicitly open the debug session for
2816: -- this API.
2817: IF FND_API.to_Boolean(p_debug)
2818: THEN
2819: Close_Debug_Session;
2820: END IF ;
2821:

Line 2824: WHEN FND_API.G_EXC_ERROR THEN

2820: END IF ;
2821:
2822:
2823: EXCEPTION
2824: WHEN FND_API.G_EXC_ERROR THEN
2825: Write_Debug('When G_EXC_ERROR Exception in impl_rev_item_aml_changes');
2826:
2827: x_return_status := G_RET_STS_ERROR ;
2828:

Line 2829: IF FND_API.To_Boolean( l_commit ) THEN

2825: Write_Debug('When G_EXC_ERROR Exception in impl_rev_item_aml_changes');
2826:
2827: x_return_status := G_RET_STS_ERROR ;
2828:
2829: IF FND_API.To_Boolean( l_commit ) THEN
2830: Write_Debug('ROLLBACK Item AML Changes implementation to IMPL_REV_ITEM_AML_CHANGES');
2831: ROLLBACK TO IMPL_REV_ITEM_AML_CHANGES;
2832: END IF;
2833:

Line 2849: IF FND_API.to_Boolean(p_debug)

2845: -- Close Error Handler Debug Session.
2846: -----------------------------------------------------
2847: -- Close debug session only explicitly open the debug session for
2848: -- this API.
2849: IF FND_API.to_Boolean(p_debug)
2850: THEN
2851: Close_Debug_Session;
2852: END IF ;
2853:

Line 2854: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2850: THEN
2851: Close_Debug_Session;
2852: END IF ;
2853:
2854: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2855: Write_Debug('When G_EXC_UNEXPECTED_ERROR Exception in impl_rev_item_aml_changes');
2856:
2857: x_return_status := G_RET_STS_UNEXP_ERROR ;
2858:

Line 2859: IF FND_API.To_Boolean( l_commit ) THEN

2855: Write_Debug('When G_EXC_UNEXPECTED_ERROR Exception in impl_rev_item_aml_changes');
2856:
2857: x_return_status := G_RET_STS_UNEXP_ERROR ;
2858:
2859: IF FND_API.To_Boolean( l_commit ) THEN
2860: Write_Debug('ROLLBACK Item AML Changes implementation to IMPL_REV_ITEM_AML_CHANGES');
2861: ROLLBACK TO IMPL_REV_ITEM_AML_CHANGES;
2862: END IF;
2863:

Line 2879: IF FND_API.to_Boolean(p_debug)

2875: -- Close Error Handler Debug Session.
2876: -----------------------------------------------------
2877: -- Close debug session only explicitly open the debug session for
2878: -- this API.
2879: IF FND_API.to_Boolean(p_debug)
2880: THEN
2881: Close_Debug_Session;
2882: END IF ;
2883:

Line 2889: IF FND_API.To_Boolean( l_commit ) THEN

2885: Write_Debug('When OTHERS Exception in impl_rev_item_aml_changes');
2886:
2887: x_return_status := G_RET_STS_UNEXP_ERROR ;
2888:
2889: IF FND_API.To_Boolean( l_commit ) THEN
2890: Write_Debug('ROLLBACK Item AML Changes implementation to IMPL_REV_ITEM_AML_CHANGES');
2891: ROLLBACK TO IMPL_REV_ITEM_AML_CHANGES;
2892: END IF;
2893:

Line 2921: IF FND_API.to_Boolean(p_debug)

2917: -- Close Error Handler Debug Session.
2918: -----------------------------------------------------
2919: -- Close debug session only explicitly open the debug session for
2920: -- this API.
2921: IF FND_API.to_Boolean(p_debug)
2922: THEN
2923: Close_Debug_Session;
2924: END IF ;
2925:

Line 2933: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE

2929:
2930:
2931: PROCEDURE impl_rev_item_gdsn_attr_chgs
2932: ( p_api_version IN NUMBER
2933: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
2934: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
2935: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
2936: , x_return_status OUT NOCOPY VARCHAR2
2937: , x_msg_count OUT NOCOPY NUMBER

Line 2934: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE

2930:
2931: PROCEDURE impl_rev_item_gdsn_attr_chgs
2932: ( p_api_version IN NUMBER
2933: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
2934: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
2935: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
2936: , x_return_status OUT NOCOPY VARCHAR2
2937: , x_msg_count OUT NOCOPY NUMBER
2938: , x_msg_data OUT NOCOPY VARCHAR2

Line 2935: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL

2931: PROCEDURE impl_rev_item_gdsn_attr_chgs
2932: ( p_api_version IN NUMBER
2933: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
2934: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
2935: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
2936: , x_return_status OUT NOCOPY VARCHAR2
2937: , x_msg_count OUT NOCOPY NUMBER
2938: , x_msg_data OUT NOCOPY VARCHAR2
2939: , p_api_caller IN VARCHAR2 := NULL

Line 2940: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE

2936: , x_return_status OUT NOCOPY VARCHAR2
2937: , x_msg_count OUT NOCOPY NUMBER
2938: , x_msg_data OUT NOCOPY VARCHAR2
2939: , p_api_caller IN VARCHAR2 := NULL
2940: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE
2941: , p_output_dir IN VARCHAR2 := NULL
2942: , p_debug_filename IN VARCHAR2 := NULL
2943: , p_change_id IN NUMBER := NULL
2944: , p_change_line_id IN NUMBER

Line 3062: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

3058:
3059: BEGIN
3060:
3061: -- Standard call to check for call compatibility.
3062: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
3063: p_api_version ,
3064: l_api_name ,
3065: G_PKG_NAME )
3066: THEN

Line 3067: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3063: p_api_version ,
3064: l_api_name ,
3065: G_PKG_NAME )
3066: THEN
3067: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3068: END IF;
3069:
3070: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
3071: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;

Line 3070: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;

3066: THEN
3067: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3068: END IF;
3069:
3070: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
3071: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
3072: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
3073:
3074:

Line 3071: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;

3067: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3068: END IF;
3069:
3070: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
3071: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
3072: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
3073:
3074:
3075: IF FND_API.To_Boolean( l_commit ) THEN

Line 3072: l_commit := NVL(p_commit,FND_API.G_FALSE) ;

3068: END IF;
3069:
3070: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
3071: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
3072: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
3073:
3074:
3075: IF FND_API.To_Boolean( l_commit ) THEN
3076: -- Standard Start of API savepoint

Line 3075: IF FND_API.To_Boolean( l_commit ) THEN

3071: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
3072: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
3073:
3074:
3075: IF FND_API.To_Boolean( l_commit ) THEN
3076: -- Standard Start of API savepoint
3077: SAVEPOINT IMPL_REV_ITEM_GDSN_ATTR_CHGS;
3078: END IF;
3079:

Line 3081: IF FND_API.to_Boolean( l_init_msg_list ) THEN

3077: SAVEPOINT IMPL_REV_ITEM_GDSN_ATTR_CHGS;
3078: END IF;
3079:
3080: -- Initialize message list if p_init_msg_list is set to TRUE.
3081: IF FND_API.to_Boolean( l_init_msg_list ) THEN
3082: FND_MSG_PUB.initialize;
3083: END IF;
3084:
3085: -- Open Debug Session by a give param or profile option.

Line 3616: RAISE FND_API.G_EXC_ERROR;

3612: -- We don't support this in R12
3613: FND_MESSAGE.Set_Name('ENG','ENG_IMPL_INVALID_ACD_TYPE');
3614: FND_MESSAGE.Set_Token('ACD_TYPE', l_current_acd_type);
3615: FND_MSG_PUB.Add;
3616: RAISE FND_API.G_EXC_ERROR;
3617:
3618:
3619: END IF;
3620:

Line 4079: RAISE FND_API.G_EXC_ERROR;

4075: -- We don't support this in R12
4076: FND_MESSAGE.Set_Name('ENG','ENG_IMPL_INVALID_ACD_TYPE');
4077: FND_MESSAGE.Set_Token('ACD_TYPE', l_current_acd_type);
4078: FND_MSG_PUB.Add;
4079: RAISE FND_API.G_EXC_ERROR;
4080:
4081: END IF;
4082:
4083:

Line 4240: ,p_check_policy => FND_API.G_FALSE

4236: Write_Debug('Calling EGO_GTIN_ATTRS_PVT.Process_UCCnet_Attrs_For_Item . . . ' );
4237:
4238: EGO_GTIN_ATTRS_PVT.Process_UCCnet_Attrs_For_Item(
4239: p_api_version => p_api_version
4240: ,p_check_policy => FND_API.G_FALSE
4241: ,p_inventory_item_id => l_inventory_item_id
4242: ,p_organization_id => l_organization_id
4243: ,p_single_row_attrs_rec => l_single_row_attrs_rec
4244: ,p_multi_row_attrs_table => l_multi_row_attrs_tbl

Line 4248: ,p_init_error_handler => FND_API.G_FALSE

4244: ,p_multi_row_attrs_table => l_multi_row_attrs_tbl
4245: ,p_entity_id => null
4246: ,p_entity_index => null
4247: ,p_entity_code => G_BO_IDENTIFIER
4248: ,p_init_error_handler => FND_API.G_FALSE
4249: ,p_commit => FND_API.G_FALSE
4250: ,x_return_status => l_return_status
4251: ,x_errorcode => l_errorcode
4252: ,x_msg_count => l_msg_count

Line 4249: ,p_commit => FND_API.G_FALSE

4245: ,p_entity_id => null
4246: ,p_entity_index => null
4247: ,p_entity_code => G_BO_IDENTIFIER
4248: ,p_init_error_handler => FND_API.G_FALSE
4249: ,p_commit => FND_API.G_FALSE
4250: ,x_return_status => l_return_status
4251: ,x_errorcode => l_errorcode
4252: ,x_msg_count => l_msg_count
4253: ,x_msg_data => l_msg_data);

Line 4270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4266: FND_MESSAGE.Set_Token('OBJECT_NAME', 'EGO_GTIN_ATTRS_PVT.Process_UCCnet_Attrs_For_Item');
4267: FND_MSG_PUB.Add;
4268:
4269: Write_Debug('When Others Exception while calling EGO_GTIN_ATTRS_PVT.Process_UCCnet_Attrs_For_Item' || Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240));
4270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4271:
4272:
4273: END ;
4274:

Line 4278: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

4274:
4275:
4276: Write_Debug('After Calling EGO_GTIN_ATTRS_PVT.Process_UCCnet_Attrs_For_Item. Return Status: ' || l_return_status );
4277:
4278: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
4279: THEN
4280:
4281: Write_Debug('EGO_GTIN_ATTRS_PVT.Process_UCCnet_Attrs_For_Item failed . .. ' );
4282: Write_Debug('Output - Return Stattus: ' || l_return_status);

Line 4298: RAISE FND_API.G_EXC_ERROR ;

4294: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
4295: FND_MESSAGE.Set_Token('OBJECT_NAME', 'EGO_GTIN_ATTRS_PVT.Process_UCCnet_Attrs_For_Item');
4296: FND_MSG_PUB.Add;
4297:
4298: RAISE FND_API.G_EXC_ERROR ;
4299:
4300: END IF;
4301:
4302:

Line 4351: IF FND_API.To_Boolean( l_commit ) THEN

4347: -- End of API body.
4348:
4349:
4350: -- Standard check of p_commit.
4351: IF FND_API.To_Boolean( l_commit ) THEN
4352: Write_Debug('COMMIT Item GDSN Attribute Change Implementation');
4353: COMMIT WORK;
4354: END IF;
4355:

Line 4368: IF FND_API.to_Boolean(p_debug)

4364: -- Close Error Handler Debug Session.
4365: -----------------------------------------------------
4366: -- Close debug session only explicitly open the debug session for
4367: -- this API.
4368: IF FND_API.to_Boolean(p_debug)
4369: THEN
4370: Close_Debug_Session;
4371: END IF ;
4372:

Line 4375: WHEN FND_API.G_EXC_ERROR THEN

4371: END IF ;
4372:
4373:
4374: EXCEPTION
4375: WHEN FND_API.G_EXC_ERROR THEN
4376: Write_Debug('When G_EXC_ERROR Exception in impl_rev_item_gdsn_attr_chgs');
4377:
4378: x_return_status := G_RET_STS_ERROR ;
4379:

Line 4380: IF FND_API.To_Boolean( l_commit ) THEN

4376: Write_Debug('When G_EXC_ERROR Exception in impl_rev_item_gdsn_attr_chgs');
4377:
4378: x_return_status := G_RET_STS_ERROR ;
4379:
4380: IF FND_API.To_Boolean( l_commit ) THEN
4381: Write_Debug('ROLLBACK Item GDSN Attribute Change Implementation TO IMPL_REV_ITEM_GDSN_ATTR_CHGS');
4382: ROLLBACK TO IMPL_REV_ITEM_GDSN_ATTR_CHGS;
4383: END IF;
4384:

Line 4400: IF FND_API.to_Boolean(p_debug)

4396: -- Close Error Handler Debug Session.
4397: -----------------------------------------------------
4398: -- Close debug session only explicitly open the debug session for
4399: -- this API.
4400: IF FND_API.to_Boolean(p_debug)
4401: THEN
4402: Close_Debug_Session;
4403: END IF ;
4404:

Line 4405: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4401: THEN
4402: Close_Debug_Session;
4403: END IF ;
4404:
4405: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4406: Write_Debug('When G_EXC_UNEXPECTED_ERROR Exception in impl_rev_item_gdsn_attr_chgs');
4407:
4408: x_return_status := G_RET_STS_UNEXP_ERROR ;
4409:

Line 4410: IF FND_API.To_Boolean( l_commit ) THEN

4406: Write_Debug('When G_EXC_UNEXPECTED_ERROR Exception in impl_rev_item_gdsn_attr_chgs');
4407:
4408: x_return_status := G_RET_STS_UNEXP_ERROR ;
4409:
4410: IF FND_API.To_Boolean( l_commit ) THEN
4411: Write_Debug('ROLLBACK Item GDSN Attribute Change Implementation TO IMPL_REV_ITEM_GDSN_ATTR_CHGS');
4412: ROLLBACK TO IMPL_REV_ITEM_GDSN_ATTR_CHGS;
4413: END IF;
4414:

Line 4430: IF FND_API.to_Boolean(p_debug)

4426: -- Close Error Handler Debug Session.
4427: -----------------------------------------------------
4428: -- Close debug session only explicitly open the debug session for
4429: -- this API.
4430: IF FND_API.to_Boolean(p_debug)
4431: THEN
4432: Close_Debug_Session;
4433: END IF ;
4434:

Line 4441: IF FND_API.To_Boolean( l_commit ) THEN

4437: Write_Debug('When Others Exception in impl_rev_item_gdsn_attr_chgs');
4438:
4439: x_return_status := G_RET_STS_UNEXP_ERROR ;
4440:
4441: IF FND_API.To_Boolean( l_commit ) THEN
4442: Write_Debug('ROLLBACK Item GDSN Attribute Change Implementation TO IMPL_REV_ITEM_GDSN_ATTR_CHGS');
4443: ROLLBACK TO IMPL_REV_ITEM_GDSN_ATTR_CHGS;
4444: END IF;
4445:

Line 4473: IF FND_API.to_Boolean(p_debug)

4469: -- Close Error Handler Debug Session.
4470: -----------------------------------------------------
4471: -- Close debug session only explicitly open the debug session for
4472: -- this API.
4473: IF FND_API.to_Boolean(p_debug)
4474: THEN
4475: Close_Debug_Session;
4476: END IF ;
4477:

Line 4493: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

4489: ,p_change_line_id IN NUMBER
4490: ,p_old_data_level_nv_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
4491: ,p_new_data_level_nv_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
4492: ,p_related_class_code_function IN VARCHAR2
4493: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
4494: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
4495: ,x_return_status OUT NOCOPY VARCHAR2
4496: ,x_errorcode OUT NOCOPY NUMBER
4497: ,x_msg_count OUT NOCOPY NUMBER

Line 4494: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

4490: ,p_old_data_level_nv_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
4491: ,p_new_data_level_nv_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
4492: ,p_related_class_code_function IN VARCHAR2
4493: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
4494: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
4495: ,x_return_status OUT NOCOPY VARCHAR2
4496: ,x_errorcode OUT NOCOPY NUMBER
4497: ,x_msg_count OUT NOCOPY NUMBER
4498: ,x_msg_data OUT NOCOPY VARCHAR2

Line 4560: --IF FND_API.To_Boolean( p_commit ) THEN

4556: L_DATA_LEVEL_META_DATA EGO_DATA_LEVEL_METADATA_OBJ;
4557:
4558: BEGIN
4559:
4560: --IF FND_API.To_Boolean( p_commit ) THEN
4561: -- Standard start of API savepoint
4562: SAVEPOINT Implement_Change_Line_PUB;
4563: --END IF;
4564:

Line 4566: IF (FND_API.To_Boolean(p_init_msg_list)) THEN

4562: SAVEPOINT Implement_Change_Line_PUB;
4563: --END IF;
4564:
4565: -- Initialize FND_MSG_PUB and ERROR_HANDLER if necessary
4566: IF (FND_API.To_Boolean(p_init_msg_list)) THEN
4567: FND_MSG_PUB.Initialize;
4568: ERROR_HANDLER.Initialize;
4569: END IF;
4570:

Line 4572: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,

4568: ERROR_HANDLER.Initialize;
4569: END IF;
4570:
4571: -- Check for call compatibility
4572: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
4573: l_api_name, G_PKG_NAME)
4574: THEN
4575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4576: END IF;

Line 4575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4571: -- Check for call compatibility
4572: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
4573: l_api_name, G_PKG_NAME)
4574: THEN
4575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4576: END IF;
4577:
4578: -----------------------------------
4579:

Line 5641: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)

5637: END IF;
5638:
5639: Write_Debug('After Calling ENG_CHANGE_ATTR_UTIL.SETUP_IMPL_ATTR_DATA_ROW: Return Status: ' || x_return_status );
5640:
5641: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
5642: THEN
5643:
5644: Write_Debug('Raising error after ENG_CHANGE_ATTR_UTIL ' );
5645:

Line 5646: RAISE FND_API.G_EXC_ERROR;

5642: THEN
5643:
5644: Write_Debug('Raising error after ENG_CHANGE_ATTR_UTIL ' );
5645:
5646: RAISE FND_API.G_EXC_ERROR;
5647: END IF;
5648:
5649:
5650: Write_Debug('Calling EGO_USER_ATTRS_DATA_PVT.Process_Row ' );

Line 5696: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE

5692: ,p_extension_id => l_ext_id_for_current_row
5693: ,p_attr_name_value_pairs => l_impl_attr_name_value_pairs
5694: ,p_language_to_process => l_current_row_language
5695: ,p_mode => l_mode_for_current_row
5696: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE
5697: ,x_return_status => x_return_status
5698: ,x_errorcode => x_errorcode
5699: ,x_msg_count => x_msg_count
5700: ,x_msg_data => x_msg_data

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

5702:
5703: Write_Debug('After Calling EGO_USER_ATTRS_DATA_PVT.Process_Row: Return Status: ' || x_return_status );
5704: L_PREV_EXT_ID := l_ext_id_for_current_row;
5705:
5706: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5707: RAISE FND_API.G_EXC_ERROR;
5708: END IF;
5709: END IF;
5710: END LOOP;

Line 5707: RAISE FND_API.G_EXC_ERROR;

5703: Write_Debug('After Calling EGO_USER_ATTRS_DATA_PVT.Process_Row: Return Status: ' || x_return_status );
5704: L_PREV_EXT_ID := l_ext_id_for_current_row;
5705:
5706: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5707: RAISE FND_API.G_EXC_ERROR;
5708: END IF;
5709: END IF;
5710: END LOOP;
5711: DBMS_SQL.Close_Cursor(l_cursor_id);

Line 5758: IF FND_API.To_Boolean(p_commit) THEN

5754:
5755: -----------------------------------
5756:
5757: -- Standard check of p_commit
5758: IF FND_API.To_Boolean(p_commit) THEN
5759: Write_Debug('COMMIT Implement_Change_Line');
5760: COMMIT WORK;
5761: END IF;
5762:

Line 5763: x_return_status := FND_API.G_RET_STS_SUCCESS;

5759: Write_Debug('COMMIT Implement_Change_Line');
5760: COMMIT WORK;
5761: END IF;
5762:
5763: x_return_status := FND_API.G_RET_STS_SUCCESS;
5764:
5765: EXCEPTION
5766: WHEN FND_API.G_EXC_ERROR THEN
5767:

Line 5766: WHEN FND_API.G_EXC_ERROR THEN

5762:
5763: x_return_status := FND_API.G_RET_STS_SUCCESS;
5764:
5765: EXCEPTION
5766: WHEN FND_API.G_EXC_ERROR THEN
5767:
5768: Write_Debug('When G_EXC_ERROR Exception in Implement_Change_Line');
5769:
5770: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5770: x_return_status := FND_API.G_RET_STS_ERROR;

5766: WHEN FND_API.G_EXC_ERROR THEN
5767:
5768: Write_Debug('When G_EXC_ERROR Exception in Implement_Change_Line');
5769:
5770: x_return_status := FND_API.G_RET_STS_ERROR;
5771:
5772: --IF FND_API.To_Boolean( p_commit ) THEN --commentted by bug 13680409, history record will be insert even process_row failed if not rollback
5773: Write_Debug('ROLLBACK TO Implement_Change_Line');
5774: ROLLBACK TO Implement_Change_Line_PUB;

Line 5772: --IF FND_API.To_Boolean( p_commit ) THEN --commentted by bug 13680409, history record will be insert even process_row failed if not rollback

5768: Write_Debug('When G_EXC_ERROR Exception in Implement_Change_Line');
5769:
5770: x_return_status := FND_API.G_RET_STS_ERROR;
5771:
5772: --IF FND_API.To_Boolean( p_commit ) THEN --commentted by bug 13680409, history record will be insert even process_row failed if not rollback
5773: Write_Debug('ROLLBACK TO Implement_Change_Line');
5774: ROLLBACK TO Implement_Change_Line_PUB;
5775: --END IF;
5776:

Line 5784: ,p_message_type => FND_API.G_RET_STS_ERROR

5780: IF (x_msg_data IS NULL AND x_msg_count = 0) THEN
5781: ERROR_HANDLER.Add_Error_Message(
5782: p_message_name => 'EGO_EF_IMPLEMENT_ERR'
5783: ,p_application_id => 'EGO'
5784: ,p_message_type => FND_API.G_RET_STS_ERROR
5785: ,p_addto_fnd_stack => 'Y'
5786: );
5787: END IF;
5788:

Line 5807: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5803:
5804: WHEN OTHERS THEN
5805: Write_Debug('When G_RET_STS_UNEXP_ERROR Exception in Implement_Change_Line');
5806:
5807: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5808:
5809: --IF FND_API.To_Boolean( p_commit ) THEN --commentted by bug 13680409, history record will be insert even process_row failed if not rollback
5810: Write_Debug('ROLLBACK TO Implement_Change_Line');
5811: ROLLBACK TO Implement_Change_Line_PUB;

Line 5809: --IF FND_API.To_Boolean( p_commit ) THEN --commentted by bug 13680409, history record will be insert even process_row failed if not rollback

5805: Write_Debug('When G_RET_STS_UNEXP_ERROR Exception in Implement_Change_Line');
5806:
5807: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5808:
5809: --IF FND_API.To_Boolean( p_commit ) THEN --commentted by bug 13680409, history record will be insert even process_row failed if not rollback
5810: Write_Debug('ROLLBACK TO Implement_Change_Line');
5811: ROLLBACK TO Implement_Change_Line_PUB;
5812: --END IF;
5813:

Line 5831: ,p_message_type => FND_API.G_RET_STS_ERROR

5827: ERROR_HANDLER.Add_Error_Message(
5828: p_message_name => 'EGO_PLSQL_ERR'
5829: ,p_application_id => 'EGO'
5830: ,p_token_tbl => l_token_table
5831: ,p_message_type => FND_API.G_RET_STS_ERROR
5832: ,p_addto_fnd_stack => 'Y'
5833: );
5834:
5835: ERROR_HANDLER.Get_Message(x_message_text => x_msg_data

Line 5848: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE

5844:
5845:
5846: PROCEDURE impl_rev_item_user_attr_chgs
5847: ( p_api_version IN NUMBER
5848: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
5849: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
5850: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
5851: , x_return_status OUT NOCOPY VARCHAR2
5852: , x_msg_count OUT NOCOPY NUMBER

Line 5849: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE

5845:
5846: PROCEDURE impl_rev_item_user_attr_chgs
5847: ( p_api_version IN NUMBER
5848: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
5849: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
5850: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
5851: , x_return_status OUT NOCOPY VARCHAR2
5852: , x_msg_count OUT NOCOPY NUMBER
5853: , x_msg_data OUT NOCOPY VARCHAR2

Line 5850: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL

5846: PROCEDURE impl_rev_item_user_attr_chgs
5847: ( p_api_version IN NUMBER
5848: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
5849: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
5850: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
5851: , x_return_status OUT NOCOPY VARCHAR2
5852: , x_msg_count OUT NOCOPY NUMBER
5853: , x_msg_data OUT NOCOPY VARCHAR2
5854: , p_api_caller IN VARCHAR2 := NULL

Line 5855: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE

5851: , x_return_status OUT NOCOPY VARCHAR2
5852: , x_msg_count OUT NOCOPY NUMBER
5853: , x_msg_data OUT NOCOPY VARCHAR2
5854: , p_api_caller IN VARCHAR2 := NULL
5855: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE
5856: , p_output_dir IN VARCHAR2 := NULL
5857: , p_debug_filename IN VARCHAR2 := NULL
5858: , p_change_id IN NUMBER := NULL
5859: , p_change_line_id IN NUMBER

Line 5895: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

5891: BEGIN
5892:
5893:
5894: -- Standard call to check for call compatibility.
5895: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
5896: p_api_version ,
5897: l_api_name ,
5898: G_PKG_NAME )
5899: THEN

Line 5900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5896: p_api_version ,
5897: l_api_name ,
5898: G_PKG_NAME )
5899: THEN
5900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5901: END IF;
5902:
5903: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
5904: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;

Line 5903: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;

5899: THEN
5900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5901: END IF;
5902:
5903: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
5904: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
5905: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
5906:
5907:

Line 5904: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;

5900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5901: END IF;
5902:
5903: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
5904: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
5905: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
5906:
5907:
5908: -- Standard check of p_commit.

Line 5905: l_commit := NVL(p_commit,FND_API.G_FALSE) ;

5901: END IF;
5902:
5903: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
5904: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
5905: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
5906:
5907:
5908: -- Standard check of p_commit.
5909: IF FND_API.To_Boolean( l_commit ) THEN

Line 5909: IF FND_API.To_Boolean( l_commit ) THEN

5905: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
5906:
5907:
5908: -- Standard check of p_commit.
5909: IF FND_API.To_Boolean( l_commit ) THEN
5910: -- Standard Start of API savepoint
5911: SAVEPOINT IMPL_REV_ITEM_USER_ATTR_CHGS;
5912: END IF;
5913:

Line 5915: IF FND_API.to_Boolean( l_init_msg_list ) THEN

5911: SAVEPOINT IMPL_REV_ITEM_USER_ATTR_CHGS;
5912: END IF;
5913:
5914: -- Initialize message list if p_init_msg_list is set to TRUE.
5915: IF FND_API.to_Boolean( l_init_msg_list ) THEN
5916: FND_MSG_PUB.initialize;
5917: END IF;
5918:
5919: -- Open Debug Session by a give param or profile option.

Line 6030: ,p_init_msg_list => FND_API.G_FALSE

6026: ,p_change_line_id => l_change_line_id
6027: ,p_old_data_level_nv_pairs => l_old_data_level_nv_pairs
6028: ,p_new_data_level_nv_pairs => l_new_data_level_nv_pairs
6029: ,p_related_class_code_function => 'EGO_ITEM_USER_ATTRS_CP_PUB.Get_Related_Class_Codes'
6030: ,p_init_msg_list => FND_API.G_FALSE
6031: ,p_commit => FND_API.G_FALSE
6032: ,x_return_status => l_return_status
6033: ,x_errorcode => l_errorcode
6034: ,x_msg_count => l_msg_count

Line 6031: ,p_commit => FND_API.G_FALSE

6027: ,p_old_data_level_nv_pairs => l_old_data_level_nv_pairs
6028: ,p_new_data_level_nv_pairs => l_new_data_level_nv_pairs
6029: ,p_related_class_code_function => 'EGO_ITEM_USER_ATTRS_CP_PUB.Get_Related_Class_Codes'
6030: ,p_init_msg_list => FND_API.G_FALSE
6031: ,p_commit => FND_API.G_FALSE
6032: ,x_return_status => l_return_status
6033: ,x_errorcode => l_errorcode
6034: ,x_msg_count => l_msg_count
6035: ,x_msg_data => l_msg_data

Line 6053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6049: FND_MESSAGE.Set_Token('OBJECT_NAME', 'EGO_USER_ATTRS_DATA_PVT.Implement_Change_Line');
6050: FND_MSG_PUB.Add;
6051:
6052: Write_Debug('When Others Exception while calling EGO_USER_ATTRS_DATA_PVT.Implement_Change_Line:' || Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240));
6053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6054: END ;
6055:
6056: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
6057: THEN

Line 6056: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

6052: Write_Debug('When Others Exception while calling EGO_USER_ATTRS_DATA_PVT.Implement_Change_Line:' || Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240));
6053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6054: END ;
6055:
6056: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
6057: THEN
6058:
6059: Write_Debug('Implement_Change_Line failed . .. ' );
6060: Write_Debug('Output - Return Stattus: ' || l_return_status);

Line 6072: RAISE FND_API.G_EXC_ERROR ;

6068: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
6069: FND_MESSAGE.Set_Token('OBJECT_NAME', 'EGO_USER_ATTRS_DATA_PVT.Implement_Change_Line');
6070: FND_MSG_PUB.Add;
6071:
6072: RAISE FND_API.G_EXC_ERROR ;
6073: END IF;
6074:
6075:
6076: -- End of API body.

Line 6080: IF FND_API.To_Boolean( l_commit ) THEN

6076: -- End of API body.
6077:
6078:
6079: -- Standard check of p_commit.
6080: IF FND_API.To_Boolean( l_commit ) THEN
6081: COMMIT WORK;
6082: END IF;
6083:
6084: -- Standard call to get message count and if count is 1, get message info.

Line 6096: IF FND_API.to_Boolean(p_debug)

6092: -- Close Error Handler Debug Session.
6093: -----------------------------------------------------
6094: -- Close debug session only explicitly open the debug session for
6095: -- this API.
6096: IF FND_API.to_Boolean(p_debug)
6097: THEN
6098: Close_Debug_Session;
6099: END IF ;
6100:

Line 6103: WHEN FND_API.G_EXC_ERROR THEN

6099: END IF ;
6100:
6101:
6102: EXCEPTION
6103: WHEN FND_API.G_EXC_ERROR THEN
6104: Write_Debug('When G_EXC_ERROR Exception in impl_rev_item_user_attr_chgs');
6105: x_return_status := G_RET_STS_ERROR ;
6106:
6107: IF FND_API.To_Boolean( l_commit ) THEN

Line 6107: IF FND_API.To_Boolean( l_commit ) THEN

6103: WHEN FND_API.G_EXC_ERROR THEN
6104: Write_Debug('When G_EXC_ERROR Exception in impl_rev_item_user_attr_chgs');
6105: x_return_status := G_RET_STS_ERROR ;
6106:
6107: IF FND_API.To_Boolean( l_commit ) THEN
6108: Write_Debug('ROLLBACK Item User Attribute Change Implementation TO IMPL_REV_ITEM_USER_ATTR_CHGS');
6109: ROLLBACK TO IMPL_REV_ITEM_USER_ATTR_CHGS;
6110: END IF;
6111:

Line 6127: IF FND_API.to_Boolean(p_debug)

6123: -- Close Error Handler Debug Session.
6124: -----------------------------------------------------
6125: -- Close debug session only explicitly open the debug session for
6126: -- this API.
6127: IF FND_API.to_Boolean(p_debug)
6128: THEN
6129: Close_Debug_Session;
6130: END IF ;
6131:

Line 6132: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6128: THEN
6129: Close_Debug_Session;
6130: END IF ;
6131:
6132: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6133:
6134: Write_Debug('When G_EXC_UNEXPECTED_ERROR Exception in impl_rev_item_user_attr_chgs');
6135: x_return_status := G_RET_STS_UNEXP_ERROR ;
6136:

Line 6137: IF FND_API.To_Boolean( l_commit ) THEN

6133:
6134: Write_Debug('When G_EXC_UNEXPECTED_ERROR Exception in impl_rev_item_user_attr_chgs');
6135: x_return_status := G_RET_STS_UNEXP_ERROR ;
6136:
6137: IF FND_API.To_Boolean( l_commit ) THEN
6138: Write_Debug('ROLLBACK Item User Attribute Change Implementation TO IMPL_REV_ITEM_USER_ATTR_CHGS');
6139: ROLLBACK TO IMPL_REV_ITEM_USER_ATTR_CHGS;
6140: END IF;
6141:

Line 6158: IF FND_API.to_Boolean(p_debug)

6154: -- Close Error Handler Debug Session.
6155: -----------------------------------------------------
6156: -- Close debug session only explicitly open the debug session for
6157: -- this API.
6158: IF FND_API.to_Boolean(p_debug)
6159: THEN
6160: Close_Debug_Session;
6161: END IF ;
6162:

Line 6168: IF FND_API.To_Boolean( l_commit ) THEN

6164:
6165: Write_Debug('When Others Exception in impl_rev_item_user_attr_chgs');
6166: x_return_status := G_RET_STS_UNEXP_ERROR ;
6167:
6168: IF FND_API.To_Boolean( l_commit ) THEN
6169: Write_Debug('ROLLBACK Item User Attribute Change Implementation TO IMPL_REV_ITEM_USER_ATTR_CHGS');
6170: ROLLBACK TO IMPL_REV_ITEM_USER_ATTR_CHGS;
6171: END IF;
6172:

Line 6201: IF FND_API.to_Boolean(p_debug)

6197: -- Close Error Handler Debug Session.
6198: -----------------------------------------------------
6199: -- Close debug session only explicitly open the debug session for
6200: -- this API.
6201: IF FND_API.to_Boolean(p_debug)
6202: THEN
6203: Close_Debug_Session;
6204: END IF ;
6205: