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

Line 271: x_return_status := FND_API.G_RET_STS_SUCCESS;

267: ,x_msg_count OUT NOCOPY NUMBER
268: ,x_msg_data OUT NOCOPY VARCHAR2) IS
269: l_api_name VARCHAR2(30);
270: BEGIN
271: x_return_status := FND_API.G_RET_STS_SUCCESS;
272: x_msg_count := 0;
273: x_msg_data := NULL;
274: l_api_name := 'ValueToIdConversion';
275: --

Line 538: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

534: ,p_message => 'VtoID Conversion Complete for Item'
535: );
536: EXCEPTION
537: WHEN OTHERS THEN
538: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
539: x_msg_count := 1;
540: -- for SQL errors
541: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
542: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

Line 556: x_return_status := FND_API.G_RET_STS_SUCCESS;

552: ,x_msg_count OUT NOCOPY NUMBER
553: ,x_msg_data OUT NOCOPY VARCHAR2) IS
554: l_api_name VARCHAR2(30);
555: BEGIN
556: x_return_status := FND_API.G_RET_STS_SUCCESS;
557: x_msg_count := 0;
558: x_msg_data := NULL;
559: l_api_name := 'TransactionCheck';
560: --

Line 646: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

642: END IF;
643:
644: EXCEPTION
645: WHEN OTHERS THEN
646: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
647: x_msg_count := 1;
648: -- for SQL errors
649: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
650: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

Line 664: x_return_status := FND_API.G_RET_STS_SUCCESS;

660: ,x_msg_count OUT NOCOPY NUMBER
661: ,x_msg_data OUT NOCOPY VARCHAR2) IS
662: l_api_name VARCHAR2(30);
663: BEGIN
664: x_return_status := FND_API.G_RET_STS_SUCCESS;
665: x_msg_count := 0;
666: x_msg_data := NULL;
667: l_api_name := 'performDupRecordCheck';
668: --

Line 694: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

690: ,p_message => 'Dup Check Complete'
691: );
692: EXCEPTION
693: WHEN OTHERS THEN
694: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
695: x_msg_count := 1;
696: -- for SQL errors
697: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
698: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

Line 729: x_return_status := FND_API.G_RET_STS_SUCCESS;

725: l_api_name VARCHAR2(30);
726: l_add_all_to_cm VARCHAR2(1);
727:
728: BEGIN
729: x_return_status := FND_API.G_RET_STS_SUCCESS;
730: x_msg_count := 0;
731: x_msg_data := NULL;
732: l_api_name := 'performCMSeggregation';
733: --

Line 854: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

850: WHEN OTHERS THEN
851: IF c_item_records%ISOPEN THEN
852: CLOSE c_item_records;
853: END IF;
854: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
855: x_msg_count := 1;
856: -- for SQL errors
857: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
858: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

Line 888: x_return_status := FND_API.G_RET_STS_SUCCESS;

884: )
885: FOR UPDATE OF transaction_id;
886:
887: BEGIN
888: x_return_status := FND_API.G_RET_STS_SUCCESS;
889: x_msg_count := 0;
890: x_msg_data := NULL;
891: l_api_name := 'performItemValidation';
892: --

Line 929: x_return_status := FND_API.G_RET_STS_SUCCESS;

925: ,p_message => 'Returning get Security Predicate with status - '
926: ||x_return_status
927: );
928: IF x_return_status IN ('T','F') THEN
929: x_return_status := FND_API.G_RET_STS_SUCCESS;
930: IF l_sec_predicate IS NULL THEN
931: log_now (p_log_level => G_DEBUG_LEVEL_STATEMENT
932: ,p_module => l_api_name
933: ,p_message => ' Security Predicate is NULL'

Line 959: x_return_status := FND_API.G_RET_STS_ERROR;

955: USING IN p_data_set_id;
956: END IF;
957: ELSE
958: IF x_return_status = 'L' THEN
959: x_return_status := FND_API.G_RET_STS_ERROR;
960: END IF;
961: x_msg_data := FND_MESSAGE.GET_ENCODED();
962: log_now (p_log_level => G_DEBUG_LEVEL_STATEMENT
963: ,p_module => l_api_name

Line 1292: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1288: WHEN OTHERS THEN
1289: IF c_item_records%ISOPEN THEN
1290: CLOSE c_item_records;
1291: END IF;
1292: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1293: x_msg_count := 1;
1294: -- for SQL errors
1295: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
1296: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

Line 1307: p_dff_usage_record.attribute1 := FND_API.G_FALSE;

1303: PROCEDURE resetDFFFieldUsage
1304: (p_dff_usage_record IN OUT NOCOPY G_MTL_DFF_ATTRIBUTES_REC
1305: ) IS
1306: BEGIN
1307: p_dff_usage_record.attribute1 := FND_API.G_FALSE;
1308: p_dff_usage_record.attribute2 := FND_API.G_FALSE;
1309: p_dff_usage_record.attribute3 := FND_API.G_FALSE;
1310: p_dff_usage_record.attribute4 := FND_API.G_FALSE;
1311: p_dff_usage_record.attribute5 := FND_API.G_FALSE;

Line 1308: p_dff_usage_record.attribute2 := FND_API.G_FALSE;

1304: (p_dff_usage_record IN OUT NOCOPY G_MTL_DFF_ATTRIBUTES_REC
1305: ) IS
1306: BEGIN
1307: p_dff_usage_record.attribute1 := FND_API.G_FALSE;
1308: p_dff_usage_record.attribute2 := FND_API.G_FALSE;
1309: p_dff_usage_record.attribute3 := FND_API.G_FALSE;
1310: p_dff_usage_record.attribute4 := FND_API.G_FALSE;
1311: p_dff_usage_record.attribute5 := FND_API.G_FALSE;
1312: p_dff_usage_record.attribute6 := FND_API.G_FALSE;

Line 1309: p_dff_usage_record.attribute3 := FND_API.G_FALSE;

1305: ) IS
1306: BEGIN
1307: p_dff_usage_record.attribute1 := FND_API.G_FALSE;
1308: p_dff_usage_record.attribute2 := FND_API.G_FALSE;
1309: p_dff_usage_record.attribute3 := FND_API.G_FALSE;
1310: p_dff_usage_record.attribute4 := FND_API.G_FALSE;
1311: p_dff_usage_record.attribute5 := FND_API.G_FALSE;
1312: p_dff_usage_record.attribute6 := FND_API.G_FALSE;
1313: p_dff_usage_record.attribute7 := FND_API.G_FALSE;

Line 1310: p_dff_usage_record.attribute4 := FND_API.G_FALSE;

1306: BEGIN
1307: p_dff_usage_record.attribute1 := FND_API.G_FALSE;
1308: p_dff_usage_record.attribute2 := FND_API.G_FALSE;
1309: p_dff_usage_record.attribute3 := FND_API.G_FALSE;
1310: p_dff_usage_record.attribute4 := FND_API.G_FALSE;
1311: p_dff_usage_record.attribute5 := FND_API.G_FALSE;
1312: p_dff_usage_record.attribute6 := FND_API.G_FALSE;
1313: p_dff_usage_record.attribute7 := FND_API.G_FALSE;
1314: p_dff_usage_record.attribute8 := FND_API.G_FALSE;

Line 1311: p_dff_usage_record.attribute5 := FND_API.G_FALSE;

1307: p_dff_usage_record.attribute1 := FND_API.G_FALSE;
1308: p_dff_usage_record.attribute2 := FND_API.G_FALSE;
1309: p_dff_usage_record.attribute3 := FND_API.G_FALSE;
1310: p_dff_usage_record.attribute4 := FND_API.G_FALSE;
1311: p_dff_usage_record.attribute5 := FND_API.G_FALSE;
1312: p_dff_usage_record.attribute6 := FND_API.G_FALSE;
1313: p_dff_usage_record.attribute7 := FND_API.G_FALSE;
1314: p_dff_usage_record.attribute8 := FND_API.G_FALSE;
1315: p_dff_usage_record.attribute9 := FND_API.G_FALSE;

Line 1312: p_dff_usage_record.attribute6 := FND_API.G_FALSE;

1308: p_dff_usage_record.attribute2 := FND_API.G_FALSE;
1309: p_dff_usage_record.attribute3 := FND_API.G_FALSE;
1310: p_dff_usage_record.attribute4 := FND_API.G_FALSE;
1311: p_dff_usage_record.attribute5 := FND_API.G_FALSE;
1312: p_dff_usage_record.attribute6 := FND_API.G_FALSE;
1313: p_dff_usage_record.attribute7 := FND_API.G_FALSE;
1314: p_dff_usage_record.attribute8 := FND_API.G_FALSE;
1315: p_dff_usage_record.attribute9 := FND_API.G_FALSE;
1316: p_dff_usage_record.attribute10 := FND_API.G_FALSE;

Line 1313: p_dff_usage_record.attribute7 := FND_API.G_FALSE;

1309: p_dff_usage_record.attribute3 := FND_API.G_FALSE;
1310: p_dff_usage_record.attribute4 := FND_API.G_FALSE;
1311: p_dff_usage_record.attribute5 := FND_API.G_FALSE;
1312: p_dff_usage_record.attribute6 := FND_API.G_FALSE;
1313: p_dff_usage_record.attribute7 := FND_API.G_FALSE;
1314: p_dff_usage_record.attribute8 := FND_API.G_FALSE;
1315: p_dff_usage_record.attribute9 := FND_API.G_FALSE;
1316: p_dff_usage_record.attribute10 := FND_API.G_FALSE;
1317: p_dff_usage_record.attribute11 := FND_API.G_FALSE;

Line 1314: p_dff_usage_record.attribute8 := FND_API.G_FALSE;

1310: p_dff_usage_record.attribute4 := FND_API.G_FALSE;
1311: p_dff_usage_record.attribute5 := FND_API.G_FALSE;
1312: p_dff_usage_record.attribute6 := FND_API.G_FALSE;
1313: p_dff_usage_record.attribute7 := FND_API.G_FALSE;
1314: p_dff_usage_record.attribute8 := FND_API.G_FALSE;
1315: p_dff_usage_record.attribute9 := FND_API.G_FALSE;
1316: p_dff_usage_record.attribute10 := FND_API.G_FALSE;
1317: p_dff_usage_record.attribute11 := FND_API.G_FALSE;
1318: p_dff_usage_record.attribute12 := FND_API.G_FALSE;

Line 1315: p_dff_usage_record.attribute9 := FND_API.G_FALSE;

1311: p_dff_usage_record.attribute5 := FND_API.G_FALSE;
1312: p_dff_usage_record.attribute6 := FND_API.G_FALSE;
1313: p_dff_usage_record.attribute7 := FND_API.G_FALSE;
1314: p_dff_usage_record.attribute8 := FND_API.G_FALSE;
1315: p_dff_usage_record.attribute9 := FND_API.G_FALSE;
1316: p_dff_usage_record.attribute10 := FND_API.G_FALSE;
1317: p_dff_usage_record.attribute11 := FND_API.G_FALSE;
1318: p_dff_usage_record.attribute12 := FND_API.G_FALSE;
1319: p_dff_usage_record.attribute13 := FND_API.G_FALSE;

Line 1316: p_dff_usage_record.attribute10 := FND_API.G_FALSE;

1312: p_dff_usage_record.attribute6 := FND_API.G_FALSE;
1313: p_dff_usage_record.attribute7 := FND_API.G_FALSE;
1314: p_dff_usage_record.attribute8 := FND_API.G_FALSE;
1315: p_dff_usage_record.attribute9 := FND_API.G_FALSE;
1316: p_dff_usage_record.attribute10 := FND_API.G_FALSE;
1317: p_dff_usage_record.attribute11 := FND_API.G_FALSE;
1318: p_dff_usage_record.attribute12 := FND_API.G_FALSE;
1319: p_dff_usage_record.attribute13 := FND_API.G_FALSE;
1320: p_dff_usage_record.attribute14 := FND_API.G_FALSE;

Line 1317: p_dff_usage_record.attribute11 := FND_API.G_FALSE;

1313: p_dff_usage_record.attribute7 := FND_API.G_FALSE;
1314: p_dff_usage_record.attribute8 := FND_API.G_FALSE;
1315: p_dff_usage_record.attribute9 := FND_API.G_FALSE;
1316: p_dff_usage_record.attribute10 := FND_API.G_FALSE;
1317: p_dff_usage_record.attribute11 := FND_API.G_FALSE;
1318: p_dff_usage_record.attribute12 := FND_API.G_FALSE;
1319: p_dff_usage_record.attribute13 := FND_API.G_FALSE;
1320: p_dff_usage_record.attribute14 := FND_API.G_FALSE;
1321: p_dff_usage_record.attribute15 := FND_API.G_FALSE;

Line 1318: p_dff_usage_record.attribute12 := FND_API.G_FALSE;

1314: p_dff_usage_record.attribute8 := FND_API.G_FALSE;
1315: p_dff_usage_record.attribute9 := FND_API.G_FALSE;
1316: p_dff_usage_record.attribute10 := FND_API.G_FALSE;
1317: p_dff_usage_record.attribute11 := FND_API.G_FALSE;
1318: p_dff_usage_record.attribute12 := FND_API.G_FALSE;
1319: p_dff_usage_record.attribute13 := FND_API.G_FALSE;
1320: p_dff_usage_record.attribute14 := FND_API.G_FALSE;
1321: p_dff_usage_record.attribute15 := FND_API.G_FALSE;
1322: EXCEPTION

Line 1319: p_dff_usage_record.attribute13 := FND_API.G_FALSE;

1315: p_dff_usage_record.attribute9 := FND_API.G_FALSE;
1316: p_dff_usage_record.attribute10 := FND_API.G_FALSE;
1317: p_dff_usage_record.attribute11 := FND_API.G_FALSE;
1318: p_dff_usage_record.attribute12 := FND_API.G_FALSE;
1319: p_dff_usage_record.attribute13 := FND_API.G_FALSE;
1320: p_dff_usage_record.attribute14 := FND_API.G_FALSE;
1321: p_dff_usage_record.attribute15 := FND_API.G_FALSE;
1322: EXCEPTION
1323: WHEN OTHERS THEN

Line 1320: p_dff_usage_record.attribute14 := FND_API.G_FALSE;

1316: p_dff_usage_record.attribute10 := FND_API.G_FALSE;
1317: p_dff_usage_record.attribute11 := FND_API.G_FALSE;
1318: p_dff_usage_record.attribute12 := FND_API.G_FALSE;
1319: p_dff_usage_record.attribute13 := FND_API.G_FALSE;
1320: p_dff_usage_record.attribute14 := FND_API.G_FALSE;
1321: p_dff_usage_record.attribute15 := FND_API.G_FALSE;
1322: EXCEPTION
1323: WHEN OTHERS THEN
1324: NULL;

Line 1321: p_dff_usage_record.attribute15 := FND_API.G_FALSE;

1317: p_dff_usage_record.attribute11 := FND_API.G_FALSE;
1318: p_dff_usage_record.attribute12 := FND_API.G_FALSE;
1319: p_dff_usage_record.attribute13 := FND_API.G_FALSE;
1320: p_dff_usage_record.attribute14 := FND_API.G_FALSE;
1321: p_dff_usage_record.attribute15 := FND_API.G_FALSE;
1322: EXCEPTION
1323: WHEN OTHERS THEN
1324: NULL;
1325: END resetDFFFieldUsage;

Line 1334: p_dff_usage_record.attribute1 := FND_API.G_TRUE;

1330: ,p_dff_usage_record IN OUT NOCOPY G_MTL_DFF_ATTRIBUTES_REC
1331: ) RETURN VARCHAR2 IS
1332: BEGIN
1333: IF p_column_name = 'ATTRIBUTE1' THEN
1334: p_dff_usage_record.attribute1 := FND_API.G_TRUE;
1335: RETURN p_part_num_rec.attribute1;
1336: ELSIF p_column_name = 'ATTRIBUTE2' THEN
1337: p_dff_usage_record.attribute2 := FND_API.G_TRUE;
1338: RETURN p_part_num_rec.attribute2;

Line 1337: p_dff_usage_record.attribute2 := FND_API.G_TRUE;

1333: IF p_column_name = 'ATTRIBUTE1' THEN
1334: p_dff_usage_record.attribute1 := FND_API.G_TRUE;
1335: RETURN p_part_num_rec.attribute1;
1336: ELSIF p_column_name = 'ATTRIBUTE2' THEN
1337: p_dff_usage_record.attribute2 := FND_API.G_TRUE;
1338: RETURN p_part_num_rec.attribute2;
1339: ELSIF p_column_name = 'ATTRIBUTE3' THEN
1340: p_dff_usage_record.attribute3 := FND_API.G_TRUE;
1341: RETURN p_part_num_rec.attribute3;

Line 1340: p_dff_usage_record.attribute3 := FND_API.G_TRUE;

1336: ELSIF p_column_name = 'ATTRIBUTE2' THEN
1337: p_dff_usage_record.attribute2 := FND_API.G_TRUE;
1338: RETURN p_part_num_rec.attribute2;
1339: ELSIF p_column_name = 'ATTRIBUTE3' THEN
1340: p_dff_usage_record.attribute3 := FND_API.G_TRUE;
1341: RETURN p_part_num_rec.attribute3;
1342: ELSIF p_column_name = 'ATTRIBUTE4' THEN
1343: p_dff_usage_record.attribute4 := FND_API.G_TRUE;
1344: RETURN p_part_num_rec.attribute4;

Line 1343: p_dff_usage_record.attribute4 := FND_API.G_TRUE;

1339: ELSIF p_column_name = 'ATTRIBUTE3' THEN
1340: p_dff_usage_record.attribute3 := FND_API.G_TRUE;
1341: RETURN p_part_num_rec.attribute3;
1342: ELSIF p_column_name = 'ATTRIBUTE4' THEN
1343: p_dff_usage_record.attribute4 := FND_API.G_TRUE;
1344: RETURN p_part_num_rec.attribute4;
1345: ELSIF p_column_name = 'ATTRIBUTE5' THEN
1346: p_dff_usage_record.attribute5 := FND_API.G_TRUE;
1347: RETURN p_part_num_rec.attribute5;

Line 1346: p_dff_usage_record.attribute5 := FND_API.G_TRUE;

1342: ELSIF p_column_name = 'ATTRIBUTE4' THEN
1343: p_dff_usage_record.attribute4 := FND_API.G_TRUE;
1344: RETURN p_part_num_rec.attribute4;
1345: ELSIF p_column_name = 'ATTRIBUTE5' THEN
1346: p_dff_usage_record.attribute5 := FND_API.G_TRUE;
1347: RETURN p_part_num_rec.attribute5;
1348: ELSIF p_column_name = 'ATTRIBUTE6' THEN
1349: p_dff_usage_record.attribute6 := FND_API.G_TRUE;
1350: RETURN p_part_num_rec.attribute6;

Line 1349: p_dff_usage_record.attribute6 := FND_API.G_TRUE;

1345: ELSIF p_column_name = 'ATTRIBUTE5' THEN
1346: p_dff_usage_record.attribute5 := FND_API.G_TRUE;
1347: RETURN p_part_num_rec.attribute5;
1348: ELSIF p_column_name = 'ATTRIBUTE6' THEN
1349: p_dff_usage_record.attribute6 := FND_API.G_TRUE;
1350: RETURN p_part_num_rec.attribute6;
1351: ELSIF p_column_name = 'ATTRIBUTE7' THEN
1352: p_dff_usage_record.attribute7 := FND_API.G_TRUE;
1353: RETURN p_part_num_rec.attribute7;

Line 1352: p_dff_usage_record.attribute7 := FND_API.G_TRUE;

1348: ELSIF p_column_name = 'ATTRIBUTE6' THEN
1349: p_dff_usage_record.attribute6 := FND_API.G_TRUE;
1350: RETURN p_part_num_rec.attribute6;
1351: ELSIF p_column_name = 'ATTRIBUTE7' THEN
1352: p_dff_usage_record.attribute7 := FND_API.G_TRUE;
1353: RETURN p_part_num_rec.attribute7;
1354: ELSIF p_column_name = 'ATTRIBUTE8' THEN
1355: p_dff_usage_record.attribute8 := FND_API.G_TRUE;
1356: RETURN p_part_num_rec.attribute8;

Line 1355: p_dff_usage_record.attribute8 := FND_API.G_TRUE;

1351: ELSIF p_column_name = 'ATTRIBUTE7' THEN
1352: p_dff_usage_record.attribute7 := FND_API.G_TRUE;
1353: RETURN p_part_num_rec.attribute7;
1354: ELSIF p_column_name = 'ATTRIBUTE8' THEN
1355: p_dff_usage_record.attribute8 := FND_API.G_TRUE;
1356: RETURN p_part_num_rec.attribute8;
1357: ELSIF p_column_name = 'ATTRIBUTE9' THEN
1358: p_dff_usage_record.attribute9 := FND_API.G_TRUE;
1359: RETURN p_part_num_rec.attribute9;

Line 1358: p_dff_usage_record.attribute9 := FND_API.G_TRUE;

1354: ELSIF p_column_name = 'ATTRIBUTE8' THEN
1355: p_dff_usage_record.attribute8 := FND_API.G_TRUE;
1356: RETURN p_part_num_rec.attribute8;
1357: ELSIF p_column_name = 'ATTRIBUTE9' THEN
1358: p_dff_usage_record.attribute9 := FND_API.G_TRUE;
1359: RETURN p_part_num_rec.attribute9;
1360: ELSIF p_column_name = 'ATTRIBUTE10' THEN
1361: p_dff_usage_record.attribute10 := FND_API.G_TRUE;
1362: RETURN p_part_num_rec.attribute10;

Line 1361: p_dff_usage_record.attribute10 := FND_API.G_TRUE;

1357: ELSIF p_column_name = 'ATTRIBUTE9' THEN
1358: p_dff_usage_record.attribute9 := FND_API.G_TRUE;
1359: RETURN p_part_num_rec.attribute9;
1360: ELSIF p_column_name = 'ATTRIBUTE10' THEN
1361: p_dff_usage_record.attribute10 := FND_API.G_TRUE;
1362: RETURN p_part_num_rec.attribute10;
1363: ELSIF p_column_name = 'ATTRIBUTE11' THEN
1364: p_dff_usage_record.attribute11 := FND_API.G_TRUE;
1365: RETURN p_part_num_rec.attribute11;

Line 1364: p_dff_usage_record.attribute11 := FND_API.G_TRUE;

1360: ELSIF p_column_name = 'ATTRIBUTE10' THEN
1361: p_dff_usage_record.attribute10 := FND_API.G_TRUE;
1362: RETURN p_part_num_rec.attribute10;
1363: ELSIF p_column_name = 'ATTRIBUTE11' THEN
1364: p_dff_usage_record.attribute11 := FND_API.G_TRUE;
1365: RETURN p_part_num_rec.attribute11;
1366: ELSIF p_column_name = 'ATTRIBUTE12' THEN
1367: p_dff_usage_record.attribute12 := FND_API.G_TRUE;
1368: RETURN p_part_num_rec.attribute12;

Line 1367: p_dff_usage_record.attribute12 := FND_API.G_TRUE;

1363: ELSIF p_column_name = 'ATTRIBUTE11' THEN
1364: p_dff_usage_record.attribute11 := FND_API.G_TRUE;
1365: RETURN p_part_num_rec.attribute11;
1366: ELSIF p_column_name = 'ATTRIBUTE12' THEN
1367: p_dff_usage_record.attribute12 := FND_API.G_TRUE;
1368: RETURN p_part_num_rec.attribute12;
1369: ELSIF p_column_name = 'ATTRIBUTE13' THEN
1370: p_dff_usage_record.attribute13 := FND_API.G_TRUE;
1371: RETURN p_part_num_rec.attribute13;

Line 1370: p_dff_usage_record.attribute13 := FND_API.G_TRUE;

1366: ELSIF p_column_name = 'ATTRIBUTE12' THEN
1367: p_dff_usage_record.attribute12 := FND_API.G_TRUE;
1368: RETURN p_part_num_rec.attribute12;
1369: ELSIF p_column_name = 'ATTRIBUTE13' THEN
1370: p_dff_usage_record.attribute13 := FND_API.G_TRUE;
1371: RETURN p_part_num_rec.attribute13;
1372: ELSIF p_column_name = 'ATTRIBUTE14' THEN
1373: p_dff_usage_record.attribute14 := FND_API.G_TRUE;
1374: RETURN p_part_num_rec.attribute14;

Line 1373: p_dff_usage_record.attribute14 := FND_API.G_TRUE;

1369: ELSIF p_column_name = 'ATTRIBUTE13' THEN
1370: p_dff_usage_record.attribute13 := FND_API.G_TRUE;
1371: RETURN p_part_num_rec.attribute13;
1372: ELSIF p_column_name = 'ATTRIBUTE14' THEN
1373: p_dff_usage_record.attribute14 := FND_API.G_TRUE;
1374: RETURN p_part_num_rec.attribute14;
1375: ELSIF p_column_name = 'ATTRIBUTE15' THEN
1376: p_dff_usage_record.attribute15 := FND_API.G_TRUE;
1377: RETURN p_part_num_rec.attribute15;

Line 1376: p_dff_usage_record.attribute15 := FND_API.G_TRUE;

1372: ELSIF p_column_name = 'ATTRIBUTE14' THEN
1373: p_dff_usage_record.attribute14 := FND_API.G_TRUE;
1374: RETURN p_part_num_rec.attribute14;
1375: ELSIF p_column_name = 'ATTRIBUTE15' THEN
1376: p_dff_usage_record.attribute15 := FND_API.G_TRUE;
1377: RETURN p_part_num_rec.attribute15;
1378: ELSE
1379: RETURN NULL;
1380: END IF;

Line 1523: x_return_status := FND_API.G_RET_STS_SUCCESS;

1519: TYPE DYNAMIC_CUR IS REF CURSOR;
1520: c_err_cursor DYNAMIC_CUR;
1521:
1522: BEGIN
1523: x_return_status := FND_API.G_RET_STS_SUCCESS;
1524: x_msg_count := 0;
1525: x_msg_data := NULL;
1526: l_api_name := 'performDFFValidation';
1527: --

Line 1686: (SELECT CASE WHEN l_dff_fields_used.attribute1 = FND_API.G_TRUE

1682: ELSE
1683: -- set to NULL all other DFF fields which are not defined
1684: UPDATE ego_aml_intf intf
1685: SET attribute1 =
1686: (SELECT CASE WHEN l_dff_fields_used.attribute1 = FND_API.G_TRUE
1687: THEN intf.attribute1 ELSE NULL END
1688: FROM DUAL)
1689: ,attribute2 =
1690: (SELECT CASE WHEN l_dff_fields_used.attribute2 = FND_API.G_TRUE

Line 1690: (SELECT CASE WHEN l_dff_fields_used.attribute2 = FND_API.G_TRUE

1686: (SELECT CASE WHEN l_dff_fields_used.attribute1 = FND_API.G_TRUE
1687: THEN intf.attribute1 ELSE NULL END
1688: FROM DUAL)
1689: ,attribute2 =
1690: (SELECT CASE WHEN l_dff_fields_used.attribute2 = FND_API.G_TRUE
1691: THEN intf.attribute2 ELSE NULL END
1692: FROM DUAL)
1693: ,attribute3 =
1694: (SELECT CASE WHEN l_dff_fields_used.attribute3 = FND_API.G_TRUE

Line 1694: (SELECT CASE WHEN l_dff_fields_used.attribute3 = FND_API.G_TRUE

1690: (SELECT CASE WHEN l_dff_fields_used.attribute2 = FND_API.G_TRUE
1691: THEN intf.attribute2 ELSE NULL END
1692: FROM DUAL)
1693: ,attribute3 =
1694: (SELECT CASE WHEN l_dff_fields_used.attribute3 = FND_API.G_TRUE
1695: THEN intf.attribute3 ELSE NULL END
1696: FROM DUAL)
1697: ,attribute4 =
1698: (SELECT CASE WHEN l_dff_fields_used.attribute4 = FND_API.G_TRUE

Line 1698: (SELECT CASE WHEN l_dff_fields_used.attribute4 = FND_API.G_TRUE

1694: (SELECT CASE WHEN l_dff_fields_used.attribute3 = FND_API.G_TRUE
1695: THEN intf.attribute3 ELSE NULL END
1696: FROM DUAL)
1697: ,attribute4 =
1698: (SELECT CASE WHEN l_dff_fields_used.attribute4 = FND_API.G_TRUE
1699: THEN intf.attribute4 ELSE NULL END
1700: FROM DUAL)
1701: ,attribute5 =
1702: (SELECT CASE WHEN l_dff_fields_used.attribute5 = FND_API.G_TRUE

Line 1702: (SELECT CASE WHEN l_dff_fields_used.attribute5 = FND_API.G_TRUE

1698: (SELECT CASE WHEN l_dff_fields_used.attribute4 = FND_API.G_TRUE
1699: THEN intf.attribute4 ELSE NULL END
1700: FROM DUAL)
1701: ,attribute5 =
1702: (SELECT CASE WHEN l_dff_fields_used.attribute5 = FND_API.G_TRUE
1703: THEN intf.attribute5 ELSE NULL END
1704: FROM DUAL)
1705: ,attribute6 =
1706: (SELECT CASE WHEN l_dff_fields_used.attribute6 = FND_API.G_TRUE

Line 1706: (SELECT CASE WHEN l_dff_fields_used.attribute6 = FND_API.G_TRUE

1702: (SELECT CASE WHEN l_dff_fields_used.attribute5 = FND_API.G_TRUE
1703: THEN intf.attribute5 ELSE NULL END
1704: FROM DUAL)
1705: ,attribute6 =
1706: (SELECT CASE WHEN l_dff_fields_used.attribute6 = FND_API.G_TRUE
1707: THEN intf.attribute6 ELSE NULL END
1708: FROM DUAL)
1709: ,attribute7 =
1710: (SELECT CASE WHEN l_dff_fields_used.attribute7 = FND_API.G_TRUE

Line 1710: (SELECT CASE WHEN l_dff_fields_used.attribute7 = FND_API.G_TRUE

1706: (SELECT CASE WHEN l_dff_fields_used.attribute6 = FND_API.G_TRUE
1707: THEN intf.attribute6 ELSE NULL END
1708: FROM DUAL)
1709: ,attribute7 =
1710: (SELECT CASE WHEN l_dff_fields_used.attribute7 = FND_API.G_TRUE
1711: THEN intf.attribute7 ELSE NULL END
1712: FROM DUAL)
1713: ,attribute8 =
1714: (SELECT CASE WHEN l_dff_fields_used.attribute8 = FND_API.G_TRUE

Line 1714: (SELECT CASE WHEN l_dff_fields_used.attribute8 = FND_API.G_TRUE

1710: (SELECT CASE WHEN l_dff_fields_used.attribute7 = FND_API.G_TRUE
1711: THEN intf.attribute7 ELSE NULL END
1712: FROM DUAL)
1713: ,attribute8 =
1714: (SELECT CASE WHEN l_dff_fields_used.attribute8 = FND_API.G_TRUE
1715: THEN intf.attribute8 ELSE NULL END
1716: FROM DUAL)
1717: ,attribute9 =
1718: (SELECT CASE WHEN l_dff_fields_used.attribute9 = FND_API.G_TRUE

Line 1718: (SELECT CASE WHEN l_dff_fields_used.attribute9 = FND_API.G_TRUE

1714: (SELECT CASE WHEN l_dff_fields_used.attribute8 = FND_API.G_TRUE
1715: THEN intf.attribute8 ELSE NULL END
1716: FROM DUAL)
1717: ,attribute9 =
1718: (SELECT CASE WHEN l_dff_fields_used.attribute9 = FND_API.G_TRUE
1719: THEN intf.attribute9 ELSE NULL END
1720: FROM DUAL)
1721: ,attribute10 =
1722: (SELECT CASE WHEN l_dff_fields_used.attribute10 = FND_API.G_TRUE

Line 1722: (SELECT CASE WHEN l_dff_fields_used.attribute10 = FND_API.G_TRUE

1718: (SELECT CASE WHEN l_dff_fields_used.attribute9 = FND_API.G_TRUE
1719: THEN intf.attribute9 ELSE NULL END
1720: FROM DUAL)
1721: ,attribute10 =
1722: (SELECT CASE WHEN l_dff_fields_used.attribute10 = FND_API.G_TRUE
1723: THEN intf.attribute10 ELSE NULL END
1724: FROM DUAL)
1725: ,attribute11 =
1726: (SELECT CASE WHEN l_dff_fields_used.attribute11 = FND_API.G_TRUE

Line 1726: (SELECT CASE WHEN l_dff_fields_used.attribute11 = FND_API.G_TRUE

1722: (SELECT CASE WHEN l_dff_fields_used.attribute10 = FND_API.G_TRUE
1723: THEN intf.attribute10 ELSE NULL END
1724: FROM DUAL)
1725: ,attribute11 =
1726: (SELECT CASE WHEN l_dff_fields_used.attribute11 = FND_API.G_TRUE
1727: THEN intf.attribute11 ELSE NULL END
1728: FROM DUAL)
1729: ,attribute12 =
1730: (SELECT CASE WHEN l_dff_fields_used.attribute12 = FND_API.G_TRUE

Line 1730: (SELECT CASE WHEN l_dff_fields_used.attribute12 = FND_API.G_TRUE

1726: (SELECT CASE WHEN l_dff_fields_used.attribute11 = FND_API.G_TRUE
1727: THEN intf.attribute11 ELSE NULL END
1728: FROM DUAL)
1729: ,attribute12 =
1730: (SELECT CASE WHEN l_dff_fields_used.attribute12 = FND_API.G_TRUE
1731: THEN intf.attribute12 ELSE NULL END
1732: FROM DUAL)
1733: ,attribute13 =
1734: (SELECT CASE WHEN l_dff_fields_used.attribute13 = FND_API.G_TRUE

Line 1734: (SELECT CASE WHEN l_dff_fields_used.attribute13 = FND_API.G_TRUE

1730: (SELECT CASE WHEN l_dff_fields_used.attribute12 = FND_API.G_TRUE
1731: THEN intf.attribute12 ELSE NULL END
1732: FROM DUAL)
1733: ,attribute13 =
1734: (SELECT CASE WHEN l_dff_fields_used.attribute13 = FND_API.G_TRUE
1735: THEN intf.attribute13 ELSE NULL END
1736: FROM DUAL)
1737: ,attribute14 =
1738: (SELECT CASE WHEN l_dff_fields_used.attribute14 = FND_API.G_TRUE

Line 1738: (SELECT CASE WHEN l_dff_fields_used.attribute14 = FND_API.G_TRUE

1734: (SELECT CASE WHEN l_dff_fields_used.attribute13 = FND_API.G_TRUE
1735: THEN intf.attribute13 ELSE NULL END
1736: FROM DUAL)
1737: ,attribute14 =
1738: (SELECT CASE WHEN l_dff_fields_used.attribute14 = FND_API.G_TRUE
1739: THEN intf.attribute14 ELSE NULL END
1740: FROM DUAL)
1741: ,attribute15 =
1742: (SELECT CASE WHEN l_dff_fields_used.attribute15 = FND_API.G_TRUE

Line 1742: (SELECT CASE WHEN l_dff_fields_used.attribute15 = FND_API.G_TRUE

1738: (SELECT CASE WHEN l_dff_fields_used.attribute14 = FND_API.G_TRUE
1739: THEN intf.attribute14 ELSE NULL END
1740: FROM DUAL)
1741: ,attribute15 =
1742: (SELECT CASE WHEN l_dff_fields_used.attribute15 = FND_API.G_TRUE
1743: THEN intf.attribute15 ELSE NULL END
1744: FROM DUAL)
1745: WHERE CURRENT OF c_item_records;
1746: END IF;

Line 1805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1801: WHEN OTHERS THEN
1802: IF c_item_records%ISOPEN THEN
1803: CLOSE c_item_records;
1804: END IF;
1805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1806: x_msg_count := 1;
1807: -- for SQL errors
1808: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
1809: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

Line 1822: x_return_status := FND_API.G_RET_STS_SUCCESS;

1818: ,x_msg_data OUT NOCOPY VARCHAR2
1819: ) IS
1820: l_api_name VARCHAR2(30);
1821: BEGIN
1822: x_return_status := FND_API.G_RET_STS_SUCCESS;
1823: x_msg_count := 0;
1824: x_msg_data := NULL;
1825: l_api_name := 'populateProductionTable';
1826: INSERT INTO mtl_mfg_part_numbers

Line 2002: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1998: AND process_flag = G_PS_DFF_VAL_COMPLETE;
1999:
2000: EXCEPTION
2001: WHEN OTHERS THEN
2002: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2003: x_msg_count := 1;
2004: -- for SQL errors
2005: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
2006: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

Line 2042: x_return_status := FND_API.G_RET_STS_SUCCESS;

2038: l_message_has_token BOOLEAN;
2039: l_api_name VARCHAR2(30);
2040:
2041: BEGIN
2042: x_return_status := FND_API.G_RET_STS_SUCCESS;
2043: x_msg_count := 0;
2044: x_msg_data := NULL;
2045: l_api_name := 'Log_Errors_Now';
2046: l_application_context := 'EGO';

Line 2047: l_message_type := FND_API.G_RET_STS_ERROR;

2043: x_msg_count := 0;
2044: x_msg_data := NULL;
2045: l_api_name := 'Log_Errors_Now';
2046: l_application_context := 'EGO';
2047: l_message_type := FND_API.G_RET_STS_ERROR;
2048: -- this takes precedence over entity id
2049: l_entity_index := 0;
2050: l_intf_table_name := 'EGO_AML_INTF';
2051: l_message_has_token := FALSE;

Line 2302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2298: WHEN OTHERS THEN
2299: IF c_err_records%ISOPEN THEN
2300: CLOSE c_err_records;
2301: END IF;
2302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2303: x_msg_count := 1;
2304: -- for SQL errors
2305: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
2306: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

Line 2347: x_return_status := FND_API.G_RET_STS_SUCCESS;

2343: l_api_name VARCHAR2(50);
2344: l_table_name VARCHAR2(50);
2345:
2346: BEGIN
2347: x_return_status := FND_API.G_RET_STS_SUCCESS;
2348: x_msg_count := 0;
2349: x_msg_data := NULL;
2350: l_api_version := 1.0;
2351: l_api_name := 'DELETE_AML_INTF_LINES';

Line 2361: IF NOT FND_API.Compatible_API_Call (l_api_version,

2357: ||' p_data_set_id -'||p_data_set_id
2358: ||' p_delete_line_type -'||p_delete_line_type
2359: );
2360: -- standard check for API validation
2361: IF NOT FND_API.Compatible_API_Call (l_api_version,
2362: p_api_version,
2363: l_api_name,
2364: G_PKG_NAME) THEN
2365: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2365: x_return_status := FND_API.G_RET_STS_ERROR;

2361: IF NOT FND_API.Compatible_API_Call (l_api_version,
2362: p_api_version,
2363: l_api_name,
2364: G_PKG_NAME) THEN
2365: x_return_status := FND_API.G_RET_STS_ERROR;
2366: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
2367: ,p_count => x_msg_count
2368: ,p_data => x_msg_data);
2369: RETURN;

Line 2366: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

2362: p_api_version,
2363: l_api_name,
2364: G_PKG_NAME) THEN
2365: x_return_status := FND_API.G_RET_STS_ERROR;
2366: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
2367: ,p_count => x_msg_count
2368: ,p_data => x_msg_data);
2369: RETURN;
2370: END IF;

Line 2380: x_return_status := FND_API.G_RET_STS_ERROR;

2376: ,EGO_ITEM_PUB.G_INTF_DELETE_SUCCESS
2377: ,EGO_ITEM_PUB.G_INTF_DELETE_NONE
2378: )
2379: ) THEN
2380: x_return_status := FND_API.G_RET_STS_ERROR;
2381: fnd_message.set_name('EGO','EGO_IPI_INSUFFICIENT_PARAMS');
2382: fnd_message.set_token('PROG_NAME',G_PKG_NAME||'.'||l_api_name);
2383: fnd_msg_pub.Add;
2384: fnd_msg_pub.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 2384: fnd_msg_pub.Count_And_Get(p_encoded => FND_API.G_FALSE

2380: x_return_status := FND_API.G_RET_STS_ERROR;
2381: fnd_message.set_name('EGO','EGO_IPI_INSUFFICIENT_PARAMS');
2382: fnd_message.set_token('PROG_NAME',G_PKG_NAME||'.'||l_api_name);
2383: fnd_msg_pub.Add;
2384: fnd_msg_pub.Count_And_Get(p_encoded => FND_API.G_FALSE
2385: ,p_count => x_msg_count
2386: ,p_data => x_msg_data);
2387: RETURN;
2388: END IF;

Line 2390: IF FND_API.To_Boolean(p_commit) THEN

2386: ,p_data => x_msg_data);
2387: RETURN;
2388: END IF;
2389:
2390: IF FND_API.To_Boolean(p_commit) THEN
2391: SAVEPOINT DELETE_AML_INTF_LINES_SP;
2392: END IF;
2393:
2394: l_table_name := 'EGO_AML_INTF';

Line 2436: IF FND_API.To_Boolean(p_commit) THEN

2432: WHERE data_set_id = p_data_set_id
2433: AND process_flag = G_PS_SUCCESS;
2434: END IF;
2435:
2436: IF FND_API.To_Boolean(p_commit) THEN
2437: COMMIT WORK;
2438: END IF;
2439: log_now (p_log_level => G_DEBUG_LEVEL_PROCEDURE
2440: ,p_module => l_api_name

Line 2446: IF FND_API.To_Boolean(p_commit) THEN

2442: );
2443:
2444: EXCEPTION
2445: WHEN OTHERS THEN
2446: IF FND_API.To_Boolean(p_commit) THEN
2447: ROLLBACK TO DELETE_AML_INTF_LINES_SP;
2448: END IF;
2449: x_return_status := FND_API.G_RET_STS_ERROR;
2450: x_msg_count := 1;

Line 2449: x_return_status := FND_API.G_RET_STS_ERROR;

2445: WHEN OTHERS THEN
2446: IF FND_API.To_Boolean(p_commit) THEN
2447: ROLLBACK TO DELETE_AML_INTF_LINES_SP;
2448: END IF;
2449: x_return_status := FND_API.G_RET_STS_ERROR;
2450: x_msg_count := 1;
2451: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
2452: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
2453: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

Line 2498: -- currently only FND_API.G_TRUE is supported

2494: -- MODE_NORMAL = 'NORMAL'
2495: -- user is populating normal data, so perform date
2496: -- check and security check.
2497: -- : p_perform_security_check VARCHAR2
2498: -- currently only FND_API.G_TRUE is supported
2499: -- Whether security check needs to be done
2500: -- FND_API.G_TRUE - Perform data security check
2501: -- FND_API.G_FALSE - No data security check is done
2502: --

Line 2500: -- FND_API.G_TRUE - Perform data security check

2496: -- check and security check.
2497: -- : p_perform_security_check VARCHAR2
2498: -- currently only FND_API.G_TRUE is supported
2499: -- Whether security check needs to be done
2500: -- FND_API.G_TRUE - Perform data security check
2501: -- FND_API.G_FALSE - No data security check is done
2502: --
2503: --
2504: -- OUT : ERRBUF VARCHAR2

Line 2501: -- FND_API.G_FALSE - No data security check is done

2497: -- : p_perform_security_check VARCHAR2
2498: -- currently only FND_API.G_TRUE is supported
2499: -- Whether security check needs to be done
2500: -- FND_API.G_TRUE - Perform data security check
2501: -- FND_API.G_FALSE - No data security check is done
2502: --
2503: --
2504: -- OUT : ERRBUF VARCHAR2
2505: -- has the error message details

Line 2600: FND_API.to_boolean(NVL(p_perform_security_check,FND_API.G_TRUE));

2596: ELSE
2597: l_prog_mode_history := TRUE;
2598: END IF;
2599: l_perform_security_check :=
2600: FND_API.to_boolean(NVL(p_perform_security_check,FND_API.G_TRUE));
2601: --
2602: -- initialize default values on interface table
2603: --
2604: UPDATE ego_aml_intf

Line 2671: IF NVL(l_return_status,FND_API.G_RET_STS_SUCCESS)

2667: ,p_module => l_api_name
2668: ,p_message => 'Value to ID Conversion returned with status '
2669: ||l_return_status
2670: );
2671: IF NVL(l_return_status,FND_API.G_RET_STS_SUCCESS)
2672: <> FND_API.G_RET_STS_SUCCESS THEN
2673: ERRBUF := l_msg_data;
2674: RETCODE := G_CONC_RET_STS_ERROR;
2675: log_now (p_log_level => G_DEBUG_LEVEL_EXCEPTION

Line 2672: <> FND_API.G_RET_STS_SUCCESS THEN

2668: ,p_message => 'Value to ID Conversion returned with status '
2669: ||l_return_status
2670: );
2671: IF NVL(l_return_status,FND_API.G_RET_STS_SUCCESS)
2672: <> FND_API.G_RET_STS_SUCCESS THEN
2673: ERRBUF := l_msg_data;
2674: RETCODE := G_CONC_RET_STS_ERROR;
2675: log_now (p_log_level => G_DEBUG_LEVEL_EXCEPTION
2676: ,p_module => l_api_name

Line 2693: IF NVL(l_return_status,FND_API.G_RET_STS_SUCCESS)

2689: ,p_module => l_api_name
2690: ,p_message => 'Trans and Date validation returned with status '
2691: ||l_return_status
2692: );
2693: IF NVL(l_return_status,FND_API.G_RET_STS_SUCCESS)
2694: <> FND_API.G_RET_STS_SUCCESS THEN
2695: ERRBUF := l_msg_data;
2696: RETCODE := G_CONC_RET_STS_ERROR;
2697: log_now (p_log_level => G_DEBUG_LEVEL_EXCEPTION

Line 2694: <> FND_API.G_RET_STS_SUCCESS THEN

2690: ,p_message => 'Trans and Date validation returned with status '
2691: ||l_return_status
2692: );
2693: IF NVL(l_return_status,FND_API.G_RET_STS_SUCCESS)
2694: <> FND_API.G_RET_STS_SUCCESS THEN
2695: ERRBUF := l_msg_data;
2696: RETCODE := G_CONC_RET_STS_ERROR;
2697: log_now (p_log_level => G_DEBUG_LEVEL_EXCEPTION
2698: ,p_module => l_api_name

Line 2714: IF NVL(l_return_status,FND_API.G_RET_STS_SUCCESS)

2710: ,p_module => l_api_name
2711: ,p_message => 'Duplicate records check done with status '
2712: ||l_return_status
2713: );
2714: IF NVL(l_return_status,FND_API.G_RET_STS_SUCCESS)
2715: <> FND_API.G_RET_STS_SUCCESS THEN
2716: ERRBUF := l_msg_data;
2717: RETCODE := G_CONC_RET_STS_ERROR;
2718: log_now (p_log_level => G_DEBUG_LEVEL_EXCEPTION

Line 2715: <> FND_API.G_RET_STS_SUCCESS THEN

2711: ,p_message => 'Duplicate records check done with status '
2712: ||l_return_status
2713: );
2714: IF NVL(l_return_status,FND_API.G_RET_STS_SUCCESS)
2715: <> FND_API.G_RET_STS_SUCCESS THEN
2716: ERRBUF := l_msg_data;
2717: RETCODE := G_CONC_RET_STS_ERROR;
2718: log_now (p_log_level => G_DEBUG_LEVEL_EXCEPTION
2719: ,p_module => l_api_name

Line 2735: IF NVL(l_return_status,FND_API.G_RET_STS_SUCCESS)

2731: ,p_module => l_api_name
2732: ,p_message => 'CM Seggregation returned with status '
2733: ||l_return_status
2734: );
2735: IF NVL(l_return_status,FND_API.G_RET_STS_SUCCESS)
2736: <> FND_API.G_RET_STS_SUCCESS THEN
2737: ERRBUF := l_msg_data;
2738: RETCODE := G_CONC_RET_STS_ERROR;
2739: log_now (p_log_level => G_DEBUG_LEVEL_EXCEPTION

Line 2736: <> FND_API.G_RET_STS_SUCCESS THEN

2732: ,p_message => 'CM Seggregation returned with status '
2733: ||l_return_status
2734: );
2735: IF NVL(l_return_status,FND_API.G_RET_STS_SUCCESS)
2736: <> FND_API.G_RET_STS_SUCCESS THEN
2737: ERRBUF := l_msg_data;
2738: RETCODE := G_CONC_RET_STS_ERROR;
2739: log_now (p_log_level => G_DEBUG_LEVEL_EXCEPTION
2740: ,p_module => l_api_name

Line 2757: IF NVL(l_return_status,FND_API.G_RET_STS_SUCCESS)

2753: ,p_module => l_api_name
2754: ,p_message => 'Item Validation returned with status '
2755: ||l_return_status
2756: );
2757: IF NVL(l_return_status,FND_API.G_RET_STS_SUCCESS)
2758: <> FND_API.G_RET_STS_SUCCESS THEN
2759: ERRBUF := l_msg_data;
2760: RETCODE := G_CONC_RET_STS_ERROR;
2761: log_now (p_log_level => G_DEBUG_LEVEL_EXCEPTION

Line 2758: <> FND_API.G_RET_STS_SUCCESS THEN

2754: ,p_message => 'Item Validation returned with status '
2755: ||l_return_status
2756: );
2757: IF NVL(l_return_status,FND_API.G_RET_STS_SUCCESS)
2758: <> FND_API.G_RET_STS_SUCCESS THEN
2759: ERRBUF := l_msg_data;
2760: RETCODE := G_CONC_RET_STS_ERROR;
2761: log_now (p_log_level => G_DEBUG_LEVEL_EXCEPTION
2762: ,p_module => l_api_name

Line 2779: IF NVL(l_return_status,FND_API.G_RET_STS_SUCCESS)

2775: ,p_module => l_api_name
2776: ,p_message => 'Item DFF Validation returned with status '
2777: ||l_return_status
2778: );
2779: IF NVL(l_return_status,FND_API.G_RET_STS_SUCCESS)
2780: <> FND_API.G_RET_STS_SUCCESS THEN
2781: ERRBUF := l_msg_data;
2782: RETCODE := G_CONC_RET_STS_ERROR;
2783: log_now (p_log_level => G_DEBUG_LEVEL_EXCEPTION

Line 2780: <> FND_API.G_RET_STS_SUCCESS THEN

2776: ,p_message => 'Item DFF Validation returned with status '
2777: ||l_return_status
2778: );
2779: IF NVL(l_return_status,FND_API.G_RET_STS_SUCCESS)
2780: <> FND_API.G_RET_STS_SUCCESS THEN
2781: ERRBUF := l_msg_data;
2782: RETCODE := G_CONC_RET_STS_ERROR;
2783: log_now (p_log_level => G_DEBUG_LEVEL_EXCEPTION
2784: ,p_module => l_api_name

Line 2800: IF NVL(l_return_status,FND_API.G_RET_STS_SUCCESS)

2796: ,p_module => l_api_name
2797: ,p_message => 'Production table population returned with status '
2798: ||l_return_status
2799: );
2800: IF NVL(l_return_status,FND_API.G_RET_STS_SUCCESS)
2801: <> FND_API.G_RET_STS_SUCCESS THEN
2802: ERRBUF := l_msg_data;
2803: RETCODE := G_CONC_RET_STS_ERROR;
2804: log_now (p_log_level => G_DEBUG_LEVEL_EXCEPTION

Line 2801: <> FND_API.G_RET_STS_SUCCESS THEN

2797: ,p_message => 'Production table population returned with status '
2798: ||l_return_status
2799: );
2800: IF NVL(l_return_status,FND_API.G_RET_STS_SUCCESS)
2801: <> FND_API.G_RET_STS_SUCCESS THEN
2802: ERRBUF := l_msg_data;
2803: RETCODE := G_CONC_RET_STS_ERROR;
2804: log_now (p_log_level => G_DEBUG_LEVEL_EXCEPTION
2805: ,p_module => l_api_name

Line 2818: IF NVL(l_return_status,FND_API.G_RET_STS_SUCCESS)

2814: ,x_msg_count => l_msg_count
2815: ,x_msg_data => l_msg_data) THEN
2816: RETCODE := G_CONC_RET_STS_WARNING;
2817: ELSE
2818: IF NVL(l_return_status,FND_API.G_RET_STS_SUCCESS)
2819: <> FND_API.G_RET_STS_SUCCESS THEN
2820: ERRBUF := l_msg_data;
2821: RETCODE := G_CONC_RET_STS_ERROR;
2822: log_now (p_log_level => G_DEBUG_LEVEL_EXCEPTION

Line 2819: <> FND_API.G_RET_STS_SUCCESS THEN

2815: ,x_msg_data => l_msg_data) THEN
2816: RETCODE := G_CONC_RET_STS_WARNING;
2817: ELSE
2818: IF NVL(l_return_status,FND_API.G_RET_STS_SUCCESS)
2819: <> FND_API.G_RET_STS_SUCCESS THEN
2820: ERRBUF := l_msg_data;
2821: RETCODE := G_CONC_RET_STS_ERROR;
2822: log_now (p_log_level => G_DEBUG_LEVEL_EXCEPTION
2823: ,p_module => l_api_name

Line 2864: IF NVL(l_return_status,FND_API.G_RET_STS_SUCCESS)

2860: ,p_message => 'Returned from EGO_ITEM_OPEN_INTERFACE_PVT.'||
2861: 'Write_Error_into_concurrentlog with status '||
2862: l_return_status
2863: );
2864: IF NVL(l_return_status,FND_API.G_RET_STS_SUCCESS)
2865: = FND_API.G_RET_STS_UNEXP_ERROR THEN
2866: log_now (p_log_level => G_DEBUG_LEVEL_EXCEPTION
2867: ,p_module => l_api_name
2868: ,p_message => l_msg_data

Line 2865: = FND_API.G_RET_STS_UNEXP_ERROR THEN

2861: 'Write_Error_into_concurrentlog with status '||
2862: l_return_status
2863: );
2864: IF NVL(l_return_status,FND_API.G_RET_STS_SUCCESS)
2865: = FND_API.G_RET_STS_UNEXP_ERROR THEN
2866: log_now (p_log_level => G_DEBUG_LEVEL_EXCEPTION
2867: ,p_module => l_api_name
2868: ,p_message => l_msg_data
2869: );

Line 2874: ,p_commit => FND_API.G_FALSE

2870: END IF;
2871:
2872: IF p_delete_line_type <> EGO_ITEM_PUB.G_INTF_DELETE_NONE THEN
2873: Delete_AML_Interface_Lines(p_api_version => 1.0
2874: ,p_commit => FND_API.G_FALSE
2875: ,p_data_set_id => p_data_set_id
2876: ,p_delete_line_type => p_delete_line_type
2877: ,x_return_status => l_return_status
2878: ,x_msg_count => l_msg_count

Line 2881: IF NVL(l_return_status,FND_API.G_RET_STS_SUCCESS)

2877: ,x_return_status => l_return_status
2878: ,x_msg_count => l_msg_count
2879: ,x_msg_data => l_msg_data
2880: );
2881: IF NVL(l_return_status,FND_API.G_RET_STS_SUCCESS)
2882: <> FND_API.G_RET_STS_SUCCESS THEN
2883: ERRBUF := l_msg_data;
2884: RETCODE := G_CONC_RET_STS_ERROR;
2885: log_now (p_log_level => G_DEBUG_LEVEL_EXCEPTION

Line 2882: <> FND_API.G_RET_STS_SUCCESS THEN

2878: ,x_msg_count => l_msg_count
2879: ,x_msg_data => l_msg_data
2880: );
2881: IF NVL(l_return_status,FND_API.G_RET_STS_SUCCESS)
2882: <> FND_API.G_RET_STS_SUCCESS THEN
2883: ERRBUF := l_msg_data;
2884: RETCODE := G_CONC_RET_STS_ERROR;
2885: log_now (p_log_level => G_DEBUG_LEVEL_EXCEPTION
2886: ,p_module => l_api_name