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

Line 33: l_get_default VARCHAR2(1) := FND_API.G_TRUE;

29: ) RETURN VARCHAR2
30: IS
31: -- variables --
32: l_revision VARCHAR2(3) := null;
33: l_get_default VARCHAR2(1) := FND_API.G_TRUE;
34: BEGIN
35: if (p_mat_transaction_type = 'MAT_ISSUE') then -- material issue
36: --swai: bug 6654197 - allow user to specify revision based on profile option
37: if (nvl(fnd_profile.value('CSD_DEF_CUR_REVISION_MTL_TXN'), 'Y') = 'N' ) then

Line 38: l_get_default := FND_API.G_FALSE;

34: BEGIN
35: if (p_mat_transaction_type = 'MAT_ISSUE') then -- material issue
36: --swai: bug 6654197 - allow user to specify revision based on profile option
37: if (nvl(fnd_profile.value('CSD_DEF_CUR_REVISION_MTL_TXN'), 'Y') = 'N' ) then
38: l_get_default := FND_API.G_FALSE;
39: end if;
40: elsif (p_mat_transaction_type = 'JOB_COMP') then -- job completion
41: -- swai: bug 6654197 - allow user to specify revision based on profile option
42: if (nvl(fnd_profile.value('CSD_DEF_CUR_REVISION_JOB_COMP'), 'Y') = 'N' ) then

Line 43: l_get_default := FND_API.G_FALSE;

39: end if;
40: elsif (p_mat_transaction_type = 'JOB_COMP') then -- job completion
41: -- swai: bug 6654197 - allow user to specify revision based on profile option
42: if (nvl(fnd_profile.value('CSD_DEF_CUR_REVISION_JOB_COMP'), 'Y') = 'N' ) then
43: l_get_default := FND_API.G_FALSE;
44: end if;
45: end if;
46: if (l_get_default = FND_API.G_TRUE) then
47: l_revision := bom_revisions.get_item_revision_fn

Line 46: if (l_get_default = FND_API.G_TRUE) then

42: if (nvl(fnd_profile.value('CSD_DEF_CUR_REVISION_JOB_COMP'), 'Y') = 'N' ) then
43: l_get_default := FND_API.G_FALSE;
44: end if;
45: end if;
46: if (l_get_default = FND_API.G_TRUE) then
47: l_revision := bom_revisions.get_item_revision_fn
48: ('EXCLUDE_OPEN_HOLD', -- eco_status
49: 'ALL', -- examine_type
50: p_org_id, -- org_id

Line 286: x_return_status := FND_API.G_RET_STS_SUCCESS;

282:
283: -- Generated job name does exist either in the interface or wip_entities table,
284: -- Success is returned
285:
286: x_return_status := FND_API.G_RET_STS_SUCCESS;
287: RETURN;
288:
289: ELSE
290:

Line 293: x_return_status := FND_API.G_RET_STS_ERROR;

289: ELSE
290:
291: -- Job exists in wip_job_schedule_interface table, hence return Error status
292:
293: x_return_status := FND_API.G_RET_STS_ERROR;
294: RETURN;
295:
296:
297: END IF;

Line 304: x_return_status := FND_API.G_RET_STS_ERROR;

300: ELSE
301:
302: -- Job exists in wip_entities table, hence return Error status
303:
304: x_return_status := FND_API.G_RET_STS_ERROR;
305: RETURN;
306:
307:
308: END IF;

Line 350: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

346: Validate_job_name ( p_job_name => x_job_name,
347: p_organization_id => p_organization_id,
348: x_return_status => l_return_status ) ;
349:
350: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
351:
352: -- Generated job name does not exist both in the interface and wip_entities table, so exit the loop
353:
354: exit;

Line 414: x_return_status := FND_API.G_RET_STS_SUCCESS;

410: l_mod_name||'begin',
411: 'Entering procedure insert_job_header' );
412: END IF;
413:
414: x_return_status := FND_API.G_RET_STS_SUCCESS;
415:
416:
417: -- Populate the record l_job_header_rec
418:

Line 508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

504: WHEN OTHERS THEN
505: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_HEADER_INSERT_ERR');
506: FND_MESSAGE.SET_TOKEN('JOB_NAME', l_job_header_rec.job_name );
507: FND_MSG_PUB.ADD;
508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
509: RETURN;
510: END;
511:
512:

Line 573: x_return_status := FND_API.G_RET_STS_SUCCESS;

569: l_mod_name||'begin',
570: 'Entering procedure insert_job_header' );
571: END IF;
572:
573: x_return_status := FND_API.G_RET_STS_SUCCESS;
574:
575:
576: -- Populate the record l_job_header_rec
577:

Line 701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

697: WHEN OTHERS THEN
698: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_DETAILS_INSERT_ERR');
699: FND_MESSAGE.SET_TOKEN('JOB_NAME', l_job_details_rec.wip_entity_id);
700: FND_MSG_PUB.ADD;
701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
702: RETURN;
703: END;
704:
705:

Line 751: x_return_status := FND_API.G_RET_STS_SUCCESS;

747: lc_mod_name||'begin',
748: 'Entering procedure insert_job_header' );
749: END IF;
750:
751: x_return_status := FND_API.G_RET_STS_SUCCESS;
752:
753:
754:
755:

Line 844: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

840: WHEN OTHERS THEN
841: FND_MESSAGE.SET_NAME('CSD','CSD_TXNS_HEADER_INSERT_ERR');
842: FND_MESSAGE.SET_TOKEN('JOB_NAME', l_transactions_interface_rec.transaction_source_id );
843: FND_MSG_PUB.ADD;
844: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
845: RETURN;
846: END;
847:
848:

Line 885: x_return_status := FND_API.G_RET_STS_SUCCESS;

881: lc_mod_name||'begin',
882: 'Entering procedure update_transactions_header' );
883: END IF;
884:
885: x_return_status := FND_API.G_RET_STS_SUCCESS;
886:
887:
888:
889: --update table mtl_transactions_interface

Line 910: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

906: EXCEPTION
907: WHEN OTHERS THEN
908: FND_MESSAGE.SET_NAME('CSD','CSD_TXNS_HEADER_UPDATE_ERR');
909: FND_MSG_PUB.ADD;
910: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
911: RETURN;
912: END;
913:
914:

Line 955: x_return_status := FND_API.G_RET_STS_SUCCESS;

951: lc_mod_name||'begin',
952: 'Entering procedure insert_transaction_lots' );
953: END IF;
954:
955: x_return_status := FND_API.G_RET_STS_SUCCESS;
956:
957:
958: -- Populate the row who columns
959:

Line 999: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

995: EXCEPTION
996: WHEN OTHERS THEN
997: FND_MESSAGE.SET_NAME('CSD','CSD_TXN_LOTS_INSERT_ERR');
998: FND_MSG_PUB.ADD;
999: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1000: RETURN;
1001: END;
1002:
1003:

Line 1045: x_return_status := FND_API.G_RET_STS_SUCCESS;

1041: lc_mod_name||'begin',
1042: 'Entering procedure insert_upd_serial_numbers' );
1043: END IF;
1044:
1045: x_return_status := FND_API.G_RET_STS_SUCCESS;
1046:
1047: Select count(*) into l_row_exists from mtl_serial_numbers_interface
1048: where transaction_interface_id =
1049: p_srl_nmbrs_interface_rec.transaction_interface_id;

Line 1065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1061: EXCEPTION
1062: WHEN OTHERS THEN
1063: FND_MESSAGE.SET_NAME('CSD','CSD_SRL_NMBRS_UPDATE_ERR');
1064: FND_MSG_PUB.ADD;
1065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1066: RETURN;
1067: END;
1068:
1069: ELSE

Line 1108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1104: EXCEPTION
1105: WHEN OTHERS THEN
1106: FND_MESSAGE.SET_NAME('CSD','CSD_SRL_NMBRS_INSERT_ERR');
1107: FND_MSG_PUB.ADD;
1108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1109: RETURN;
1110: END;
1111:
1112: END IF;

Line 1169: x_return_status := FND_API.G_RET_STS_SUCCESS;

1165: lc_mod_name||'begin',
1166: 'Entering procedure insert_job_header' );
1167: END IF;
1168:
1169: x_return_status := FND_API.G_RET_STS_SUCCESS;
1170:
1171:
1172: -- Populate the constant values
1173:

Line 1245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1241: EXCEPTION
1242: WHEN OTHERS THEN
1243: FND_MESSAGE.SET_NAME('CSD','CSD_WIP_COST_TXN_INSERT_ERR');
1244: FND_MSG_PUB.ADD;
1245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1246: RETURN;
1247:
1248: END;
1249:

Line 1304: x_return_status := FND_API.G_RET_STS_SUCCESS;

1300: lc_mod_name||'begin',
1301: 'Entering procedure insert_wip_move_txn' );
1302: END IF;
1303:
1304: x_return_status := FND_API.G_RET_STS_SUCCESS;
1305:
1306:
1307: -- Populate the constant values
1308:

Line 1374: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1370: EXCEPTION
1371: WHEN OTHERS THEN
1372: FND_MESSAGE.SET_NAME('CSD','CSD_WIP_MOVE_TXN_INSERT_ERR');
1373: FND_MSG_PUB.ADD;
1374: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1375: RETURN;
1376:
1377: END;
1378:

Line 1429: IF NOT FND_API.Compatible_API_Call(lc_api_version_number,

1425:
1426: SAVEPOINT PROCESS_JOB_COMP_TXN_PVT;
1427:
1428: -- Standard call to check for call compatibility.
1429: IF NOT FND_API.Compatible_API_Call(lc_api_version_number,
1430: p_api_version_number,
1431: lc_api_name,
1432: G_PKG_NAME) THEN
1433: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1433: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1429: IF NOT FND_API.Compatible_API_Call(lc_api_version_number,
1430: p_api_version_number,
1431: lc_api_name,
1432: G_PKG_NAME) THEN
1433: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1434: END IF;
1435:
1436: IF FND_API.to_boolean(p_init_msg_list) THEN
1437: FND_MSG_PUB.initialize;

Line 1436: IF FND_API.to_boolean(p_init_msg_list) THEN

1432: G_PKG_NAME) THEN
1433: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1434: END IF;
1435:
1436: IF FND_API.to_boolean(p_init_msg_list) THEN
1437: FND_MSG_PUB.initialize;
1438: END IF;
1439:
1440: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1440: x_return_status := FND_API.G_RET_STS_SUCCESS;

1436: IF FND_API.to_boolean(p_init_msg_list) THEN
1437: FND_MSG_PUB.initialize;
1438: END IF;
1439:
1440: x_return_status := FND_API.G_RET_STS_SUCCESS;
1441:
1442: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1443: FND_LOG.STRING( FND_LOG.LEVEL_EVENT,
1444: lc_mod_name||'beforecallinsertjobcomptxn',

Line 1449: p_init_msg_list => fnd_api.g_false ,

1445: 'Just before calling insert_job_comp_txn');
1446: END IF;
1447: insert_job_comp_txn (
1448: p_api_version_number => lc_api_version_number,
1449: p_init_msg_list => fnd_api.g_false ,
1450: p_commit => fnd_api.g_false,
1451: p_validation_level => p_validation_level,
1452: x_return_status => x_return_status,
1453: x_msg_count => x_msg_count,

Line 1450: p_commit => fnd_api.g_false,

1446: END IF;
1447: insert_job_comp_txn (
1448: p_api_version_number => lc_api_version_number,
1449: p_init_msg_list => fnd_api.g_false ,
1450: p_commit => fnd_api.g_false,
1451: p_validation_level => p_validation_level,
1452: x_return_status => x_return_status,
1453: x_msg_count => x_msg_count,
1454: x_msg_data => x_msg_data,

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

1456: x_need_details_flag => l_need_details_flag,
1457: x_transaction_header_id => l_transaction_header_id
1458: );
1459:
1460: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1461: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_COMP_TXN_FAILURE');
1462: FND_MSG_PUB.ADD;
1463: RAISE FND_API.G_EXC_ERROR;
1464: END IF;

Line 1463: RAISE FND_API.G_EXC_ERROR;

1459:
1460: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1461: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_COMP_TXN_FAILURE');
1462: FND_MSG_PUB.ADD;
1463: RAISE FND_API.G_EXC_ERROR;
1464: END IF;
1465:
1466: -- if no need for details, then we can process transactions and commit
1467: IF l_need_details_flag = 'F' THEN

Line 1475: p_init_msg_list => fnd_api.g_false ,

1471: 'Just before calling process_mti_transactions');
1472: END IF;
1473: process_mti_transactions(
1474: p_api_version_number => lc_api_version_number,
1475: p_init_msg_list => fnd_api.g_false ,
1476: p_commit => fnd_api.g_false,
1477: p_validation_level => p_validation_level,
1478: x_return_status => x_return_status,
1479: x_msg_count => x_msg_count,

Line 1476: p_commit => fnd_api.g_false,

1472: END IF;
1473: process_mti_transactions(
1474: p_api_version_number => lc_api_version_number,
1475: p_init_msg_list => fnd_api.g_false ,
1476: p_commit => fnd_api.g_false,
1477: p_validation_level => p_validation_level,
1478: x_return_status => x_return_status,
1479: x_msg_count => x_msg_count,
1480: x_msg_data => x_msg_data,

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

1480: x_msg_data => x_msg_data,
1481: p_txn_header_id => l_transaction_header_id
1482: -- p_txn_type IN VARCHAR2
1483: );
1484: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1485: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_COMP_TXN_FAILURE');
1486: FND_MSG_PUB.ADD;
1487: RAISE FND_API.G_EXC_ERROR;
1488: END IF;

Line 1487: RAISE FND_API.G_EXC_ERROR;

1483: );
1484: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1485: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_COMP_TXN_FAILURE');
1486: FND_MSG_PUB.ADD;
1487: RAISE FND_API.G_EXC_ERROR;
1488: END IF;
1489: ELSE
1490: --if we need details, pass back the transaction header id
1491: x_transaction_header_id := l_transaction_header_id;

Line 1495: IF l_need_details_flag = 'F' and FND_API.to_Boolean( p_commit )

1491: x_transaction_header_id := l_transaction_header_id;
1492: END IF;
1493:
1494: -- Check before commit
1495: IF l_need_details_flag = 'F' and FND_API.to_Boolean( p_commit )
1496: THEN
1497: COMMIT WORK;
1498: END IF;
1499:

Line 1501: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1497: COMMIT WORK;
1498: END IF;
1499:
1500: EXCEPTION
1501: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1502: ROLLBACK to PROCESS_JOB_COMP_TXN_PVT ;
1503: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1504:
1505: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 1503: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1499:
1500: EXCEPTION
1501: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1502: ROLLBACK to PROCESS_JOB_COMP_TXN_PVT ;
1503: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1504:
1505: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1506: p_count => x_msg_count,
1507: p_data => x_msg_data);

Line 1505: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

1501: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1502: ROLLBACK to PROCESS_JOB_COMP_TXN_PVT ;
1503: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1504:
1505: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1506: p_count => x_msg_count,
1507: p_data => x_msg_data);
1508:
1509: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 1516: WHEN FND_API.G_EXC_ERROR THEN

1512: 'G_EXC_UNEXPECTED_ERROR Exception');
1513: END IF;
1514:
1515:
1516: WHEN FND_API.G_EXC_ERROR THEN
1517: ROLLBACK to PROCESS_JOB_COMP_TXN_PVT ;
1518: x_return_status := FND_API.G_RET_STS_ERROR;
1519:
1520: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 1518: x_return_status := FND_API.G_RET_STS_ERROR;

1514:
1515:
1516: WHEN FND_API.G_EXC_ERROR THEN
1517: ROLLBACK to PROCESS_JOB_COMP_TXN_PVT ;
1518: x_return_status := FND_API.G_RET_STS_ERROR;
1519:
1520: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1521: p_count => x_msg_count,
1522: p_data => x_msg_data);

Line 1520: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

1516: WHEN FND_API.G_EXC_ERROR THEN
1517: ROLLBACK to PROCESS_JOB_COMP_TXN_PVT ;
1518: x_return_status := FND_API.G_RET_STS_ERROR;
1519:
1520: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1521: p_count => x_msg_count,
1522: p_data => x_msg_data);
1523:
1524: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 1532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1528: END IF;
1529:
1530: WHEN OTHERS THEN
1531: ROLLBACK to PROCESS_JOB_COMP_TXN_PVT ;
1532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1533:
1534: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1535: -- Add Unexpected Error to Message List, here SQLERRM is used for
1536: -- getting the error

Line 1541: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

1537: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
1538: p_procedure_name => lc_api_name );
1539: END IF;
1540:
1541: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1542: p_count => x_msg_count,
1543: p_data => x_msg_data);
1544:
1545: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 1715: IF NOT FND_API.Compatible_API_Call(lc_api_version_number,

1711:
1712: SAVEPOINT INSERT_JOB_COMP_TXN_PVT;
1713:
1714: -- Standard call to check for call compatibility.
1715: IF NOT FND_API.Compatible_API_Call(lc_api_version_number,
1716: p_api_version_number,
1717: lc_api_name,
1718: G_PKG_NAME) THEN
1719: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1719: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1715: IF NOT FND_API.Compatible_API_Call(lc_api_version_number,
1716: p_api_version_number,
1717: lc_api_name,
1718: G_PKG_NAME) THEN
1719: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1720: END IF;
1721:
1722:
1723: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 1723: IF FND_API.to_boolean(p_init_msg_list) THEN

1719: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1720: END IF;
1721:
1722:
1723: IF FND_API.to_boolean(p_init_msg_list) THEN
1724: FND_MSG_PUB.initialize;
1725: END IF;
1726:
1727: -- initialize out params

Line 1728: x_return_status := FND_API.G_RET_STS_SUCCESS;

1724: FND_MSG_PUB.initialize;
1725: END IF;
1726:
1727: -- initialize out params
1728: x_return_status := FND_API.G_RET_STS_SUCCESS;
1729: x_need_details_flag := 'F';
1730:
1731: -- generate transaction_id
1732: open get_mtl_header_id;

Line 1760: RAISE FND_API.G_EXC_ERROR;

1756: IF l_last_move_allowed = 'N' THEN
1757: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_COMP_MV_NOT_ALL');
1758: FND_MSG_PUB.ADD;
1759: close get_last_operation_dtls;
1760: RAISE FND_API.G_EXC_ERROR;
1761: END IF;
1762: END IF;
1763: close get_last_operation_dtls;
1764:

Line 1768: RAISE FND_API.G_EXC_ERROR;

1764:
1765: IF l_transaction_quantity <= 0 THEN
1766: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_COMP_ZER_QTY');
1767: FND_MSG_PUB.ADD;
1768: RAISE FND_API.G_EXC_ERROR;
1769: END IF;
1770:
1771: l_transactions_interface_rec.source_code := lc_completion_source_code;
1772: l_transactions_interface_rec.transaction_date := sysdate;

Line 1883: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1879: fetch get_mtl_header_id into l_transactions_interface_rec.transaction_interface_id;
1880: close get_mtl_header_id;
1881: END IF;
1882:
1883: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1884: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1885: END IF;
1886: END LOOP;
1887: ELSE -- Quantity = 1

Line 1884: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1880: close get_mtl_header_id;
1881: END IF;
1882:
1883: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1884: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1885: END IF;
1886: END LOOP;
1887: ELSE -- Quantity = 1
1888: --insert into table mtl_transactions_interface

Line 1898: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1894:
1895: insert_transactions_header(p_transactions_interface_rec => l_transactions_interface_rec,
1896: x_return_status => x_return_status );
1897:
1898: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1899: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1900: END IF;
1901: END IF;
1902:

Line 1899: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1895: insert_transactions_header(p_transactions_interface_rec => l_transactions_interface_rec,
1896: x_return_status => x_return_status );
1897:
1898: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1899: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1900: END IF;
1901: END IF;
1902:
1903: ELSE -- l_serial_number_control_code check

Line 1919: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1915:
1916: insert_transactions_header(p_transactions_interface_rec => l_transactions_interface_rec,
1917: x_return_status => x_return_status );
1918:
1919: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1921: END IF;
1922: END IF; -- l_serial_number_control_code check
1923:

Line 1920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1916: insert_transactions_header(p_transactions_interface_rec => l_transactions_interface_rec,
1917: x_return_status => x_return_status );
1918:
1919: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1921: END IF;
1922: END IF; -- l_serial_number_control_code check
1923:
1924: -- Regardless of whether or not details are needed, pass back

Line 1929: IF FND_API.to_Boolean( p_commit )

1925: -- the transaction header ID.
1926: x_transaction_header_id := l_transactions_interface_rec.transaction_header_id;
1927:
1928: -- Standard check for p_commit
1929: IF FND_API.to_Boolean( p_commit )
1930: THEN
1931: COMMIT WORK;
1932: END IF;
1933:

Line 1935: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1931: COMMIT WORK;
1932: END IF;
1933:
1934: EXCEPTION
1935: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1936: ROLLBACK to INSERT_JOB_COMP_TXN_PVT ;
1937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1938:
1939: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 1937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1933:
1934: EXCEPTION
1935: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1936: ROLLBACK to INSERT_JOB_COMP_TXN_PVT ;
1937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1938:
1939: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1940: p_count => x_msg_count,
1941: p_data => x_msg_data);

Line 1939: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

1935: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1936: ROLLBACK to INSERT_JOB_COMP_TXN_PVT ;
1937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1938:
1939: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1940: p_count => x_msg_count,
1941: p_data => x_msg_data);
1942:
1943: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 1950: WHEN FND_API.G_EXC_ERROR THEN

1946: 'G_EXC_UNEXPECTED_ERROR Exception');
1947: END IF;
1948:
1949:
1950: WHEN FND_API.G_EXC_ERROR THEN
1951: ROLLBACK to INSERT_JOB_COMP_TXN_PVT ;
1952: x_return_status := FND_API.G_RET_STS_ERROR;
1953:
1954:

Line 1952: x_return_status := FND_API.G_RET_STS_ERROR;

1948:
1949:
1950: WHEN FND_API.G_EXC_ERROR THEN
1951: ROLLBACK to INSERT_JOB_COMP_TXN_PVT ;
1952: x_return_status := FND_API.G_RET_STS_ERROR;
1953:
1954:
1955: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1956: p_count => x_msg_count,

Line 1955: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

1951: ROLLBACK to INSERT_JOB_COMP_TXN_PVT ;
1952: x_return_status := FND_API.G_RET_STS_ERROR;
1953:
1954:
1955: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1956: p_count => x_msg_count,
1957: p_data => x_msg_data);
1958:
1959: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 1967: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1963: END IF;
1964:
1965: WHEN OTHERS THEN
1966: ROLLBACK to INSERT_JOB_COMP_TXN_PVT ;
1967: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1968:
1969: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1970:
1971: -- Add Unexpected Error to Message List, here SQLERRM is used for

Line 1978: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

1974: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
1975: p_procedure_name => lc_api_name );
1976: END IF;
1977:
1978: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1979: p_count => x_msg_count,
1980: p_data => x_msg_data);
1981:
1982: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 2022: IF NOT FND_API.Compatible_API_Call(lc_api_version_number,

2018:
2019: SAVEPOINT PROCESS_MTI_TRANSACTIONS_PVT;
2020:
2021: -- Standard call to check for call compatibility.
2022: IF NOT FND_API.Compatible_API_Call(lc_api_version_number,
2023: p_api_version_number,
2024: lc_api_name,
2025: G_PKG_NAME) THEN
2026: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2026: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2022: IF NOT FND_API.Compatible_API_Call(lc_api_version_number,
2023: p_api_version_number,
2024: lc_api_name,
2025: G_PKG_NAME) THEN
2026: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2027: END IF;
2028:
2029:
2030: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 2030: IF FND_API.to_boolean(p_init_msg_list) THEN

2026: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2027: END IF;
2028:
2029:
2030: IF FND_API.to_boolean(p_init_msg_list) THEN
2031: FND_MSG_PUB.initialize;
2032: END IF;
2033: x_return_status := FND_API.G_RET_STS_SUCCESS;
2034:

Line 2033: x_return_status := FND_API.G_RET_STS_SUCCESS;

2029:
2030: IF FND_API.to_boolean(p_init_msg_list) THEN
2031: FND_MSG_PUB.initialize;
2032: END IF;
2033: x_return_status := FND_API.G_RET_STS_SUCCESS;
2034:
2035: -- Populate the constant values
2036: l_table := lc_MTI_source_table;
2037:

Line 2046: p_init_msg_list => fnd_api.g_false, --'T', -- fnd_api.g_false ,

2042: END IF;
2043:
2044: l_return_count := INV_TXN_MANAGER_PUB.process_Transactions(
2045: p_api_version => lc_api_version_number, --1.0, -- ,
2046: p_init_msg_list => fnd_api.g_false, --'T', -- fnd_api.g_false ,
2047: p_commit => fnd_api.g_false, --'T', -- fnd_api.g_false ,
2048: p_validation_level => p_validation_level ,
2049: x_return_status => x_return_status,
2050: x_msg_count => x_msg_count,

Line 2047: p_commit => fnd_api.g_false, --'T', -- fnd_api.g_false ,

2043:
2044: l_return_count := INV_TXN_MANAGER_PUB.process_Transactions(
2045: p_api_version => lc_api_version_number, --1.0, -- ,
2046: p_init_msg_list => fnd_api.g_false, --'T', -- fnd_api.g_false ,
2047: p_commit => fnd_api.g_false, --'T', -- fnd_api.g_false ,
2048: p_validation_level => p_validation_level ,
2049: x_return_status => x_return_status,
2050: x_msg_count => x_msg_count,
2051: x_msg_data => x_msg_data,

Line 2057: x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

2053: p_table => l_table,
2054: p_header_id => p_txn_header_id );
2055:
2056: IF ( txn_int_error_exists( p_txn_header_id) or
2057: x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
2058: FND_MESSAGE.SET_NAME('CSD','CSD_PROCESS_MTI_TXN_FAILURE');
2059: FND_MSG_PUB.ADD;
2060: RAISE FND_API.G_EXC_ERROR;
2061: END IF;

Line 2060: RAISE FND_API.G_EXC_ERROR;

2056: IF ( txn_int_error_exists( p_txn_header_id) or
2057: x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
2058: FND_MESSAGE.SET_NAME('CSD','CSD_PROCESS_MTI_TXN_FAILURE');
2059: FND_MSG_PUB.ADD;
2060: RAISE FND_API.G_EXC_ERROR;
2061: END IF;
2062:
2063: -- Standard check for p_commit
2064: IF FND_API.to_Boolean( p_commit )

Line 2064: IF FND_API.to_Boolean( p_commit )

2060: RAISE FND_API.G_EXC_ERROR;
2061: END IF;
2062:
2063: -- Standard check for p_commit
2064: IF FND_API.to_Boolean( p_commit )
2065: THEN
2066: COMMIT WORK;
2067: END IF;
2068:

Line 2070: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2066: COMMIT WORK;
2067: END IF;
2068:
2069: EXCEPTION
2070: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2071: ROLLBACK to PROCESS_MTI_TRANSACTIONS_PVT ;
2072: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2073:
2074: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 2072: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2068:
2069: EXCEPTION
2070: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2071: ROLLBACK to PROCESS_MTI_TRANSACTIONS_PVT ;
2072: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2073:
2074: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2075: p_count => x_msg_count,
2076: p_data => x_msg_data);

Line 2074: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

2070: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2071: ROLLBACK to PROCESS_MTI_TRANSACTIONS_PVT ;
2072: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2073:
2074: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2075: p_count => x_msg_count,
2076: p_data => x_msg_data);
2077:
2078: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 2085: WHEN FND_API.G_EXC_ERROR THEN

2081: 'G_EXC_UNEXPECTED_ERROR Exception');
2082: END IF;
2083:
2084:
2085: WHEN FND_API.G_EXC_ERROR THEN
2086: ROLLBACK to PROCESS_MTI_TRANSACTIONS_PVT ;
2087: x_return_status := FND_API.G_RET_STS_ERROR;
2088:
2089: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 2087: x_return_status := FND_API.G_RET_STS_ERROR;

2083:
2084:
2085: WHEN FND_API.G_EXC_ERROR THEN
2086: ROLLBACK to PROCESS_MTI_TRANSACTIONS_PVT ;
2087: x_return_status := FND_API.G_RET_STS_ERROR;
2088:
2089: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2090: p_count => x_msg_count,
2091: p_data => x_msg_data);

Line 2089: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

2085: WHEN FND_API.G_EXC_ERROR THEN
2086: ROLLBACK to PROCESS_MTI_TRANSACTIONS_PVT ;
2087: x_return_status := FND_API.G_RET_STS_ERROR;
2088:
2089: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2090: p_count => x_msg_count,
2091: p_data => x_msg_data);
2092:
2093: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 2101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2097: END IF;
2098:
2099: WHEN OTHERS THEN
2100: ROLLBACK to PROCESS_MTI_TRANSACTIONS_PVT ;
2101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2102:
2103: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2104: -- Add Unexpected Error to Message List, here SQLERRM is used for
2105: -- getting the error

Line 2110: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

2106: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
2107: p_procedure_name => lc_api_name );
2108: END IF;
2109:
2110: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2111: p_count => x_msg_count,
2112: p_data => x_msg_data);
2113:
2114: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 2212: IF NOT FND_API.Compatible_API_Call

2208: END IF;
2209:
2210: SAVEPOINT PROCESS_OPER_COMP_TXN_PVT;
2211: -- Standard call to check for call compatibility.
2212: IF NOT FND_API.Compatible_API_Call
2213: (lc_api_version_number,
2214: p_api_version_number,
2215: lc_api_name,
2216: G_PKG_NAME)

Line 2218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2214: p_api_version_number,
2215: lc_api_name,
2216: G_PKG_NAME)
2217: THEN
2218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2219: END IF;
2220:
2221:
2222: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 2222: IF FND_API.to_boolean(p_init_msg_list) THEN

2218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2219: END IF;
2220:
2221:
2222: IF FND_API.to_boolean(p_init_msg_list) THEN
2223: FND_MSG_PUB.initialize;
2224: END IF;
2225:
2226:

Line 2229: x_return_status := FND_API.G_RET_STS_SUCCESS;

2225:
2226:
2227:
2228:
2229: x_return_status := FND_API.G_RET_STS_SUCCESS;
2230:
2231:
2232: -- Populate the constant values
2233:

Line 2274: RAISE FND_API.G_EXC_ERROR;

2270: IF l_prev_wip_entity_id = p_mv_txn_dtls_tbl(mv_ctr).wip_entity_id THEN
2271: IF l_prev_to_operation_seq_num <> p_mv_txn_dtls_tbl(mv_ctr).fm_operation_seq_num THEN
2272: FND_MESSAGE.SET_NAME('CSD','CSD_OP_COMP_SEQ_ERROR');
2273: FND_MSG_PUB.ADD;
2274: RAISE FND_API.G_EXC_ERROR;
2275: ELSE
2276: l_wip_move_txn_interface_rec.transaction_quantity := p_mv_txn_dtls_tbl(mv_ctr).transaction_quantity +
2277: l_prev_transaction_quantity;
2278: END IF;

Line 2323: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2319:
2320: insert_wip_move_txn( p_wip_move_txn_interface_rec => l_wip_move_txn_interface_rec,
2321: x_return_status => x_return_status );
2322:
2323: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2325: END IF;
2326:
2327: END LOOP;

Line 2324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2320: insert_wip_move_txn( p_wip_move_txn_interface_rec => l_wip_move_txn_interface_rec,
2321: x_return_status => x_return_status );
2322:
2323: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2325: END IF;
2326:
2327: END LOOP;
2328: -- end swai: bug 5330060

Line 2348: p_commit => FND_API.G_FALSE,

2344: p_procPhase => l_process_phase,
2345: p_txnHdrID => l_material_transaction_id,
2346: p_mtlMode => WIP_CONSTANTS.ONLINE,
2347: p_cplTxnID => NULL,
2348: p_commit => FND_API.G_FALSE,
2349: x_returnStatus => x_return_status,
2350: x_errorMsg => x_msg_data);
2351:
2352: */

Line 2355: p_commit => FND_API.G_FALSE,

2351:
2352: */
2353:
2354: wip_movProc_grp.processInterface(p_groupID => l_wip_move_txn_interface_rec.group_id,
2355: p_commit => FND_API.G_FALSE,
2356: x_returnStatus => x_return_status ) ;
2357:
2358: -- Need to get errors from error table and pass it back
2359:

Line 2367: x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

2363: close check_mv_interface_errors ;
2364:
2365:
2366: If ( l_error_exists is not null or
2367: x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
2368:
2369: -- ROLLBACK to PROCESS_OPER_COMP_TXN_PVT ;
2370:
2371:

Line 2374: RAISE FND_API.G_EXC_ERROR;

2370:
2371:
2372: FND_MESSAGE.SET_NAME('CSD','CSD_MOVE_TXN_FAILURE');
2373: FND_MSG_PUB.ADD;
2374: RAISE FND_API.G_EXC_ERROR;
2375: -- Need to rollback Raise exception -
2376: -- once commit is removed from above call
2377:
2378: end if;

Line 2384: /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2380:
2381:
2382:
2383:
2384: /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2385: ROLLBACK to PROCESS_OPER_COMP_TXN_PVT ;
2386:
2387:
2388: FND_MESSAGE.SET_NAME('CSD','CSD_MOVE_TXN_FAILURE');

Line 2390: RAISE FND_API.G_EXC_UNEXPECTED_ERROR; */

2386:
2387:
2388: FND_MESSAGE.SET_NAME('CSD','CSD_MOVE_TXN_FAILURE');
2389: FND_MSG_PUB.ADD;
2390: RAISE FND_API.G_EXC_UNEXPECTED_ERROR; */
2391:
2392:
2393: /* IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2394: FND_LOG.STRING( FND_LOG.LEVEL_ERROR,

Line 2405: IF FND_API.to_Boolean( p_commit )

2401: -- END IF;
2402:
2403:
2404: -- Standard check for p_commit
2405: IF FND_API.to_Boolean( p_commit )
2406: THEN
2407: COMMIT WORK;
2408: END IF;
2409:

Line 2411: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2407: COMMIT WORK;
2408: END IF;
2409:
2410: EXCEPTION
2411: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2412: ROLLBACK to PROCESS_OPER_COMP_TXN_PVT ;
2413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2414:
2415: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 2413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2409:
2410: EXCEPTION
2411: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2412: ROLLBACK to PROCESS_OPER_COMP_TXN_PVT ;
2413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2414:
2415: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2416: p_count => x_msg_count,
2417: p_data => x_msg_data);

Line 2415: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

2411: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2412: ROLLBACK to PROCESS_OPER_COMP_TXN_PVT ;
2413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2414:
2415: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2416: p_count => x_msg_count,
2417: p_data => x_msg_data);
2418:
2419: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 2426: WHEN FND_API.G_EXC_ERROR THEN

2422: 'G_EXC_UNEXPECTED_ERROR Exception');
2423: END IF;
2424:
2425:
2426: WHEN FND_API.G_EXC_ERROR THEN
2427: ROLLBACK to PROCESS_OPER_COMP_TXN_PVT ;
2428: x_return_status := FND_API.G_RET_STS_ERROR;
2429:
2430:

Line 2428: x_return_status := FND_API.G_RET_STS_ERROR;

2424:
2425:
2426: WHEN FND_API.G_EXC_ERROR THEN
2427: ROLLBACK to PROCESS_OPER_COMP_TXN_PVT ;
2428: x_return_status := FND_API.G_RET_STS_ERROR;
2429:
2430:
2431: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2432: p_count => x_msg_count,

Line 2431: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

2427: ROLLBACK to PROCESS_OPER_COMP_TXN_PVT ;
2428: x_return_status := FND_API.G_RET_STS_ERROR;
2429:
2430:
2431: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2432: p_count => x_msg_count,
2433: p_data => x_msg_data);
2434:
2435: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 2443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2439: END IF;
2440:
2441: WHEN OTHERS THEN
2442: ROLLBACK to PROCESS_OPER_COMP_TXN_PVT ;
2443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2444:
2445: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2446:
2447: -- Add Unexpected Error to Message List, here SQLERRM is used for

Line 2454: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

2450: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
2451: p_procedure_name => lc_api_name );
2452: END IF;
2453:
2454: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2455: p_count => x_msg_count,
2456: p_data => x_msg_data);
2457:
2458: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 2585: IF NOT FND_API.Compatible_API_Call

2581: END IF;
2582:
2583: SAVEPOINT PROCESS_ISSUE_MTL_TXN_PVT;
2584: -- Standard call to check for call compatibility.
2585: IF NOT FND_API.Compatible_API_Call
2586: (lc_api_version_number,
2587: p_api_version_number,
2588: lc_api_name,
2589: G_PKG_NAME)

Line 2591: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2587: p_api_version_number,
2588: lc_api_name,
2589: G_PKG_NAME)
2590: THEN
2591: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2592: END IF;
2593:
2594:
2595: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 2595: IF FND_API.to_boolean(p_init_msg_list) THEN

2591: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2592: END IF;
2593:
2594:
2595: IF FND_API.to_boolean(p_init_msg_list) THEN
2596: FND_MSG_PUB.initialize;
2597: END IF;
2598:
2599:

Line 2602: x_return_status := FND_API.G_RET_STS_SUCCESS;

2598:
2599:
2600:
2601:
2602: x_return_status := FND_API.G_RET_STS_SUCCESS;
2603:
2604: -- x_need_details_flag := 'F';
2605:
2606:

Line 2675: RAISE FND_API.G_EXC_ERROR;

2671:
2672: If l_transactions_interface_rec.transaction_quantity = 0 then
2673: FND_MESSAGE.SET_NAME('CSD','CSD_ISS_QTY_ZERO');
2674: FND_MSG_PUB.ADD;
2675: RAISE FND_API.G_EXC_ERROR;
2676: end if;
2677:
2678:
2679: l_transactions_interface_rec.transaction_uom := p_mtl_txn_dtls_tbl(mtl_ctr).transaction_uom;

Line 2865: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2861: insert_transactions_header( p_transactions_interface_rec => l_transactions_interface_rec,
2862: x_return_status => x_return_status );
2863:
2864:
2865: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2866: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2867: END IF;
2868:
2869: IF l_qty_ctr <> p_mtl_txn_dtls_tbl(mtl_ctr).transaction_quantity THEN

Line 2866: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2862: x_return_status => x_return_status );
2863:
2864:
2865: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2866: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2867: END IF;
2868:
2869: IF l_qty_ctr <> p_mtl_txn_dtls_tbl(mtl_ctr).transaction_quantity THEN
2870: -- generate transaction_interface_id for the next record

Line 2903: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2899: insert_upd_serial_numbers( p_srl_nmbrs_interface_rec => l_srl_nmbrs_interface_rec,
2900: x_return_status => x_return_status );
2901:
2902:
2903: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2904: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2905: END IF;
2906:
2907: ELSE

Line 2904: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2900: x_return_status => x_return_status );
2901:
2902:
2903: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2904: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2905: END IF;
2906:
2907: ELSE
2908:

Line 2937: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2933: insert_transactions_header( p_transactions_interface_rec => l_transactions_interface_rec,
2934: x_return_status => x_return_status );
2935:
2936:
2937: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2938: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2939: END IF;
2940:
2941:

Line 2938: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2934: x_return_status => x_return_status );
2935:
2936:
2937: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2938: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2939: END IF;
2940:
2941:
2942:

Line 2969: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2965: insert_transactions_header( p_transactions_interface_rec => l_transactions_interface_rec,
2966: x_return_status => x_return_status );
2967:
2968:
2969: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2971: END IF;
2972:
2973: END IF;

Line 2970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2966: x_return_status => x_return_status );
2967:
2968:
2969: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2971: END IF;
2972:
2973: END IF;
2974:

Line 3047: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3043: insert_job_header( p_job_header_rec => l_job_header_rec,
3044: x_return_status => x_return_status );
3045:
3046:
3047: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3049: END IF;
3050:
3051:

Line 3048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3044: x_return_status => x_return_status );
3045:
3046:
3047: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3049: END IF;
3050:
3051:
3052: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 3067: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3063:
3064: insert_job_details( p_job_details_rec => l_job_details_rec,
3065: x_return_status => x_return_status );
3066:
3067: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3068: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3069: END IF;
3070:
3071:

Line 3068: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3064: insert_job_details( p_job_details_rec => l_job_details_rec,
3065: x_return_status => x_return_status );
3066:
3067: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3068: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3069: END IF;
3070:
3071:
3072: END IF;

Line 3099: ,p_TRANSACTION_QUANTITY => FND_API.G_MISS_NUM

3095: ,p_WIP_ENTITY_ID => null
3096: ,p_OPERATION_SEQ_NUM => null
3097: ,p_RESOURCE_SEQ_NUM => null
3098: ,p_INSTANCE_ID => null
3099: ,p_TRANSACTION_QUANTITY => FND_API.G_MISS_NUM
3100: ,p_TRANSACTION_UOM => FND_API.G_MISS_CHAR
3101: ,p_SERIAL_NUMBER => FND_API.G_MISS_CHAR
3102: ,p_OBJECT_VERSION_NUMBER => p_mtl_txn_dtls_tbl(mtl_ctr).object_version_number
3103: ); */

Line 3100: ,p_TRANSACTION_UOM => FND_API.G_MISS_CHAR

3096: ,p_OPERATION_SEQ_NUM => null
3097: ,p_RESOURCE_SEQ_NUM => null
3098: ,p_INSTANCE_ID => null
3099: ,p_TRANSACTION_QUANTITY => FND_API.G_MISS_NUM
3100: ,p_TRANSACTION_UOM => FND_API.G_MISS_CHAR
3101: ,p_SERIAL_NUMBER => FND_API.G_MISS_CHAR
3102: ,p_OBJECT_VERSION_NUMBER => p_mtl_txn_dtls_tbl(mtl_ctr).object_version_number
3103: ); */
3104:

Line 3101: ,p_SERIAL_NUMBER => FND_API.G_MISS_CHAR

3097: ,p_RESOURCE_SEQ_NUM => null
3098: ,p_INSTANCE_ID => null
3099: ,p_TRANSACTION_QUANTITY => FND_API.G_MISS_NUM
3100: ,p_TRANSACTION_UOM => FND_API.G_MISS_CHAR
3101: ,p_SERIAL_NUMBER => FND_API.G_MISS_CHAR
3102: ,p_OBJECT_VERSION_NUMBER => p_mtl_txn_dtls_tbl(mtl_ctr).object_version_number
3103: ); */
3104:
3105: CSD_WIP_TRANSACTION_DTLS_PKG.Delete_Row(

Line 3139: p_init_msg_list => fnd_api.g_false, --'T', -- fnd_api.g_false ,

3135: IF l_need_details_flag = 'F' THEN
3136:
3137: l_return_count := INV_TXN_MANAGER_PUB.process_Transactions(
3138: p_api_version => lc_api_version_number, --1.0, -- ,
3139: p_init_msg_list => fnd_api.g_false, --'T', -- fnd_api.g_false ,
3140: p_commit => fnd_api.g_false, --'T', -- fnd_api.g_false ,
3141: p_validation_level => p_validation_level ,
3142: x_return_status => x_return_status,
3143: x_msg_count => x_msg_count,

Line 3140: p_commit => fnd_api.g_false, --'T', -- fnd_api.g_false ,

3136:
3137: l_return_count := INV_TXN_MANAGER_PUB.process_Transactions(
3138: p_api_version => lc_api_version_number, --1.0, -- ,
3139: p_init_msg_list => fnd_api.g_false, --'T', -- fnd_api.g_false ,
3140: p_commit => fnd_api.g_false, --'T', -- fnd_api.g_false ,
3141: p_validation_level => p_validation_level ,
3142: x_return_status => x_return_status,
3143: x_msg_count => x_msg_count,
3144: x_msg_data => x_msg_data,

Line 3151: x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

3147: p_header_id => l_transactions_interface_rec.transaction_header_id );
3148:
3149:
3150: If ( txn_int_error_exists( l_transactions_interface_rec.transaction_header_id ) or
3151: x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
3152: -- x_msg_data := x_msg_data||' after pt ' ;
3153: -- ROLLBACK to PROCESS_ISSUE_MTL_TXN_PVT ;
3154:
3155:

Line 3161: RAISE FND_API.G_EXC_ERROR;

3157:
3158: FND_MESSAGE.SET_NAME('CSD','CSD_MAT_TXN_FAILURE');
3159: FND_MSG_PUB.ADD;
3160:
3161: RAISE FND_API.G_EXC_ERROR;
3162:
3163: -- END IF;
3164:
3165:

Line 3193: x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

3189: x_errorMsg => x_msg_data );
3190:
3191:
3192: If ( ml_error_exists( l_job_header_rec.group_id ) or
3193: x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
3194:
3195:
3196: FND_MESSAGE.SET_NAME('CSD','CSD_MTL_ISS_MASS_LD_FAILURE');
3197: FND_MSG_PUB.ADD;

Line 3198: x_return_status := FND_API.G_RET_STS_ERROR;

3194:
3195:
3196: FND_MESSAGE.SET_NAME('CSD','CSD_MTL_ISS_MASS_LD_FAILURE');
3197: FND_MSG_PUB.ADD;
3198: x_return_status := FND_API.G_RET_STS_ERROR;
3199:
3200: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3201: p_count => x_msg_count,
3202: p_data => x_msg_data);

Line 3200: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

3196: FND_MESSAGE.SET_NAME('CSD','CSD_MTL_ISS_MASS_LD_FAILURE');
3197: FND_MSG_PUB.ADD;
3198: x_return_status := FND_API.G_RET_STS_ERROR;
3199:
3200: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3201: p_count => x_msg_count,
3202: p_data => x_msg_data);
3203:
3204: RETURN;

Line 3213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3209:
3210: EXCEPTION
3211: WHEN OTHERS THEN
3212:
3213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3214:
3215: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3216:
3217: -- Add Unexpected Error to Message List, here SQLERRM is used for

Line 3224: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

3220: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
3221: p_procedure_name => lc_api_name );
3222: END IF;
3223:
3224: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3225: p_count => x_msg_count,
3226: p_data => x_msg_data);
3227:
3228: END;

Line 3231: /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3227:
3228: END;
3229:
3230:
3231: /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3232: -- ROLLBACK to PROCESS_ISSUE_MTL_TXN_PVT ;
3233: -- dbms_output.put_line('WIP Update Error');
3234:
3235:

Line 3239: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3235:
3236: FND_MESSAGE.SET_NAME('CSD','CSD_MAT_TXN_FAILURE');
3237: FND_MSG_PUB.ADD;
3238: RETURN; */
3239: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3240:
3241:
3242: /* IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3243: FND_LOG.STRING( FND_LOG.LEVEL_ERROR,

Line 3258: IF l_need_details_flag = 'F' and FND_API.to_Boolean( p_commit )

3254:
3255:
3256:
3257: -- Standard check for p_commit
3258: IF l_need_details_flag = 'F' and FND_API.to_Boolean( p_commit )
3259: THEN
3260: COMMIT WORK;
3261: END IF;
3262:

Line 3264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3260: COMMIT WORK;
3261: END IF;
3262:
3263: EXCEPTION
3264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3265: -- dbms_output.put_line( 'FND_API.G_EXC_UNEXPECTED_ERROR error'|| sqlerrm);
3266: ROLLBACK to PROCESS_ISSUE_MTL_TXN_PVT ;
3267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3268:

Line 3265: -- dbms_output.put_line( 'FND_API.G_EXC_UNEXPECTED_ERROR error'|| sqlerrm);

3261: END IF;
3262:
3263: EXCEPTION
3264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3265: -- dbms_output.put_line( 'FND_API.G_EXC_UNEXPECTED_ERROR error'|| sqlerrm);
3266: ROLLBACK to PROCESS_ISSUE_MTL_TXN_PVT ;
3267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3268:
3269: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 3267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3263: EXCEPTION
3264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3265: -- dbms_output.put_line( 'FND_API.G_EXC_UNEXPECTED_ERROR error'|| sqlerrm);
3266: ROLLBACK to PROCESS_ISSUE_MTL_TXN_PVT ;
3267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3268:
3269: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3270: p_count => x_msg_count,
3271: p_data => x_msg_data);

Line 3269: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

3265: -- dbms_output.put_line( 'FND_API.G_EXC_UNEXPECTED_ERROR error'|| sqlerrm);
3266: ROLLBACK to PROCESS_ISSUE_MTL_TXN_PVT ;
3267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3268:
3269: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3270: p_count => x_msg_count,
3271: p_data => x_msg_data);
3272:
3273: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 3280: WHEN FND_API.G_EXC_ERROR THEN

3276: 'G_EXC_UNEXPECTED_ERROR Exception');
3277: END IF;
3278:
3279:
3280: WHEN FND_API.G_EXC_ERROR THEN
3281: ROLLBACK to PROCESS_ISSUE_MTL_TXN_PVT ;
3282: x_return_status := FND_API.G_RET_STS_ERROR;
3283:
3284:

Line 3282: x_return_status := FND_API.G_RET_STS_ERROR;

3278:
3279:
3280: WHEN FND_API.G_EXC_ERROR THEN
3281: ROLLBACK to PROCESS_ISSUE_MTL_TXN_PVT ;
3282: x_return_status := FND_API.G_RET_STS_ERROR;
3283:
3284:
3285: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3286: p_count => x_msg_count,

Line 3285: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

3281: ROLLBACK to PROCESS_ISSUE_MTL_TXN_PVT ;
3282: x_return_status := FND_API.G_RET_STS_ERROR;
3283:
3284:
3285: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3286: p_count => x_msg_count,
3287: p_data => x_msg_data);
3288:
3289: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 3298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3294:
3295: WHEN OTHERS THEN
3296: -- dbms_output.put_line( 'OTHERS error' || sqlerrm );
3297: ROLLBACK to PROCESS_ISSUE_MTL_TXN_PVT ;
3298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3299:
3300: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3301:
3302: -- Add Unexpected Error to Message List, here SQLERRM is used for

Line 3309: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

3305: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
3306: p_procedure_name => lc_api_name );
3307: -- END IF;
3308:
3309: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3310: p_count => x_msg_count,
3311: p_data => x_msg_data);
3312:
3313: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 3355: IF NOT FND_API.Compatible_API_Call

3351: END IF;
3352:
3353: SAVEPOINT PROCESS_MTL_TXNS_LOT_SRL_PVT;
3354: -- Standard call to check for call compatibility.
3355: IF NOT FND_API.Compatible_API_Call
3356: (lc_api_version_number,
3357: p_api_version_number,
3358: lc_api_name,
3359: G_PKG_NAME)

Line 3361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3357: p_api_version_number,
3358: lc_api_name,
3359: G_PKG_NAME)
3360: THEN
3361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3362: END IF;
3363:
3364: IF FND_API.to_boolean(p_init_msg_list) THEN
3365: FND_MSG_PUB.initialize;

Line 3364: IF FND_API.to_boolean(p_init_msg_list) THEN

3360: THEN
3361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3362: END IF;
3363:
3364: IF FND_API.to_boolean(p_init_msg_list) THEN
3365: FND_MSG_PUB.initialize;
3366: END IF;
3367:
3368: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3368: x_return_status := FND_API.G_RET_STS_SUCCESS;

3364: IF FND_API.to_boolean(p_init_msg_list) THEN
3365: FND_MSG_PUB.initialize;
3366: END IF;
3367:
3368: x_return_status := FND_API.G_RET_STS_SUCCESS;
3369:
3370: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3371: FND_LOG.STRING( FND_LOG.LEVEL_EVENT,
3372: lc_mod_name||'beforecallinsertjobcomptxn',

Line 3377: p_init_msg_list => fnd_api.g_false ,

3373: 'Just before calling insert_job_comp_txn');
3374: END IF;
3375: update_mtl_txns_lot_srl (
3376: p_api_version_number => lc_api_version_number,
3377: p_init_msg_list => fnd_api.g_false ,
3378: p_commit => fnd_api.g_false,
3379: p_validation_level => p_validation_level,
3380: x_return_status => x_return_status,
3381: x_msg_count => x_msg_count,

Line 3378: p_commit => fnd_api.g_false,

3374: END IF;
3375: update_mtl_txns_lot_srl (
3376: p_api_version_number => lc_api_version_number,
3377: p_init_msg_list => fnd_api.g_false ,
3378: p_commit => fnd_api.g_false,
3379: p_validation_level => p_validation_level,
3380: x_return_status => x_return_status,
3381: x_msg_count => x_msg_count,
3382: x_msg_data => x_msg_data,

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

3382: x_msg_data => x_msg_data,
3383: p_mtl_txn_dtls_tbl => p_mtl_txn_dtls_tbl,
3384: p_transaction_header_id => p_transaction_header_id
3385: );
3386: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
3387: FND_MESSAGE.SET_NAME('CSD','CSD_MAT_TXN_FAILURE');
3388: FND_MSG_PUB.ADD;
3389: RAISE FND_API.G_EXC_ERROR;
3390: END IF;

Line 3389: RAISE FND_API.G_EXC_ERROR;

3385: );
3386: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
3387: FND_MESSAGE.SET_NAME('CSD','CSD_MAT_TXN_FAILURE');
3388: FND_MSG_PUB.ADD;
3389: RAISE FND_API.G_EXC_ERROR;
3390: END IF;
3391:
3392: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3393: FND_LOG.STRING( FND_LOG.LEVEL_EVENT,

Line 3399: p_init_msg_list => fnd_api.g_false ,

3395: 'Just before calling process_mti_transactions');
3396: END IF;
3397: process_mti_transactions(
3398: p_api_version_number => lc_api_version_number,
3399: p_init_msg_list => fnd_api.g_false ,
3400: p_commit => fnd_api.g_false,
3401: p_validation_level => p_validation_level,
3402: x_return_status => x_return_status,
3403: x_msg_count => x_msg_count,

Line 3400: p_commit => fnd_api.g_false,

3396: END IF;
3397: process_mti_transactions(
3398: p_api_version_number => lc_api_version_number,
3399: p_init_msg_list => fnd_api.g_false ,
3400: p_commit => fnd_api.g_false,
3401: p_validation_level => p_validation_level,
3402: x_return_status => x_return_status,
3403: x_msg_count => x_msg_count,
3404: x_msg_data => x_msg_data,

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

3404: x_msg_data => x_msg_data,
3405: p_txn_header_id => p_transaction_header_id
3406: -- p_txn_type IN VARCHAR2
3407: );
3408: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
3409: FND_MESSAGE.SET_NAME('CSD','CSD_MAT_TXN_FAILURE');
3410: FND_MSG_PUB.ADD;
3411: RAISE FND_API.G_EXC_ERROR;
3412: END IF;

Line 3411: RAISE FND_API.G_EXC_ERROR;

3407: );
3408: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
3409: FND_MESSAGE.SET_NAME('CSD','CSD_MAT_TXN_FAILURE');
3410: FND_MSG_PUB.ADD;
3411: RAISE FND_API.G_EXC_ERROR;
3412: END IF;
3413:
3414: -- Standard check for p_commit
3415: IF FND_API.to_Boolean( p_commit )

Line 3415: IF FND_API.to_Boolean( p_commit )

3411: RAISE FND_API.G_EXC_ERROR;
3412: END IF;
3413:
3414: -- Standard check for p_commit
3415: IF FND_API.to_Boolean( p_commit )
3416: THEN
3417: COMMIT WORK;
3418: END IF;
3419:

Line 3421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3417: COMMIT WORK;
3418: END IF;
3419:
3420: EXCEPTION
3421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3422: ROLLBACK to PROCESS_MTL_TXNS_LOT_SRL_PVT ;
3423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3424:
3425: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 3423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3419:
3420: EXCEPTION
3421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3422: ROLLBACK to PROCESS_MTL_TXNS_LOT_SRL_PVT ;
3423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3424:
3425: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3426: p_count => x_msg_count,
3427: p_data => x_msg_data);

Line 3425: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

3421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3422: ROLLBACK to PROCESS_MTL_TXNS_LOT_SRL_PVT ;
3423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3424:
3425: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3426: p_count => x_msg_count,
3427: p_data => x_msg_data);
3428:
3429: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 3435: WHEN FND_API.G_EXC_ERROR THEN

3431: lc_mod_name||'unx_exception',
3432: 'G_EXC_UNEXPECTED_ERROR Exception');
3433: END IF;
3434:
3435: WHEN FND_API.G_EXC_ERROR THEN
3436: ROLLBACK to PROCESS_MTL_TXNS_LOT_SRL_PVT ;
3437: x_return_status := FND_API.G_RET_STS_ERROR;
3438:
3439: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 3437: x_return_status := FND_API.G_RET_STS_ERROR;

3433: END IF;
3434:
3435: WHEN FND_API.G_EXC_ERROR THEN
3436: ROLLBACK to PROCESS_MTL_TXNS_LOT_SRL_PVT ;
3437: x_return_status := FND_API.G_RET_STS_ERROR;
3438:
3439: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3440: p_count => x_msg_count,
3441: p_data => x_msg_data);

Line 3439: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

3435: WHEN FND_API.G_EXC_ERROR THEN
3436: ROLLBACK to PROCESS_MTL_TXNS_LOT_SRL_PVT ;
3437: x_return_status := FND_API.G_RET_STS_ERROR;
3438:
3439: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3440: p_count => x_msg_count,
3441: p_data => x_msg_data);
3442:
3443: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 3451: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3447: END IF;
3448:
3449: WHEN OTHERS THEN
3450: ROLLBACK to PROCESS_MTL_TXNS_LOT_SRL_PVT ;
3451: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3452:
3453: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3454: -- Add Unexpected Error to Message List, here SQLERRM is used for
3455: -- getting the error

Line 3460: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

3456: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
3457: p_procedure_name => lc_api_name );
3458: END IF;
3459:
3460: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3461: p_count => x_msg_count,
3462: p_data => x_msg_data);
3463:
3464: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 3517: IF NOT FND_API.Compatible_API_Call

3513: END IF;
3514:
3515: SAVEPOINT UPDATE_MTL_TXNS_LOT_SRL_PVT;
3516: -- Standard call to check for call compatibility.
3517: IF NOT FND_API.Compatible_API_Call
3518: (lc_api_version_number,
3519: p_api_version_number,
3520: lc_api_name,
3521: G_PKG_NAME)

Line 3523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3519: p_api_version_number,
3520: lc_api_name,
3521: G_PKG_NAME)
3522: THEN
3523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3524: END IF;
3525:
3526: IF FND_API.to_boolean(p_init_msg_list) THEN
3527: FND_MSG_PUB.initialize;

Line 3526: IF FND_API.to_boolean(p_init_msg_list) THEN

3522: THEN
3523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3524: END IF;
3525:
3526: IF FND_API.to_boolean(p_init_msg_list) THEN
3527: FND_MSG_PUB.initialize;
3528: END IF;
3529:
3530: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3530: x_return_status := FND_API.G_RET_STS_SUCCESS;

3526: IF FND_API.to_boolean(p_init_msg_list) THEN
3527: FND_MSG_PUB.initialize;
3528: END IF;
3529:
3530: x_return_status := FND_API.G_RET_STS_SUCCESS;
3531:
3532: FOR mtl_ctr in p_mtl_txn_dtls_tbl.FIRST.. p_mtl_txn_dtls_tbl.LAST
3533: LOOP
3534: l_transactions_interface_rec.subinventory_code := p_mtl_txn_dtls_tbl(mtl_ctr).supply_subinventory;

Line 3551: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3547:
3548: update_transactions_header(p_transactions_interface_rec => l_transactions_interface_rec,
3549: x_return_status => x_return_status );
3550:
3551: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3553: END IF;
3554:
3555: -- Check for Lot Control

Line 3552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3548: update_transactions_header(p_transactions_interface_rec => l_transactions_interface_rec,
3549: x_return_status => x_return_status );
3550:
3551: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3553: END IF;
3554:
3555: -- Check for Lot Control
3556: IF p_mtl_txn_dtls_tbl(mtl_ctr).lot_control_code = lc_full_lot_control THEN

Line 3579: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3575:
3576: insert_upd_serial_numbers(p_srl_nmbrs_interface_rec => l_srl_nmbrs_interface_rec,
3577: x_return_status => x_return_status);
3578:
3579: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3581: END IF;
3582: END IF;
3583:

Line 3580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3576: insert_upd_serial_numbers(p_srl_nmbrs_interface_rec => l_srl_nmbrs_interface_rec,
3577: x_return_status => x_return_status);
3578:
3579: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3581: END IF;
3582: END IF;
3583:
3584: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 3593: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3589:
3590: insert_transaction_lots(p_txn_lots_interface_rec => l_txn_lots_interface_rec,
3591: x_return_status => x_return_status );
3592:
3593: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3595: END IF;
3596: ELSE -- not lc_full_lot_control
3597: IF p_mtl_txn_dtls_tbl(mtl_ctr).SERIAL_NUMBER_CONTROL_CODE in ( lc_predefined_serial_control , lc_inven_rct_srl_control ) THEN

Line 3594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3590: insert_transaction_lots(p_txn_lots_interface_rec => l_txn_lots_interface_rec,
3591: x_return_status => x_return_status );
3592:
3593: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3595: END IF;
3596: ELSE -- not lc_full_lot_control
3597: IF p_mtl_txn_dtls_tbl(mtl_ctr).SERIAL_NUMBER_CONTROL_CODE in ( lc_predefined_serial_control , lc_inven_rct_srl_control ) THEN
3598: l_srl_nmbrs_interface_rec.transaction_interface_id := l_transactions_interface_rec.transaction_interface_id;

Line 3610: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3606:
3607: insert_upd_serial_numbers(p_srl_nmbrs_interface_rec => l_srl_nmbrs_interface_rec,
3608: x_return_status => x_return_status );
3609:
3610: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3612: END IF;
3613: END IF;
3614: END IF; -- end lot control condition

Line 3611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3607: insert_upd_serial_numbers(p_srl_nmbrs_interface_rec => l_srl_nmbrs_interface_rec,
3608: x_return_status => x_return_status );
3609:
3610: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3612: END IF;
3613: END IF;
3614: END IF; -- end lot control condition
3615: END LOOP;

Line 3618: IF FND_API.to_Boolean( p_commit )

3614: END IF; -- end lot control condition
3615: END LOOP;
3616:
3617: -- Standard check for p_commit
3618: IF FND_API.to_Boolean( p_commit )
3619: THEN
3620: COMMIT WORK;
3621: END IF;
3622:

Line 3624: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3620: COMMIT WORK;
3621: END IF;
3622:
3623: EXCEPTION
3624: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3625: ROLLBACK to UPDATE_MTL_TXNS_LOT_SRL_PVT ;
3626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3627:
3628: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 3626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3622:
3623: EXCEPTION
3624: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3625: ROLLBACK to UPDATE_MTL_TXNS_LOT_SRL_PVT ;
3626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3627:
3628: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3629: p_count => x_msg_count,
3630: p_data => x_msg_data);

Line 3628: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

3624: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3625: ROLLBACK to UPDATE_MTL_TXNS_LOT_SRL_PVT ;
3626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3627:
3628: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3629: p_count => x_msg_count,
3630: p_data => x_msg_data);
3631:
3632: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 3638: WHEN FND_API.G_EXC_ERROR THEN

3634: lc_mod_name||'unx_exception',
3635: 'G_EXC_UNEXPECTED_ERROR Exception');
3636: END IF;
3637:
3638: WHEN FND_API.G_EXC_ERROR THEN
3639: ROLLBACK to UPDATE_MTL_TXNS_LOT_SRL_PVT ;
3640: x_return_status := FND_API.G_RET_STS_ERROR;
3641:
3642: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 3640: x_return_status := FND_API.G_RET_STS_ERROR;

3636: END IF;
3637:
3638: WHEN FND_API.G_EXC_ERROR THEN
3639: ROLLBACK to UPDATE_MTL_TXNS_LOT_SRL_PVT ;
3640: x_return_status := FND_API.G_RET_STS_ERROR;
3641:
3642: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3643: p_count => x_msg_count,
3644: p_data => x_msg_data);

Line 3642: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

3638: WHEN FND_API.G_EXC_ERROR THEN
3639: ROLLBACK to UPDATE_MTL_TXNS_LOT_SRL_PVT ;
3640: x_return_status := FND_API.G_RET_STS_ERROR;
3641:
3642: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3643: p_count => x_msg_count,
3644: p_data => x_msg_data);
3645:
3646: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 3654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3650: END IF;
3651:
3652: WHEN OTHERS THEN
3653: ROLLBACK to UPDATE_MTL_TXNS_LOT_SRL_PVT ;
3654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3655:
3656: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3657: -- Add Unexpected Error to Message List, here SQLERRM is used for
3658: -- getting the error

Line 3663: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

3659: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
3660: p_procedure_name => lc_api_name );
3661: END IF;
3662:
3663: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3664: p_count => x_msg_count,
3665: p_data => x_msg_data);
3666:
3667: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 3741: IF NOT FND_API.Compatible_API_Call

3737: END IF;
3738:
3739: SAVEPOINT PROCESS_TRANSACT_RES_TXN_PVT;
3740: -- Standard call to check for call compatibility.
3741: IF NOT FND_API.Compatible_API_Call
3742: (lc_api_version_number,
3743: p_api_version_number,
3744: lc_api_name,
3745: G_PKG_NAME)

Line 3747: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3743: p_api_version_number,
3744: lc_api_name,
3745: G_PKG_NAME)
3746: THEN
3747: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3748: END IF;
3749:
3750:
3751: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 3751: IF FND_API.to_boolean(p_init_msg_list) THEN

3747: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3748: END IF;
3749:
3750:
3751: IF FND_API.to_boolean(p_init_msg_list) THEN
3752: FND_MSG_PUB.initialize;
3753: END IF;
3754:
3755:

Line 3758: x_return_status := FND_API.G_RET_STS_SUCCESS;

3754:
3755:
3756:
3757:
3758: x_return_status := FND_API.G_RET_STS_SUCCESS;
3759:
3760:
3761: -- Populate the row who columns
3762:

Line 3787: RAISE FND_API.G_EXC_ERROR;

3783: /* IF l_job_details_rec.autocharge_type is NULL THEN
3784:
3785: FND_MESSAGE.SET_NAME('CSD','CSD_ATCHG_TYP_NULL');
3786: FND_MSG_PUB.ADD;
3787: RAISE FND_API.G_EXC_ERROR;
3788: end if;
3789:
3790:
3791: l_job_details_rec.basis_type := fnd_profile.value('CSD_HV_BASIS_TYP');

Line 3799: RAISE FND_API.G_EXC_ERROR;

3795: IF l_job_details_rec.basis_type is NULL THEN
3796:
3797: FND_MESSAGE.SET_NAME('CSD','CSD_BASIS_TYP_NULL');
3798: FND_MSG_PUB.ADD;
3799: RAISE FND_API.G_EXC_ERROR;
3800: end if;
3801:
3802: l_job_details_rec.scheduled_flag := fnd_profile.value('CSD_HV_SCD_FLG');
3803:

Line 3810: RAISE FND_API.G_EXC_ERROR;

3806: IF l_job_details_rec.scheduled_flag is NULL THEN
3807:
3808: FND_MESSAGE.SET_NAME('CSD','CSD_SCD_FLG_NULL');
3809: FND_MSG_PUB.ADD;
3810: RAISE FND_API.G_EXC_ERROR;
3811: end if;
3812:
3813: l_job_details_rec.standard_rate_flag := fnd_profile.value('CSD_HV_STD_FLG');
3814:

Line 3821: RAISE FND_API.G_EXC_ERROR;

3817: IF l_job_details_rec.standard_rate_flag is NULL THEN
3818:
3819: FND_MESSAGE.SET_NAME('CSD','CSD_STD_FLG_NULL');
3820: FND_MSG_PUB.ADD;
3821: RAISE FND_API.G_EXC_ERROR;
3822: end if; */
3823:
3824: l_wip_cost_txn_interface_rec.transaction_date := sysdate;
3825: l_wip_cost_txn_interface_rec.transaction_type := lc_res_transaction_type;

Line 3852: RAISE FND_API.G_EXC_ERROR;

3848:
3849: If l_wip_cost_txn_interface_rec.transaction_quantity = 0 then
3850: FND_MESSAGE.SET_NAME('CSD','CSD_TRX_QTY_ZERO');
3851: FND_MSG_PUB.ADD;
3852: RAISE FND_API.G_EXC_ERROR;
3853: end if;
3854:
3855: l_wip_cost_txn_interface_rec.transaction_uom := p_res_txn_dtls_tbl(res_ctr).transaction_uom;
3856: l_wip_cost_txn_interface_rec.wip_entity_name := p_res_txn_dtls_tbl(res_ctr).wip_entity_name;

Line 3896: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3892: insert_wip_cost_txn( p_wip_cost_txn_interface_rec => l_wip_cost_txn_interface_rec,
3893: x_return_status => x_return_status );
3894:
3895:
3896: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3897: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3898: END IF;
3899:
3900:

Line 3897: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3893: x_return_status => x_return_status );
3894:
3895:
3896: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3897: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3898: END IF;
3899:
3900:
3901:

Line 3970: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3966: insert_job_header( p_job_header_rec => l_job_header_rec,
3967: x_return_status => x_return_status );
3968:
3969:
3970: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3971: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3972: END IF;
3973:
3974:

Line 3971: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3967: x_return_status => x_return_status );
3968:
3969:
3970: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3971: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3972: END IF;
3973:
3974:
3975: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 3985: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3981:
3982: insert_job_details( p_job_details_rec => l_job_details_rec,
3983: x_return_status => x_return_status );
3984:
3985: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3986: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3987: END IF;
3988:
3989: END IF;

Line 3986: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3982: insert_job_details( p_job_details_rec => l_job_details_rec,
3983: x_return_status => x_return_status );
3984:
3985: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3986: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3987: END IF;
3988:
3989: END IF;
3990:

Line 4016: ,p_TRANSACTION_QUANTITY => FND_API.G_MISS_NUM

4012: ,p_WIP_ENTITY_ID => null
4013: ,p_OPERATION_SEQ_NUM => null
4014: ,p_RESOURCE_SEQ_NUM => null
4015: ,p_INSTANCE_ID => null
4016: ,p_TRANSACTION_QUANTITY => FND_API.G_MISS_NUM
4017: ,p_TRANSACTION_UOM => FND_API.G_MISS_CHAR
4018: ,p_SERIAL_NUMBER => FND_API.G_MISS_CHAR
4019: ,p_OBJECT_VERSION_NUMBER => p_res_txn_dtls_tbl(res_ctr).object_version_number
4020: ); */

Line 4017: ,p_TRANSACTION_UOM => FND_API.G_MISS_CHAR

4013: ,p_OPERATION_SEQ_NUM => null
4014: ,p_RESOURCE_SEQ_NUM => null
4015: ,p_INSTANCE_ID => null
4016: ,p_TRANSACTION_QUANTITY => FND_API.G_MISS_NUM
4017: ,p_TRANSACTION_UOM => FND_API.G_MISS_CHAR
4018: ,p_SERIAL_NUMBER => FND_API.G_MISS_CHAR
4019: ,p_OBJECT_VERSION_NUMBER => p_res_txn_dtls_tbl(res_ctr).object_version_number
4020: ); */
4021:

Line 4018: ,p_SERIAL_NUMBER => FND_API.G_MISS_CHAR

4014: ,p_RESOURCE_SEQ_NUM => null
4015: ,p_INSTANCE_ID => null
4016: ,p_TRANSACTION_QUANTITY => FND_API.G_MISS_NUM
4017: ,p_TRANSACTION_UOM => FND_API.G_MISS_CHAR
4018: ,p_SERIAL_NUMBER => FND_API.G_MISS_CHAR
4019: ,p_OBJECT_VERSION_NUMBER => p_res_txn_dtls_tbl(res_ctr).object_version_number
4020: ); */
4021:
4022:

Line 4046: x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

4042: x_returnStatus => x_return_status,
4043: x_errorMsg => x_msg_data );
4044:
4045: If ( ml_error_exists( l_job_header_rec.group_id ) or
4046: x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
4047:
4048: FND_MESSAGE.SET_NAME('CSD','CSD_RES_TXN_MASS_LD_FAILURE');
4049: FND_MSG_PUB.ADD;
4050: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4050: x_return_status := FND_API.G_RET_STS_ERROR;

4046: x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
4047:
4048: FND_MESSAGE.SET_NAME('CSD','CSD_RES_TXN_MASS_LD_FAILURE');
4049: FND_MSG_PUB.ADD;
4050: x_return_status := FND_API.G_RET_STS_ERROR;
4051:
4052: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
4053: p_count => x_msg_count,
4054: p_data => x_msg_data);

Line 4052: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

4048: FND_MESSAGE.SET_NAME('CSD','CSD_RES_TXN_MASS_LD_FAILURE');
4049: FND_MSG_PUB.ADD;
4050: x_return_status := FND_API.G_RET_STS_ERROR;
4051:
4052: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
4053: p_count => x_msg_count,
4054: p_data => x_msg_data);
4055:
4056: RETURN;

Line 4065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4061:
4062: EXCEPTION
4063: WHEN OTHERS THEN
4064:
4065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4066:
4067: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4068:
4069: -- Add Unexpected Error to Message List, here SQLERRM is used for

Line 4076: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

4072: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
4073: p_procedure_name => lc_api_name );
4074: END IF;
4075:
4076: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
4077: p_count => x_msg_count,
4078: p_data => x_msg_data);
4079:
4080: END;

Line 4083: /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4079:
4080: END;
4081:
4082:
4083: /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4084: -- ROLLBACK to PROCESS_TRANSACT_RES_TXN_PVT ;
4085:
4086: FND_MESSAGE.SET_NAME('CSD','CSD_RES_TXN_FAILURE');
4087: FND_MSG_PUB.ADD;

Line 4089: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4085:
4086: FND_MESSAGE.SET_NAME('CSD','CSD_RES_TXN_FAILURE');
4087: FND_MSG_PUB.ADD;
4088: RETURN; -- later - once wip works - can remove this
4089: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4090: */
4091:
4092:
4093: /* IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 4107: IF FND_API.to_Boolean( p_commit )

4103: END IF;
4104:
4105:
4106: -- Standard check for p_commit
4107: IF FND_API.to_Boolean( p_commit )
4108: THEN
4109: COMMIT WORK;
4110: END IF;
4111:

Line 4113: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4109: COMMIT WORK;
4110: END IF;
4111:
4112: EXCEPTION
4113: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4114: ROLLBACK to PROCESS_TRANSACT_RES_TXN_PVT ;
4115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4116:
4117: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 4115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4111:
4112: EXCEPTION
4113: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4114: ROLLBACK to PROCESS_TRANSACT_RES_TXN_PVT ;
4115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4116:
4117: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
4118: p_count => x_msg_count,
4119: p_data => x_msg_data);

Line 4117: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

4113: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4114: ROLLBACK to PROCESS_TRANSACT_RES_TXN_PVT ;
4115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4116:
4117: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
4118: p_count => x_msg_count,
4119: p_data => x_msg_data);
4120:
4121: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 4128: WHEN FND_API.G_EXC_ERROR THEN

4124: 'G_EXC_UNEXPECTED_ERROR Exception');
4125: END IF;
4126:
4127:
4128: WHEN FND_API.G_EXC_ERROR THEN
4129: ROLLBACK to PROCESS_TRANSACT_RES_TXN_PVT ;
4130: x_return_status := FND_API.G_RET_STS_ERROR;
4131:
4132:

Line 4130: x_return_status := FND_API.G_RET_STS_ERROR;

4126:
4127:
4128: WHEN FND_API.G_EXC_ERROR THEN
4129: ROLLBACK to PROCESS_TRANSACT_RES_TXN_PVT ;
4130: x_return_status := FND_API.G_RET_STS_ERROR;
4131:
4132:
4133: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
4134: p_count => x_msg_count,

Line 4133: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

4129: ROLLBACK to PROCESS_TRANSACT_RES_TXN_PVT ;
4130: x_return_status := FND_API.G_RET_STS_ERROR;
4131:
4132:
4133: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
4134: p_count => x_msg_count,
4135: p_data => x_msg_data);
4136:
4137: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 4145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4141: END IF;
4142:
4143: WHEN OTHERS THEN
4144: ROLLBACK to PROCESS_TRANSACT_RES_TXN_PVT ;
4145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4146:
4147: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4148:
4149: -- Add Unexpected Error to Message List, here SQLERRM is used for

Line 4156: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

4152: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
4153: p_procedure_name => lc_api_name );
4154: END IF;
4155:
4156: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
4157: p_count => x_msg_count,
4158: p_data => x_msg_data);
4159:
4160: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 4255: IF NOT FND_API.Compatible_API_Call

4251:
4252: -- Standard Start of API savepoint
4253: SAVEPOINT PROCESS_SAVE_MTL_TXN_DTLS_PVT;
4254: -- Standard call to check for call compatibility.
4255: IF NOT FND_API.Compatible_API_Call
4256: (lc_api_version_number,
4257: p_api_version_number,
4258: lc_api_name,
4259: G_PKG_NAME)

Line 4261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4257: p_api_version_number,
4258: lc_api_name,
4259: G_PKG_NAME)
4260: THEN
4261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4262: END IF;
4263:
4264: -- Initialize message list if p_init_msg_list is set to TRUE
4265: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 4265: IF FND_API.to_boolean(p_init_msg_list) THEN

4261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4262: END IF;
4263:
4264: -- Initialize message list if p_init_msg_list is set to TRUE
4265: IF FND_API.to_boolean(p_init_msg_list) THEN
4266: FND_MSG_PUB.initialize;
4267: END IF;
4268:
4269:

Line 4270: x_return_status := FND_API.G_RET_STS_SUCCESS;

4266: FND_MSG_PUB.initialize;
4267: END IF;
4268:
4269:
4270: x_return_status := FND_API.G_RET_STS_SUCCESS;
4271: x_op_created := FND_API.G_FALSE;
4272:
4273: -- Populate the constant values
4274:

Line 4271: x_op_created := FND_API.G_FALSE;

4267: END IF;
4268:
4269:
4270: x_return_status := FND_API.G_RET_STS_SUCCESS;
4271: x_op_created := FND_API.G_FALSE;
4272:
4273: -- Populate the constant values
4274:
4275: l_job_header_rec.load_type := lc_non_std_update_load_type;

Line 4331: RAISE FND_API.G_EXC_ERROR;

4327: -- it would force a wip_supply_type of pull, which
4328: -- required backflush.
4329: FND_MESSAGE.SET_NAME('CSD','CSD_DEF_OP_DEPT_NULL');
4330: FND_MSG_PUB.ADD;
4331: RAISE FND_API.G_EXC_ERROR;
4332: else
4333: l_op_dtls_tbl(1).new_row := 'Y';
4334: l_op_dtls_tbl(1).wip_entity_id := p_mtl_txn_dtls_tbl(mtl_ctr).wip_entity_id;
4335: l_op_dtls_tbl(1).organization_id := p_mtl_txn_dtls_tbl(mtl_ctr).organization_id;

Line 4348: p_init_msg_list => fnd_api.g_false,

4344:
4345: PROCESS_SAVE_OP_DTLS
4346: (
4347: p_api_version_number => 1.0,
4348: p_init_msg_list => fnd_api.g_false,
4349: p_Commit => fnd_api.g_false,
4350: p_validation_level => p_validation_level,
4351: x_return_status => x_return_status,
4352: x_msg_count => x_msg_count,

Line 4349: p_Commit => fnd_api.g_false,

4345: PROCESS_SAVE_OP_DTLS
4346: (
4347: p_api_version_number => 1.0,
4348: p_init_msg_list => fnd_api.g_false,
4349: p_Commit => fnd_api.g_false,
4350: p_validation_level => p_validation_level,
4351: x_return_status => x_return_status,
4352: x_msg_count => x_msg_count,
4353: x_msg_data => x_msg_data,

Line 4356: if (x_return_status = FND_API.G_RET_STS_SUCCESS) then

4352: x_msg_count => x_msg_count,
4353: x_msg_data => x_msg_data,
4354: p_op_dtls_tbl => l_op_dtls_tbl
4355: );
4356: if (x_return_status = FND_API.G_RET_STS_SUCCESS) then
4357: l_op_seq_num := l_op_dtls_tbl(1).operation_seq_num;
4358: x_op_created := FND_API.G_TRUE;
4359: else
4360: FND_MESSAGE.SET_NAME('CSD','CSD_OP_AUTO_CREATE_FAILURE');

Line 4358: x_op_created := FND_API.G_TRUE;

4354: p_op_dtls_tbl => l_op_dtls_tbl
4355: );
4356: if (x_return_status = FND_API.G_RET_STS_SUCCESS) then
4357: l_op_seq_num := l_op_dtls_tbl(1).operation_seq_num;
4358: x_op_created := FND_API.G_TRUE;
4359: else
4360: FND_MESSAGE.SET_NAME('CSD','CSD_OP_AUTO_CREATE_FAILURE');
4361: FND_MSG_PUB.ADD;
4362: RAISE FND_API.G_EXC_ERROR;

Line 4362: RAISE FND_API.G_EXC_ERROR;

4358: x_op_created := FND_API.G_TRUE;
4359: else
4360: FND_MESSAGE.SET_NAME('CSD','CSD_OP_AUTO_CREATE_FAILURE');
4361: FND_MSG_PUB.ADD;
4362: RAISE FND_API.G_EXC_ERROR;
4363: end if;
4364: end if; -- department profile
4365: end if; -- operation does not exist
4366: end if;

Line 4396: RAISE FND_API.G_EXC_ERROR;

4392:
4393: If l_job_details_rec.supply_subinventory is null then
4394: FND_MESSAGE.SET_NAME('CSD','CSD_DEF_SUB_INV_NULL');
4395: FND_MSG_PUB.ADD;
4396: RAISE FND_API.G_EXC_ERROR;
4397: end if;
4398:
4399:
4400:

Line 4415: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4411: insert_job_header( p_job_header_rec => l_job_header_rec,
4412: x_return_status => x_return_status );
4413:
4414:
4415: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4417: END IF;
4418:
4419:

Line 4416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4412: x_return_status => x_return_status );
4413:
4414:
4415: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4417: END IF;
4418:
4419:
4420: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 4430: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4426:
4427: insert_job_details( p_job_details_rec => l_job_details_rec,
4428: x_return_status => x_return_status );
4429:
4430: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4431: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4432: END IF;
4433:
4434:

Line 4431: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4427: insert_job_details( p_job_details_rec => l_job_details_rec,
4428: x_return_status => x_return_status );
4429:
4430: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4431: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4432: END IF;
4433:
4434:
4435:

Line 4452: x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

4448: x_returnStatus => x_return_status,
4449: x_errorMsg => x_msg_data );
4450:
4451: If ( ml_error_exists( l_job_header_rec.group_id ) or
4452: x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
4453:
4454: FND_MESSAGE.SET_NAME('CSD','CSD_MTL_ADD_MASS_LD_FAILURE');
4455: FND_MSG_PUB.ADD;
4456: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4456: x_return_status := FND_API.G_RET_STS_ERROR;

4452: x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
4453:
4454: FND_MESSAGE.SET_NAME('CSD','CSD_MTL_ADD_MASS_LD_FAILURE');
4455: FND_MSG_PUB.ADD;
4456: x_return_status := FND_API.G_RET_STS_ERROR;
4457:
4458: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
4459: p_count => x_msg_count,
4460: p_data => x_msg_data);

Line 4458: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

4454: FND_MESSAGE.SET_NAME('CSD','CSD_MTL_ADD_MASS_LD_FAILURE');
4455: FND_MSG_PUB.ADD;
4456: x_return_status := FND_API.G_RET_STS_ERROR;
4457:
4458: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
4459: p_count => x_msg_count,
4460: p_data => x_msg_data);
4461: -- Need to rollback Raise exception -
4462: -- once commit is removed from above call

Line 4463: -- raise FND_API.G_EXC_ERROR;

4459: p_count => x_msg_count,
4460: p_data => x_msg_data);
4461: -- Need to rollback Raise exception -
4462: -- once commit is removed from above call
4463: -- raise FND_API.G_EXC_ERROR;
4464: RETURN;
4465: end if;
4466:
4467: EXCEPTION

Line 4474: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4470: 2 /* 2 = materials */);
4471:
4472: -- when rollback for WIP works, remove x_return_status, count_and_get,
4473: -- and return then reinstate raise exception above
4474: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4475: /*
4476: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4477: -- Add Unexpected Error to Message List, here SQLERRM is used for
4478: -- getting the error

Line 4484: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

4480: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
4481: p_procedure_name => lc_api_name );
4482: END IF;
4483: */
4484: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
4485: p_count => x_msg_count,
4486: p_data => x_msg_data);
4487:
4488: END;

Line 4572: IF FND_API.to_Boolean( p_commit )

4568:
4569: END LOOP;
4570:
4571: -- Standard check for p_commit
4572: IF FND_API.to_Boolean( p_commit )
4573: THEN
4574: COMMIT WORK;
4575: END IF;
4576:

Line 4578: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4574: COMMIT WORK;
4575: END IF;
4576:
4577: EXCEPTION
4578: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4579: ROLLBACK to PROCESS_SAVE_MTL_TXN_DTLS_PVT ;
4580: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4581:
4582: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 4580: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4576:
4577: EXCEPTION
4578: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4579: ROLLBACK to PROCESS_SAVE_MTL_TXN_DTLS_PVT ;
4580: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4581:
4582: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
4583: p_count => x_msg_count,
4584: p_data => x_msg_data);

Line 4582: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

4578: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4579: ROLLBACK to PROCESS_SAVE_MTL_TXN_DTLS_PVT ;
4580: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4581:
4582: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
4583: p_count => x_msg_count,
4584: p_data => x_msg_data);
4585:
4586: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 4593: WHEN FND_API.G_EXC_ERROR THEN

4589: 'G_EXC_UNEXPECTED_ERROR Exception');
4590: END IF;
4591:
4592:
4593: WHEN FND_API.G_EXC_ERROR THEN
4594: ROLLBACK to PROCESS_SAVE_MTL_TXN_DTLS_PVT ;
4595: x_return_status := FND_API.G_RET_STS_ERROR;
4596:
4597:

Line 4595: x_return_status := FND_API.G_RET_STS_ERROR;

4591:
4592:
4593: WHEN FND_API.G_EXC_ERROR THEN
4594: ROLLBACK to PROCESS_SAVE_MTL_TXN_DTLS_PVT ;
4595: x_return_status := FND_API.G_RET_STS_ERROR;
4596:
4597:
4598: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
4599: p_count => x_msg_count,

Line 4598: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

4594: ROLLBACK to PROCESS_SAVE_MTL_TXN_DTLS_PVT ;
4595: x_return_status := FND_API.G_RET_STS_ERROR;
4596:
4597:
4598: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
4599: p_count => x_msg_count,
4600: p_data => x_msg_data);
4601:
4602: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 4610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4606: END IF;
4607:
4608: WHEN OTHERS THEN
4609: ROLLBACK to PROCESS_SAVE_MTL_TXN_DTLS_PVT ;
4610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4611:
4612: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4613:
4614: -- Add Unexpected Error to Message List, here SQLERRM is used for

Line 4621: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

4617: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
4618: p_procedure_name => lc_api_name );
4619: END IF;
4620:
4621: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
4622: p_count => x_msg_count,
4623: p_data => x_msg_data);
4624:
4625: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 4724: IF NOT FND_API.Compatible_API_Call

4720:
4721: -- Standard Start of API savepoint
4722: SAVEPOINT PROCESS_SAVE_RES_TXN_DTLS_PVT;
4723: -- Standard call to check for call compatibility.
4724: IF NOT FND_API.Compatible_API_Call
4725: (lc_api_version_number,
4726: p_api_version_number,
4727: lc_api_name,
4728: G_PKG_NAME)

Line 4730: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4726: p_api_version_number,
4727: lc_api_name,
4728: G_PKG_NAME)
4729: THEN
4730: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4731: END IF;
4732:
4733:
4734: -- Initialize message list if p_init_msg_list is set to TRUE

Line 4735: IF FND_API.to_boolean(p_init_msg_list) THEN

4731: END IF;
4732:
4733:
4734: -- Initialize message list if p_init_msg_list is set to TRUE
4735: IF FND_API.to_boolean(p_init_msg_list) THEN
4736: FND_MSG_PUB.initialize;
4737: END IF;
4738:
4739: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4739: x_return_status := FND_API.G_RET_STS_SUCCESS;

4735: IF FND_API.to_boolean(p_init_msg_list) THEN
4736: FND_MSG_PUB.initialize;
4737: END IF;
4738:
4739: x_return_status := FND_API.G_RET_STS_SUCCESS;
4740:
4741:
4742:
4743: -- Populate the constant values

Line 4834: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4830: insert_job_header( p_job_header_rec => l_job_header_rec,
4831: x_return_status => x_return_status );
4832:
4833:
4834: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4835: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4836: END IF;
4837:
4838:

Line 4835: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4831: x_return_status => x_return_status );
4832:
4833:
4834: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4835: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4836: END IF;
4837:
4838:
4839: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 4849: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4845:
4846: insert_job_details( p_job_details_rec => l_job_details_rec,
4847: x_return_status => x_return_status );
4848:
4849: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4851: END IF;
4852:
4853:

Line 4850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4846: insert_job_details( p_job_details_rec => l_job_details_rec,
4847: x_return_status => x_return_status );
4848:
4849: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4851: END IF;
4852:
4853:
4854:

Line 4871: x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

4867: x_returnStatus => x_return_status,
4868: x_errorMsg => x_msg_data );
4869:
4870: If ( ml_error_exists( l_job_header_rec.group_id ) or
4871: x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
4872:
4873: FND_MESSAGE.SET_NAME('CSD','CSD_RES_ADD_MASS_LD_FAILURE');
4874: FND_MSG_PUB.ADD;
4875: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4875: x_return_status := FND_API.G_RET_STS_ERROR;

4871: x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
4872:
4873: FND_MESSAGE.SET_NAME('CSD','CSD_RES_ADD_MASS_LD_FAILURE');
4874: FND_MSG_PUB.ADD;
4875: x_return_status := FND_API.G_RET_STS_ERROR;
4876:
4877: FND_MSG_PUB.count_and_get(p_encoded => FND_API.G_FALSE,
4878: p_count => x_msg_count,
4879: p_data => x_msg_data);

Line 4877: FND_MSG_PUB.count_and_get(p_encoded => FND_API.G_FALSE,

4873: FND_MESSAGE.SET_NAME('CSD','CSD_RES_ADD_MASS_LD_FAILURE');
4874: FND_MSG_PUB.ADD;
4875: x_return_status := FND_API.G_RET_STS_ERROR;
4876:
4877: FND_MSG_PUB.count_and_get(p_encoded => FND_API.G_FALSE,
4878: p_count => x_msg_count,
4879: p_data => x_msg_data);
4880:
4881: -- Need to rollback Raise exception -

Line 4883: -- raise FND_API.G_EXC_ERROR;

4879: p_data => x_msg_data);
4880:
4881: -- Need to rollback Raise exception -
4882: -- once commit is removed from above call
4883: -- raise FND_API.G_EXC_ERROR;
4884: RETURN;
4885: end if;
4886:
4887: EXCEPTION

Line 4891: -- raise FND_API.G_EXC_UNEXPECTED_ERROR;

4887: EXCEPTION
4888: WHEN OTHERS THEN
4889: add_wip_interface_errors(l_job_header_rec.group_id,
4890: 3 /* 3 = resources */);
4891: -- raise FND_API.G_EXC_UNEXPECTED_ERROR;
4892:
4893: -- when rollback for WIP works, remove x_return_status, count_and_get,
4894: -- and return then reinstate raise exception above
4895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4891: -- raise FND_API.G_EXC_UNEXPECTED_ERROR;
4892:
4893: -- when rollback for WIP works, remove x_return_status, count_and_get,
4894: -- and return then reinstate raise exception above
4895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4896: /*
4897: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4898: -- Add Unexpected Error to Message List, here SQLERRM is used for
4899: -- getting the error

Line 4904: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

4900: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
4901: p_procedure_name => lc_api_name );
4902: END IF;
4903: */
4904: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
4905: p_count => x_msg_count,
4906: p_data => x_msg_data);
4907: return;
4908: END;

Line 4993: IF FND_API.to_Boolean( p_commit )

4989:
4990: END LOOP;
4991:
4992: -- Standard check for p_commit
4993: IF FND_API.to_Boolean( p_commit )
4994: THEN
4995: COMMIT WORK;
4996: END IF;
4997:

Line 4999: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4995: COMMIT WORK;
4996: END IF;
4997:
4998: EXCEPTION
4999: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5000: ROLLBACK to PROCESS_SAVE_RES_TXN_DTLS_PVT ;
5001: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5002:
5003: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 5001: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4997:
4998: EXCEPTION
4999: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5000: ROLLBACK to PROCESS_SAVE_RES_TXN_DTLS_PVT ;
5001: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5002:
5003: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
5004: p_count => x_msg_count,
5005: p_data => x_msg_data);

Line 5003: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

4999: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5000: ROLLBACK to PROCESS_SAVE_RES_TXN_DTLS_PVT ;
5001: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5002:
5003: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
5004: p_count => x_msg_count,
5005: p_data => x_msg_data);
5006:
5007: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 5014: WHEN FND_API.G_EXC_ERROR THEN

5010: 'G_EXC_UNEXPECTED_ERROR Exception');
5011: END IF;
5012:
5013:
5014: WHEN FND_API.G_EXC_ERROR THEN
5015: ROLLBACK to PROCESS_SAVE_RES_TXN_DTLS_PVT ;
5016: x_return_status := FND_API.G_RET_STS_ERROR;
5017:
5018:

Line 5016: x_return_status := FND_API.G_RET_STS_ERROR;

5012:
5013:
5014: WHEN FND_API.G_EXC_ERROR THEN
5015: ROLLBACK to PROCESS_SAVE_RES_TXN_DTLS_PVT ;
5016: x_return_status := FND_API.G_RET_STS_ERROR;
5017:
5018:
5019: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
5020: p_count => x_msg_count,

Line 5019: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

5015: ROLLBACK to PROCESS_SAVE_RES_TXN_DTLS_PVT ;
5016: x_return_status := FND_API.G_RET_STS_ERROR;
5017:
5018:
5019: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
5020: p_count => x_msg_count,
5021: p_data => x_msg_data);
5022:
5023: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 5031: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5027: END IF;
5028:
5029: WHEN OTHERS THEN
5030: ROLLBACK to PROCESS_SAVE_RES_TXN_DTLS_PVT ;
5031: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5032:
5033: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5034:
5035: -- Add Unexpected Error to Message List, here SQLERRM is used for

Line 5042: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

5038: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
5039: p_procedure_name => lc_api_name );
5040: END IF;
5041:
5042: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
5043: p_count => x_msg_count,
5044: p_data => x_msg_data);
5045:
5046: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 5111: IF NOT FND_API.Compatible_API_Call

5107: -- Standard Start of API savepoint
5108: SAVEPOINT PROCESS_SAVE_OP_DTLS_PVT;
5109:
5110: -- Standard call to check for call compatibility.
5111: IF NOT FND_API.Compatible_API_Call
5112: (lc_api_version_number,
5113: p_api_version_number,
5114: lc_api_name,
5115: G_PKG_NAME)

Line 5117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5113: p_api_version_number,
5114: lc_api_name,
5115: G_PKG_NAME)
5116: THEN
5117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5118: END IF;
5119:
5120:
5121: -- Initialize message list if p_init_msg_list is set to TRUE

Line 5122: IF FND_API.to_boolean(p_init_msg_list) THEN

5118: END IF;
5119:
5120:
5121: -- Initialize message list if p_init_msg_list is set to TRUE
5122: IF FND_API.to_boolean(p_init_msg_list) THEN
5123: FND_MSG_PUB.initialize;
5124: END IF;
5125:
5126: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5126: x_return_status := FND_API.G_RET_STS_SUCCESS;

5122: IF FND_API.to_boolean(p_init_msg_list) THEN
5123: FND_MSG_PUB.initialize;
5124: END IF;
5125:
5126: x_return_status := FND_API.G_RET_STS_SUCCESS;
5127:
5128: -- Populate the constant values for job header
5129: l_job_header_rec.load_type := lc_non_std_update_load_type;
5130:

Line 5196: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5192:
5193: insert_job_header( p_job_header_rec => l_job_header_rec,
5194: x_return_status => x_return_status );
5195:
5196: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5198: END IF;
5199:
5200: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 5197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5193: insert_job_header( p_job_header_rec => l_job_header_rec,
5194: x_return_status => x_return_status );
5195:
5196: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5198: END IF;
5199:
5200: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5201: FND_LOG.STRING( FND_LOG.LEVEL_EVENT,

Line 5209: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5205:
5206: insert_job_details( p_job_details_rec => l_job_details_rec,
5207: x_return_status => x_return_status );
5208:
5209: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5211: END IF;
5212:
5213: -- Call WIP Mass Load API

Line 5210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5206: insert_job_details( p_job_details_rec => l_job_details_rec,
5207: x_return_status => x_return_status );
5208:
5209: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5211: END IF;
5212:
5213: -- Call WIP Mass Load API
5214: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 5228: x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

5224: x_returnStatus => x_return_status,
5225: x_errorMsg => x_msg_data );
5226:
5227: If ( ml_error_exists( l_job_header_rec.group_id ) or
5228: x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
5229:
5230: FND_MESSAGE.SET_NAME('CSD','CSD_OP_ADD_MASS_LD_FAILURE');
5231: FND_MSG_PUB.ADD;
5232: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5232: x_return_status := FND_API.G_RET_STS_ERROR;

5228: x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
5229:
5230: FND_MESSAGE.SET_NAME('CSD','CSD_OP_ADD_MASS_LD_FAILURE');
5231: FND_MSG_PUB.ADD;
5232: x_return_status := FND_API.G_RET_STS_ERROR;
5233:
5234: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
5235: p_count => x_msg_count,
5236: p_data => x_msg_data);

Line 5234: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

5230: FND_MESSAGE.SET_NAME('CSD','CSD_OP_ADD_MASS_LD_FAILURE');
5231: FND_MSG_PUB.ADD;
5232: x_return_status := FND_API.G_RET_STS_ERROR;
5233:
5234: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
5235: p_count => x_msg_count,
5236: p_data => x_msg_data);
5237:
5238: -- Need to rollback Raise exception -

Line 5240: -- raise FND_API.G_EXC_ERROR;

5236: p_data => x_msg_data);
5237:
5238: -- Need to rollback Raise exception -
5239: -- once commit is removed from above call
5240: -- raise FND_API.G_EXC_ERROR;
5241: RETURN;
5242: end if;
5243: EXCEPTION
5244: WHEN OTHERS THEN

Line 5247: -- raise FND_API.G_EXC_UNEXPECTED_ERROR;

5243: EXCEPTION
5244: WHEN OTHERS THEN
5245: add_wip_interface_errors(l_job_header_rec.group_id,
5246: 1 /* 1 = operations */);
5247: -- raise FND_API.G_EXC_UNEXPECTED_ERROR;
5248:
5249: -- when rollback for WIP works, remove x_return_status, count_and_get,
5250: -- and return then reinstate raise exception above
5251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5247: -- raise FND_API.G_EXC_UNEXPECTED_ERROR;
5248:
5249: -- when rollback for WIP works, remove x_return_status, count_and_get,
5250: -- and return then reinstate raise exception above
5251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5252: /*
5253: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5254:
5255: -- Add Unexpected Error to Message List, here SQLERRM is used for

Line 5262: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

5258: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
5259: p_procedure_name => lc_api_name );
5260: END IF;
5261: */
5262: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
5263: p_count => x_msg_count,
5264: p_data => x_msg_data);
5265: return;
5266: END;

Line 5349: IF FND_API.to_Boolean( p_commit )

5345: end if;
5346: END LOOP;
5347:
5348: -- Standard check for p_commit
5349: IF FND_API.to_Boolean( p_commit )
5350: THEN
5351: COMMIT WORK;
5352: END IF;
5353:

Line 5355: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5351: COMMIT WORK;
5352: END IF;
5353:
5354: EXCEPTION
5355: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5356: ROLLBACK to PROCESS_SAVE_OP_DTLS_PVT ;
5357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5358:
5359: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 5357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5353:
5354: EXCEPTION
5355: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5356: ROLLBACK to PROCESS_SAVE_OP_DTLS_PVT ;
5357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5358:
5359: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
5360: p_count => x_msg_count,
5361: p_data => x_msg_data);

Line 5359: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

5355: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5356: ROLLBACK to PROCESS_SAVE_OP_DTLS_PVT ;
5357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5358:
5359: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
5360: p_count => x_msg_count,
5361: p_data => x_msg_data);
5362:
5363: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 5370: WHEN FND_API.G_EXC_ERROR THEN

5366: 'G_EXC_UNEXPECTED_ERROR Exception');
5367: END IF;
5368:
5369:
5370: WHEN FND_API.G_EXC_ERROR THEN
5371: ROLLBACK to PROCESS_SAVE_OP_DTLS_PVT ;
5372: x_return_status := FND_API.G_RET_STS_ERROR;
5373:
5374:

Line 5372: x_return_status := FND_API.G_RET_STS_ERROR;

5368:
5369:
5370: WHEN FND_API.G_EXC_ERROR THEN
5371: ROLLBACK to PROCESS_SAVE_OP_DTLS_PVT ;
5372: x_return_status := FND_API.G_RET_STS_ERROR;
5373:
5374:
5375: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
5376: p_count => x_msg_count,

Line 5375: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

5371: ROLLBACK to PROCESS_SAVE_OP_DTLS_PVT ;
5372: x_return_status := FND_API.G_RET_STS_ERROR;
5373:
5374:
5375: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
5376: p_count => x_msg_count,
5377: p_data => x_msg_data);
5378:
5379: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 5387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5383: END IF;
5384:
5385: WHEN OTHERS THEN
5386: ROLLBACK to PROCESS_SAVE_OP_DTLS_PVT ;
5387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5388:
5389: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5390:
5391: -- Add Unexpected Error to Message List, here SQLERRM is used for

Line 5398: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

5394: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
5395: p_procedure_name => lc_api_name );
5396: END IF;
5397:
5398: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
5399: p_count => x_msg_count,
5400: p_data => x_msg_data);
5401:
5402: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 5523: IF NOT FND_API.Compatible_API_Call

5519:
5520: -- Standard Start of API savepoint
5521: SAVEPOINT CREATE_WIP_JOB_PVT;
5522: -- Standard call to check for call compatibility.
5523: IF NOT FND_API.Compatible_API_Call
5524: (lc_api_version_number,
5525: p_api_version_number,
5526: lc_api_name,
5527: G_PKG_NAME)

Line 5529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5525: p_api_version_number,
5526: lc_api_name,
5527: G_PKG_NAME)
5528: THEN
5529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5530: END IF;
5531:
5532: -- Initialize message list if p_init_msg_list is set to TRUE
5533: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 5533: IF FND_API.to_boolean(p_init_msg_list) THEN

5529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5530: END IF;
5531:
5532: -- Initialize message list if p_init_msg_list is set to TRUE
5533: IF FND_API.to_boolean(p_init_msg_list) THEN
5534: FND_MSG_PUB.initialize;
5535: END IF;
5536:
5537: -- Initialize API return status to success

Line 5538: x_return_status:=FND_API.G_RET_STS_SUCCESS;

5534: FND_MSG_PUB.initialize;
5535: END IF;
5536:
5537: -- Initialize API return status to success
5538: x_return_status:=FND_API.G_RET_STS_SUCCESS;
5539:
5540:
5541: l_job_header_rec.organization_id :=
5542: fnd_profile.value('CSD_DEF_REP_INV_ORG');

Line 5550: RAISE FND_API.G_EXC_ERROR;

5546: IF l_job_header_rec.organization_id is NULL THEN
5547:
5548: FND_MESSAGE.SET_NAME('CSD','CSD_DEF_REP_INV_NULL');
5549: FND_MSG_PUB.ADD;
5550: RAISE FND_API.G_EXC_ERROR;
5551: end if;
5552:
5553:
5554: l_job_prefix := fnd_profile.value('CSD_DEFAULT_JOB_PREFIX');

Line 5564: RAISE FND_API.G_EXC_ERROR;

5560: IF l_job_prefix is NULL THEN
5561:
5562: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_PREFIX_NULL');
5563: FND_MSG_PUB.ADD;
5564: RAISE FND_API.G_EXC_ERROR;
5565: end if;
5566:
5567:
5568:

Line 5578: RAISE FND_API.G_EXC_ERROR;

5574: IF l_job_header_rec.class_code is NULL THEN
5575:
5576: FND_MESSAGE.SET_NAME('CSD','CSD_CLASS_CODE_NULL');
5577: FND_MSG_PUB.ADD;
5578: RAISE FND_API.G_EXC_ERROR;
5579: end if;
5580:
5581:
5582:

Line 5653: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5649: x_return_status =>
5650: x_return_status );
5651:
5652:
5653: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5654: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5655: END IF;
5656:
5657:

Line 5654: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5650: x_return_status );
5651:
5652:
5653: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5654: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5655: END IF;
5656:
5657:
5658: -- CALL WIP API to process records in wip interface table,

Line 5681: x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

5677:
5678:
5679:
5680: If ( ml_error_exists( l_job_header_rec.group_id ) or
5681: x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
5682:
5683: -- ROLLBACK to CREATE_WIP_JOB_PVT ;
5684:
5685:

Line 5688: RAISE FND_API.G_EXC_ERROR;

5684:
5685:
5686: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_CREAT_FAILURE');
5687: FND_MSG_PUB.ADD;
5688: RAISE FND_API.G_EXC_ERROR;
5689:
5690: -- Need to rollback Raise exception -
5691: -- once commit is removed from above call
5692:

Line 5784: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

5780: x_op_created => l_op_created,
5781: x_return_status => x_return_status,
5782: x_msg_count => x_msg_count,
5783: x_msg_data => x_msg_data);
5784: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5785: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_GEN_FAILURE');
5786: FND_MSG_PUB.ADD;
5787: RAISE FND_API.G_EXC_ERROR;
5788: END IF;

Line 5787: RAISE FND_API.G_EXC_ERROR;

5783: x_msg_data => x_msg_data);
5784: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5785: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_GEN_FAILURE');
5786: FND_MSG_PUB.ADD;
5787: RAISE FND_API.G_EXC_ERROR;
5788: END IF;
5789: end if;
5790: end if; -- swai: bug 7477845/7483291 num other jobs = 0
5791: end if;

Line 5796: /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5792: --*****End of the code to Default Repair Item as Material on Job**********
5793:
5794:
5795:
5796: /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5797: ROLLBACK to CREATE_WIP_JOB_PVT ;
5798:
5799:
5800: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_CREAT_FAILURE');

Line 5802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR; */

5798:
5799:
5800: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_CREAT_FAILURE');
5801: FND_MSG_PUB.ADD;
5802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR; */
5803:
5804:
5805: -- dbms_output.put_line('In Error');
5806:

Line 5833: p_init_msg_list => FND_API.G_FALSE,

5829:
5830:
5831: csd_to_form_repair_job_xref.validate_and_write(
5832: p_api_version_number => lc_api_version_number,
5833: p_init_msg_list => FND_API.G_FALSE,
5834: p_commit => FND_API.G_FALSE,
5835: p_validation_level => NULL,
5836: p_action_code => 0,
5837: px_repair_job_xref_id => l_repair_xref_id,

Line 5834: p_commit => FND_API.G_FALSE,

5830:
5831: csd_to_form_repair_job_xref.validate_and_write(
5832: p_api_version_number => lc_api_version_number,
5833: p_init_msg_list => FND_API.G_FALSE,
5834: p_commit => FND_API.G_FALSE,
5835: p_validation_level => NULL,
5836: p_action_code => 0,
5837: px_repair_job_xref_id => l_repair_xref_id,
5838: p_created_by => l_user_id,

Line 5877: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5873: x_msg_count => x_msg_count,
5874: x_msg_data => x_msg_data);
5875:
5876:
5877: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5878: ROLLBACK to CREATE_WIP_JOB_PVT ;
5879:
5880: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5881: FND_LOG.STRING( FND_LOG.LEVEL_ERROR,

Line 5901: p_init_msg_list => FND_API.G_FALSE,

5897:
5898:
5899: csd_to_form_repair_history.validate_and_write(
5900: p_api_version_number => lc_api_version_number,
5901: p_init_msg_list => FND_API.G_FALSE,
5902: p_commit => FND_API.G_FALSE,
5903: p_validation_level => NULL,
5904: p_action_code => 0,
5905: px_repair_history_id => l_rep_hist_id,

Line 5902: p_commit => FND_API.G_FALSE,

5898:
5899: csd_to_form_repair_history.validate_and_write(
5900: p_api_version_number => lc_api_version_number,
5901: p_init_msg_list => FND_API.G_FALSE,
5902: p_commit => FND_API.G_FALSE,
5903: p_validation_level => NULL,
5904: p_action_code => 0,
5905: px_repair_history_id => l_rep_hist_id,
5906: p_OBJECT_VERSION_NUMBER => NULL,

Line 5969: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5965: x_return_status => x_return_status,
5966: x_msg_count => x_msg_count,
5967: x_msg_data => x_msg_data);
5968:
5969: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5970: ROLLBACK to CREATE_WIP_JOB_PVT ;
5971:
5972: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5973: FND_LOG.STRING( FND_LOG.LEVEL_ERROR,

Line 5983: IF FND_API.to_Boolean( p_commit )

5979:
5980: END IF;
5981:
5982: -- Standard check for p_commit
5983: IF FND_API.to_Boolean( p_commit )
5984: THEN
5985: COMMIT WORK;
5986: END IF;
5987:

Line 5990: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5986: END IF;
5987:
5988:
5989: EXCEPTION
5990: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5991: ROLLBACK to CREATE_WIP_JOB_PVT ;
5992: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5993:
5994: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 5992: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5988:
5989: EXCEPTION
5990: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5991: ROLLBACK to CREATE_WIP_JOB_PVT ;
5992: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5993:
5994: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
5995: p_count => x_msg_count,
5996: p_data => x_msg_data);

Line 5994: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

5990: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5991: ROLLBACK to CREATE_WIP_JOB_PVT ;
5992: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5993:
5994: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
5995: p_count => x_msg_count,
5996: p_data => x_msg_data);
5997:
5998: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 6005: WHEN FND_API.G_EXC_ERROR THEN

6001: 'G_EXC_UNEXPECTED_ERROR Exception');
6002: END IF;
6003:
6004:
6005: WHEN FND_API.G_EXC_ERROR THEN
6006: ROLLBACK to CREATE_WIP_JOB_PVT ;
6007: x_return_status := FND_API.G_RET_STS_ERROR;
6008:
6009:

Line 6007: x_return_status := FND_API.G_RET_STS_ERROR;

6003:
6004:
6005: WHEN FND_API.G_EXC_ERROR THEN
6006: ROLLBACK to CREATE_WIP_JOB_PVT ;
6007: x_return_status := FND_API.G_RET_STS_ERROR;
6008:
6009:
6010: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
6011: p_count => x_msg_count,

Line 6010: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

6006: ROLLBACK to CREATE_WIP_JOB_PVT ;
6007: x_return_status := FND_API.G_RET_STS_ERROR;
6008:
6009:
6010: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
6011: p_count => x_msg_count,
6012: p_data => x_msg_data);
6013:
6014: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 6022: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6018: END IF;
6019:
6020: WHEN OTHERS THEN
6021: ROLLBACK to CREATE_WIP_JOB_PVT ;
6022: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6023:
6024: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6025:
6026: -- Add Unexpected Error to Message List, here SQLERRM is used for

Line 6033: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

6029: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
6030: p_procedure_name => lc_api_name );
6031: END IF;
6032:
6033: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
6034: p_count => x_msg_count,
6035: p_data => x_msg_data);
6036:
6037: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 6195: IF NOT FND_API.Compatible_API_Call

6191:
6192: -- Standard Start of API savepoint
6193: SAVEPOINT GENERATE_WIP_JOBS_FROM_SCS_PVT;
6194: -- Standard call to check for call compatibility.
6195: IF NOT FND_API.Compatible_API_Call
6196: (lc_api_version_number,
6197: p_api_version_number,
6198: lc_api_name,
6199: G_PKG_NAME)

Line 6201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6197: p_api_version_number,
6198: lc_api_name,
6199: G_PKG_NAME)
6200: THEN
6201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6202: END IF;
6203:
6204: -- Initialize message list if p_init_msg_list is set to TRUE
6205: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 6205: IF FND_API.to_boolean(p_init_msg_list) THEN

6201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6202: END IF;
6203:
6204: -- Initialize message list if p_init_msg_list is set to TRUE
6205: IF FND_API.to_boolean(p_init_msg_list) THEN
6206: FND_MSG_PUB.initialize;
6207: END IF;
6208:
6209: -- Initialize API return status to success

Line 6210: x_return_status:=FND_API.G_RET_STS_SUCCESS;

6206: FND_MSG_PUB.initialize;
6207: END IF;
6208:
6209: -- Initialize API return status to success
6210: x_return_status:=FND_API.G_RET_STS_SUCCESS;
6211:
6212: l_job_header_rec.organization_id :=
6213: fnd_profile.value('CSD_DEF_REP_INV_ORG');
6214:

Line 6220: RAISE FND_API.G_EXC_ERROR;

6216: IF l_job_header_rec.organization_id is NULL THEN
6217:
6218: FND_MESSAGE.SET_NAME('CSD','CSD_DEF_REP_INV_NULL');
6219: FND_MSG_PUB.ADD;
6220: RAISE FND_API.G_EXC_ERROR;
6221: END IF;
6222:
6223: l_job_prefix := fnd_profile.value('CSD_DEFAULT_JOB_PREFIX');
6224:

Line 6229: RAISE FND_API.G_EXC_ERROR;

6225: -- If l_job_prefix is null, throw an error and return;
6226: IF l_job_prefix is NULL THEN
6227: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_PREFIX_NULL');
6228: FND_MSG_PUB.ADD;
6229: RAISE FND_API.G_EXC_ERROR;
6230: END IF;
6231:
6232: l_job_header_rec.class_code :=
6233: fnd_profile.value('CSD_DEF_WIP_ACCOUNTING_CLASS');

Line 6238: RAISE FND_API.G_EXC_ERROR;

6234:
6235: IF l_job_header_rec.class_code is NULL THEN
6236: FND_MESSAGE.SET_NAME('CSD','CSD_CLASS_CODE_NULL');
6237: FND_MSG_PUB.ADD;
6238: RAISE FND_API.G_EXC_ERROR;
6239: END IF;
6240:
6241: -- Populate the Job Header Record
6242:

Line 6325: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6321:
6322: -- dbms_output.put_line('After insert_job_header');
6323:
6324:
6325: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6327: END IF;
6328:
6329: -- CALL WIP API to process records in wip interface table,

Line 6326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6322: -- dbms_output.put_line('After insert_job_header');
6323:
6324:
6325: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6327: END IF;
6328:
6329: -- CALL WIP API to process records in wip interface table,
6330: -- If API fails, Raise error, rollback and return

Line 6348: x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

6344: x_errorMsg => x_msg_data );
6345:
6346:
6347: If ( ml_error_exists( l_job_header_rec.group_id ) or
6348: x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
6349:
6350: -- ROLLBACK to GENERATE_WIP_JOBS_FROM_SCS_PVT ;
6351:
6352:

Line 6355: RAISE FND_API.G_EXC_ERROR;

6351:
6352:
6353: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_GEN_FAILURE');
6354: FND_MSG_PUB.ADD;
6355: RAISE FND_API.G_EXC_ERROR;
6356:
6357: -- Need to rollback Raise exception -
6358: -- once commit is removed from above call
6359:

Line 6460: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

6456: x_op_created => l_op_created,
6457: x_return_status => x_return_status,
6458: x_msg_count => x_msg_count,
6459: x_msg_data => x_msg_data);
6460: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6461: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_GEN_FAILURE');
6462: FND_MSG_PUB.ADD;
6463: RAISE FND_API.G_EXC_ERROR;
6464: END IF;

Line 6463: RAISE FND_API.G_EXC_ERROR;

6459: x_msg_data => x_msg_data);
6460: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6461: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_GEN_FAILURE');
6462: FND_MSG_PUB.ADD;
6463: RAISE FND_API.G_EXC_ERROR;
6464: END IF;
6465: end if;
6466: end if; -- swai: bug 7477845/7483291 l_num_other_jobs = 0
6467: end if;

Line 6486: p_init_msg_list => FND_API.G_FALSE,

6482: END IF;
6483:
6484: csd_to_form_repair_job_xref.validate_and_write(
6485: p_api_version_number => lc_api_version_number,
6486: p_init_msg_list => FND_API.G_FALSE,
6487: p_commit => FND_API.G_FALSE,
6488: p_validation_level => NULL,
6489: p_action_code => 0,
6490: px_repair_job_xref_id => l_repair_xref_id,

Line 6487: p_commit => FND_API.G_FALSE,

6483:
6484: csd_to_form_repair_job_xref.validate_and_write(
6485: p_api_version_number => lc_api_version_number,
6486: p_init_msg_list => FND_API.G_FALSE,
6487: p_commit => FND_API.G_FALSE,
6488: p_validation_level => NULL,
6489: p_action_code => 0,
6490: px_repair_job_xref_id => l_repair_xref_id,
6491: p_created_by => l_user_id,

Line 6532: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6528:
6529: -- dbms_output.put_line('After call to csd_to_form_repair_job_xref.validate_and_write');
6530:
6531:
6532: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6533: ROLLBACK to GENERATE_WIP_JOBS_FROM_SCS_PVT ;
6534: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
6535: FND_LOG.STRING( FND_LOG.LEVEL_ERROR,
6536: lc_mod_name||'exc_exception',

Line 6550: p_init_msg_list => FND_API.G_FALSE,

6546: END IF;
6547:
6548: csd_to_form_repair_history.validate_and_write(
6549: p_api_version_number => lc_api_version_number,
6550: p_init_msg_list => FND_API.G_FALSE,
6551: p_commit => FND_API.G_FALSE,
6552: p_validation_level => NULL,
6553: p_action_code => 0,
6554: px_repair_history_id => l_rep_hist_id,

Line 6551: p_commit => FND_API.G_FALSE,

6547:
6548: csd_to_form_repair_history.validate_and_write(
6549: p_api_version_number => lc_api_version_number,
6550: p_init_msg_list => FND_API.G_FALSE,
6551: p_commit => FND_API.G_FALSE,
6552: p_validation_level => NULL,
6553: p_action_code => 0,
6554: px_repair_history_id => l_rep_hist_id,
6555: p_OBJECT_VERSION_NUMBER => NULL,

Line 6620: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6616: x_msg_data => x_msg_data);
6617:
6618: -- dbms_output.put_line('after call to csd_to_form_repair_history.validate_and_write');
6619:
6620: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6621: ROLLBACK to GENERATE_WIP_JOBS_FROM_SCS_PVT ;
6622: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
6623: FND_LOG.STRING( FND_LOG.LEVEL_ERROR,
6624: lc_mod_name||'exc_exception',

Line 6662: p_commit => FND_API.G_FALSE,

6658:
6659:
6660: CSD_RO_SERVICE_CODES_PVT.Update_RO_Service_Code(
6661: p_api_version => lc_api_version_number,
6662: p_commit => FND_API.G_FALSE,
6663: p_init_msg_list => FND_API.G_FALSE,
6664: p_validation_level => 100,
6665: p_ro_service_code_rec => l_ro_service_code_rec,
6666: x_obj_ver_number => l_object_version_number,

Line 6663: p_init_msg_list => FND_API.G_FALSE,

6659:
6660: CSD_RO_SERVICE_CODES_PVT.Update_RO_Service_Code(
6661: p_api_version => lc_api_version_number,
6662: p_commit => FND_API.G_FALSE,
6663: p_init_msg_list => FND_API.G_FALSE,
6664: p_validation_level => 100,
6665: p_ro_service_code_rec => l_ro_service_code_rec,
6666: x_obj_ver_number => l_object_version_number,
6667: x_return_status => x_return_status,

Line 6673: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6669: x_msg_data => x_msg_data ) ;
6670:
6671:
6672: -- dbms_output.put_line('after call to CSD_RO_SERVICE_CODES_PVT.Update_RO_Service_Code');
6673: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6674: -- dbms_output.put_line('inside return status CSD_RO_SERVICE_CODES_PVT.Update_RO_Service_Code');
6675: ROLLBACK to GENERATE_WIP_JOBS_FROM_SCS_PVT ;
6676: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
6677: FND_LOG.STRING( FND_LOG.LEVEL_ERROR,

Line 6690: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6686: -- swai: bug 5239301
6687: -- if there are messages to show, then set the return status in order
6688: -- to flag this, but do not rollback.
6689: if l_show_messages_flag = 'T' then
6690: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6691: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
6692: p_count => x_msg_count,
6693: p_data => x_msg_data);
6694: end if;

Line 6691: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

6687: -- if there are messages to show, then set the return status in order
6688: -- to flag this, but do not rollback.
6689: if l_show_messages_flag = 'T' then
6690: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6691: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
6692: p_count => x_msg_count,
6693: p_data => x_msg_data);
6694: end if;
6695: -- swai: end bug 5239301

Line 6698: IF FND_API.to_Boolean( p_commit )

6694: end if;
6695: -- swai: end bug 5239301
6696:
6697: -- Standard check for p_commit
6698: IF FND_API.to_Boolean( p_commit )
6699: THEN
6700: COMMIT WORK;
6701: END IF;
6702:

Line 6705: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6701: END IF;
6702:
6703:
6704: EXCEPTION
6705: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6706: ROLLBACK to GENERATE_WIP_JOBS_FROM_SCS_PVT ;
6707: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6708:
6709: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 6707: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6703:
6704: EXCEPTION
6705: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6706: ROLLBACK to GENERATE_WIP_JOBS_FROM_SCS_PVT ;
6707: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6708:
6709: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
6710: p_count => x_msg_count,
6711: p_data => x_msg_data);

Line 6709: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

6705: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6706: ROLLBACK to GENERATE_WIP_JOBS_FROM_SCS_PVT ;
6707: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6708:
6709: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
6710: p_count => x_msg_count,
6711: p_data => x_msg_data);
6712:
6713: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 6720: WHEN FND_API.G_EXC_ERROR THEN

6716: 'G_EXC_UNEXPECTED_ERROR Exception');
6717: END IF;
6718:
6719:
6720: WHEN FND_API.G_EXC_ERROR THEN
6721: ROLLBACK to GENERATE_WIP_JOBS_FROM_SCS_PVT ;
6722: x_return_status := FND_API.G_RET_STS_ERROR;
6723:
6724:

Line 6722: x_return_status := FND_API.G_RET_STS_ERROR;

6718:
6719:
6720: WHEN FND_API.G_EXC_ERROR THEN
6721: ROLLBACK to GENERATE_WIP_JOBS_FROM_SCS_PVT ;
6722: x_return_status := FND_API.G_RET_STS_ERROR;
6723:
6724:
6725: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
6726: p_count => x_msg_count,

Line 6725: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

6721: ROLLBACK to GENERATE_WIP_JOBS_FROM_SCS_PVT ;
6722: x_return_status := FND_API.G_RET_STS_ERROR;
6723:
6724:
6725: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
6726: p_count => x_msg_count,
6727: p_data => x_msg_data);
6728:
6729: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 6737: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6733: END IF;
6734:
6735: WHEN OTHERS THEN
6736: ROLLBACK to GENERATE_WIP_JOBS_FROM_SCS_PVT ;
6737: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6738:
6739: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6740:
6741: -- Add Unexpected Error to Message List, here SQLERRM is used for

Line 6748: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

6744: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
6745: p_procedure_name => lc_api_name );
6746: END IF;
6747:
6748: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
6749: p_count => x_msg_count,
6750: p_data => x_msg_data);
6751:
6752: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then