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

Line 85: x_return_status := FND_API.G_RET_STS_SUCCESS;

81: l_mod_name||'begin',
82: 'Entering procedure insert_job_header' );
83: END IF;
84:
85: x_return_status := FND_API.G_RET_STS_SUCCESS;
86:
87:
88: -- Populate the record l_job_header_rec
89:

Line 231: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

227: WHEN OTHERS THEN
228: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_HEADER_INSERT_ERR');
229: FND_MESSAGE.SET_TOKEN('JOB_NAME', l_job_header_rec.job_name );
230: FND_MSG_PUB.ADD;
231: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
232: RETURN;
233: END;
234:
235:

Line 297: x_return_status := FND_API.G_RET_STS_SUCCESS;

293: l_mod_name||'begin',
294: 'Entering procedure insert_job_header' );
295: END IF;
296:
297: x_return_status := FND_API.G_RET_STS_SUCCESS;
298:
299:
300: -- Populate the record l_job_header_rec
301:

Line 397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

393: WHEN OTHERS THEN
394: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_HEADER_INSERT_ERR');
395: FND_MESSAGE.SET_TOKEN('JOB_NAME', l_job_header_rec.job_name );
396: FND_MSG_PUB.ADD;
397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
398: RETURN;
399: END;
400:
401:

Line 446: x_return_status := FND_API.G_RET_STS_SUCCESS;

442:
443:
444: BEGIN
445:
446: x_return_status := FND_API.G_RET_STS_SUCCESS;
447:
448: -- Validate if Internal Concurrent Manager is up
449:
450: fnd_concurrent.get_manager_status(applid => l_fnd_application_id,

Line 474: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

470:
471: IF (l_activep <= 0 OR l_activep1 <= 0) THEN
472: FND_MESSAGE.SET_NAME('CSD','CSD_CONC_MGR_DOWN');
473: FND_MSG_PUB.ADD;
474: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
475: END IF;
476:
477:
478: END verify_conc_manager_status;

Line 523: x_return_status := FND_API.G_RET_STS_SUCCESS;

519:
520: -- Generated job name does exist either in the interface or wip_entities table,
521: -- Success is returned
522:
523: x_return_status := FND_API.G_RET_STS_SUCCESS;
524: RETURN;
525:
526: ELSE
527:

Line 530: x_return_status := FND_API.G_RET_STS_ERROR;

526: ELSE
527:
528: -- Job exists in wip_job_schedule_interface table, hence return Error status
529:
530: x_return_status := FND_API.G_RET_STS_ERROR;
531: RETURN;
532:
533:
534: END IF;

Line 541: x_return_status := FND_API.G_RET_STS_ERROR;

537: ELSE
538:
539: -- Job exists in wip_entities table, hence return Error status
540:
541: x_return_status := FND_API.G_RET_STS_ERROR;
542: RETURN;
543:
544:
545: END IF;

Line 589: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

585: Validate_job_name ( p_job_name => x_job_name,
586: p_organization_id => p_organization_id,
587: x_return_status => l_return_status ) ;
588:
589: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
590:
591: -- Generated job name does not exist both in the interface and wip_entities table, so exit the loop
592:
593: exit;

Line 709: RAISE FND_API.G_EXC_ERROR;

705: --message(fnd_profile.value('CSD_DEF_HV_SUBINV'));
706: IF x_MTL_TXN_DTLS_TAB_TYPE(l_counter).supply_subinventory IS NULL THEN
707: FND_MESSAGE.SET_NAME('CSD','CSD_DEF_SUB_INV_NULL');
708: FND_MSG_PUB.ADD;
709: RAISE FND_API.G_EXC_ERROR;
710: END IF;
711: x_MTL_TXN_DTLS_TAB_TYPE(l_counter).new_row := 'Y';
712:
713: x_MTL_TXN_DTLS_TAB_TYPE(l_counter).supply_locator_id := NULL;

Line 763: RAISE FND_API.G_EXC_ERROR;

759: --message(fnd_profile.value('CSD_DEF_HV_SUBINV'));
760: IF x_MTL_TXN_DTLS_TAB_TYPE(l_counter).supply_subinventory IS NULL THEN
761: FND_MESSAGE.SET_NAME('CSD','CSD_DEF_SUB_INV_NULL');
762: FND_MSG_PUB.ADD;
763: RAISE FND_API.G_EXC_ERROR;
764: END IF;
765:
766: x_MTL_TXN_DTLS_TAB_TYPE(l_counter).supply_locator_id := NULL;
767: x_MTL_TXN_DTLS_TAB_TYPE(l_counter).wip_entity_id := p_wip_entity_id;

Line 835: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

831:
832: PROCEDURE submit_jobs
833: (
834: p_api_version IN NUMBER,
835: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
836: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
837: x_return_status OUT NOCOPY VARCHAR2,
838: x_msg_count OUT NOCOPY NUMBER,
839: x_msg_data OUT NOCOPY VARCHAR2,

Line 836: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

832: PROCEDURE submit_jobs
833: (
834: p_api_version IN NUMBER,
835: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
836: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
837: x_return_status OUT NOCOPY VARCHAR2,
838: x_msg_count OUT NOCOPY NUMBER,
839: x_msg_data OUT NOCOPY VARCHAR2,
840: p_repair_line_id IN NUMBER,

Line 933: IF Not FND_API.COMPATIBLE_API_CALL( l_api_version,

929: 'Entering Private API submit_jobs');
930: END IF;
931:
932: -- Standard call to check for call compatibility
933: IF Not FND_API.COMPATIBLE_API_CALL( l_api_version,
934: p_api_version,
935: l_api_name,
936: G_PKG_NAME) THEN
937: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 937: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

933: IF Not FND_API.COMPATIBLE_API_CALL( l_api_version,
934: p_api_version,
935: l_api_name,
936: G_PKG_NAME) THEN
937: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
938: END If;
939:
940: -- Initialize message list if p_init_msg_list is set to TRUE
941: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 941: IF FND_API.to_boolean(p_init_msg_list) THEN

937: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
938: END If;
939:
940: -- Initialize message list if p_init_msg_list is set to TRUE
941: IF FND_API.to_boolean(p_init_msg_list) THEN
942: FND_MSG_PUB.initialize;
943: END IF;
944:
945: -- Initialize API return status to success

Line 946: x_return_status:=FND_API.G_RET_STS_SUCCESS;

942: FND_MSG_PUB.initialize;
943: END IF;
944:
945: -- Initialize API return status to success
946: x_return_status:=FND_API.G_RET_STS_SUCCESS;
947:
948:
949: -- Verify that the Standard and Internal Concurrent Managers are UP
950:

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

949: -- Verify that the Standard and Internal Concurrent Managers are UP
950:
951: verify_conc_manager_status ( x_return_status => x_return_status );
952:
953: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
954: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
955: END IF;
956:
957: l_default_ro_item := nvl(FND_PROFILE.VALUE('CSD_DEFAULT_RO_ITEM_AS_MATERIAL_ON_JOB'), 'N');

Line 954: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

950:
951: verify_conc_manager_status ( x_return_status => x_return_status );
952:
953: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
954: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
955: END IF;
956:
957: l_default_ro_item := nvl(FND_PROFILE.VALUE('CSD_DEFAULT_RO_ITEM_AS_MATERIAL_ON_JOB'), 'N');
958:

Line 1046: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1042: p_group_id => l_group_id,
1043: x_return_status => x_return_status );
1044:
1045:
1046: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1047: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1048: END IF;
1049:
1050: if (l_default_ro_item = 'Y') then

Line 1047: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1043: x_return_status => x_return_status );
1044:
1045:
1046: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1047: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1048: END IF;
1049:
1050: if (l_default_ro_item = 'Y') then
1051:

Line 1059: if (x_return_status <> FND_API.G_RET_STS_SUCCESS ) then

1055: x_wipEntityID => l_wip_entity_id,
1056: x_returnStatus => x_return_status,
1057: x_errorMsg => x_msg_data );
1058:
1059: if (x_return_status <> FND_API.G_RET_STS_SUCCESS ) then
1060: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_GEN_FAILURE');
1061: FND_MSG_PUB.ADD;
1062: RAISE FND_API.G_EXC_ERROR;
1063: end if;

Line 1062: RAISE FND_API.G_EXC_ERROR;

1058:
1059: if (x_return_status <> FND_API.G_RET_STS_SUCCESS ) then
1060: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_GEN_FAILURE');
1061: FND_MSG_PUB.ADD;
1062: RAISE FND_API.G_EXC_ERROR;
1063: end if;
1064:
1065: COMMIT;
1066:

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

1109: x_op_created => l_op_created,
1110: x_return_status => x_return_status,
1111: x_msg_count => x_msg_count,
1112: x_msg_data => x_msg_data);
1113: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1114: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_GEN_FAILURE');
1115: FND_MSG_PUB.ADD;
1116: RAISE FND_API.G_EXC_ERROR;
1117: END IF;

Line 1116: RAISE FND_API.G_EXC_ERROR;

1112: x_msg_data => x_msg_data);
1113: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1114: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_GEN_FAILURE');
1115: FND_MSG_PUB.ADD;
1116: RAISE FND_API.G_EXC_ERROR;
1117: END IF;
1118: end if;
1119:
1120: End if;

Line 1165: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1161: p_organization_id => p_job_header_rec.organization_id,
1162: x_return_status => x_return_status ) ;
1163:
1164:
1165: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1166:
1167: -- Job name either exists in WIP_ENTITIES or in the interface table for the specified
1168: -- organization, So raise an error and exit
1169:

Line 1173: RAISE FND_API.G_EXC_ERROR;

1169:
1170: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_NAME_EXISTS');
1171: FND_MESSAGE.SET_TOKEN('JOB_NAME', l_job_bill_routing_rec.job_name );
1172: FND_MSG_PUB.ADD;
1173: RAISE FND_API.G_EXC_ERROR;
1174: end if;
1175:
1176: ELSE
1177:

Line 1213: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1209: p_group_id => l_group_id,
1210: x_return_status => x_return_status );
1211:
1212:
1213: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1215: END IF;
1216:
1217: if (l_default_ro_item = 'Y') then

Line 1214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1210: x_return_status => x_return_status );
1211:
1212:
1213: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1215: END IF;
1216:
1217: if (l_default_ro_item = 'Y') then
1218:

Line 1226: if (x_return_status <> FND_API.G_RET_STS_SUCCESS ) then

1222: x_wipEntityID => l_wip_entity_id,
1223: x_returnStatus => x_return_status,
1224: x_errorMsg => x_msg_data );
1225:
1226: if (x_return_status <> FND_API.G_RET_STS_SUCCESS ) then
1227: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_GEN_FAILURE');
1228: FND_MSG_PUB.ADD;
1229: RAISE FND_API.G_EXC_ERROR;
1230: end if;

Line 1229: RAISE FND_API.G_EXC_ERROR;

1225:
1226: if (x_return_status <> FND_API.G_RET_STS_SUCCESS ) then
1227: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_GEN_FAILURE');
1228: FND_MSG_PUB.ADD;
1229: RAISE FND_API.G_EXC_ERROR;
1230: end if;
1231:
1232: COMMIT;
1233:

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

1295: x_op_created => l_op_created,
1296: x_return_status => x_return_status,
1297: x_msg_count => x_msg_count,
1298: x_msg_data => x_msg_data);
1299: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1300: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_GEN_FAILURE');
1301: FND_MSG_PUB.ADD;
1302: RAISE FND_API.G_EXC_ERROR;
1303: END IF;

Line 1302: RAISE FND_API.G_EXC_ERROR;

1298: x_msg_data => x_msg_data);
1299: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1300: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_GEN_FAILURE');
1301: FND_MSG_PUB.ADD;
1302: RAISE FND_API.G_EXC_ERROR;
1303: END IF;
1304: end if;
1305: -- COMMIT;
1306: End if;

Line 1346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1342: -- add the error message to the message list and exit
1343:
1344: FND_MESSAGE.SET_NAME('CSD','CSD_CSDJSWIP_SUBMIT_FAILURE');
1345: FND_MSG_PUB.ADD;
1346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1347:
1348:
1349: IF ( l_stat_level >= l_debug_level ) then
1350: FND_LOG.STRING( l_stat_level,

Line 1355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1351: l_mod_name||'requestfail',
1352: 'Submit request failed');
1353: END IF;
1354:
1355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1356:
1357: ELSE
1358: --This commit is a must for the successful submission of the concurrent request above
1359: COMMIT;

Line 1375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1371: 'Leaving Private API submit_jobs');
1372: END IF;
1373:
1374: EXCEPTION
1375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1376: ROLLBACK ;
1377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1378: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1379: p_count => x_msg_count,

Line 1377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1373:
1374: EXCEPTION
1375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1376: ROLLBACK ;
1377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1378: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1379: p_count => x_msg_count,
1380: p_data => x_msg_data);
1381:

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

1374: EXCEPTION
1375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1376: ROLLBACK ;
1377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1378: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1379: p_count => x_msg_count,
1380: p_data => x_msg_data);
1381:
1382: IF ( FND_LOG.LEVEL_EXCEPTION >= l_debug_level ) then

Line 1389: WHEN FND_API.G_EXC_ERROR THEN

1385: 'G_EXC_UNEXPECTED_ERROR Exception');
1386: END IF;
1387:
1388:
1389: WHEN FND_API.G_EXC_ERROR THEN
1390: ROLLBACK ;
1391: x_return_status := FND_API.G_RET_STS_ERROR;
1392: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1393: p_count => x_msg_count,

Line 1391: x_return_status := FND_API.G_RET_STS_ERROR;

1387:
1388:
1389: WHEN FND_API.G_EXC_ERROR THEN
1390: ROLLBACK ;
1391: x_return_status := FND_API.G_RET_STS_ERROR;
1392: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1393: p_count => x_msg_count,
1394: p_data => x_msg_data);
1395:

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

1388:
1389: WHEN FND_API.G_EXC_ERROR THEN
1390: ROLLBACK ;
1391: x_return_status := FND_API.G_RET_STS_ERROR;
1392: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1393: p_count => x_msg_count,
1394: p_data => x_msg_data);
1395:
1396: IF ( FND_LOG.LEVEL_ERROR >= l_debug_level ) then

Line 1404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1400: END IF;
1401:
1402: WHEN OTHERS THEN
1403: ROLLBACK ;
1404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1405:
1406: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1407:
1408: -- Add Unexpected Error to Message List, here SQLERRM is used for

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

1411: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'CSD_WIP_JOB_PVT',
1412: p_procedure_name => 'submit_jobs');
1413: END IF;
1414:
1415: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1416: p_count => x_msg_count,
1417: p_data => x_msg_data);
1418:
1419: IF ( FND_LOG.LEVEL_EXCEPTION >= l_debug_level ) then

Line 1534: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

1530: l_mod_name||'requestfailure',
1531: 'WIP Mass Load Submit request failed' );
1532: END IF;
1533:
1534: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1535:
1536: ELSE
1537:
1538: COMMIT; --This commit is a must for the completion of the concurrent request submission

Line 1578: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

1574: l_mod_name||'waitfailure',
1575: 'Wait for request failed');
1576: END IF;
1577:
1578: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1579:
1580:
1581: ELSIF (l_dev_phase = 'COMPLETE' AND l_dev_status = 'NORMAL') THEN
1582:

Line 1610: p_commit => FND_API.G_TRUE,

1606: -- one repair order, then this is the case, that is, p_repair_line_id is null.
1607:
1608: CSD_UPDATE_PROGRAMS_PVT.WIP_UPDATE
1609: ( p_api_version => l_api_version,
1610: p_commit => FND_API.G_TRUE,
1611: p_init_msg_list => FND_API.G_TRUE,
1612: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1613: x_return_status => l_return_status,
1614: x_msg_count => l_msg_count,

Line 1611: p_init_msg_list => FND_API.G_TRUE,

1607:
1608: CSD_UPDATE_PROGRAMS_PVT.WIP_UPDATE
1609: ( p_api_version => l_api_version,
1610: p_commit => FND_API.G_TRUE,
1611: p_init_msg_list => FND_API.G_TRUE,
1612: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1613: x_return_status => l_return_status,
1614: x_msg_count => l_msg_count,
1615: x_msg_data => l_msg_data,

Line 1612: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1608: CSD_UPDATE_PROGRAMS_PVT.WIP_UPDATE
1609: ( p_api_version => l_api_version,
1610: p_commit => FND_API.G_TRUE,
1611: p_init_msg_list => FND_API.G_TRUE,
1612: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1613: x_return_status => l_return_status,
1614: x_msg_count => l_msg_count,
1615: x_msg_data => l_msg_data,
1616: p_upd_job_completion => 'N',

Line 1619: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1615: x_msg_data => l_msg_data,
1616: p_upd_job_completion => 'N',
1617: p_repair_line_id => p_repair_line_id );
1618:
1619: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1620:
1621: -- If return status is not success, write the error messages to
1622: -- the concurrent request log file and raise exception to exit
1623:

Line 1635: l_msg_data := fnd_msg_pub.get(l_msg_ctr, FND_API.G_FALSE );

1631: -- message list, retrieve the messages and write it to the log file
1632:
1633: FOR l_msg_ctr IN 1..l_msg_count
1634: LOOP
1635: l_msg_data := fnd_msg_pub.get(l_msg_ctr, FND_API.G_FALSE );
1636: fnd_file.put_line( fnd_file.log, l_msg_data);
1637: END LOOP;
1638:
1639: END IF;

Line 1647: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

1643: l_mod_name||'updatecallerror',
1644: 'CSD_UPDATE_PROGRAMS_PVT.WIP_UPDATE call returned error');
1645: END IF;
1646:
1647: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1648:
1649: ELSE
1650:
1651: -- If return status is success, return concurrent program success code

Line 1673: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

1669: l_mod_name||'completionfailure',
1670: 'WIP Mass Load did not Complete Successfully');
1671: END IF;
1672:
1673: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1674:
1675: END IF;
1676: END IF;
1677:

Line 1688: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1684:
1685: EXCEPTION
1686:
1687:
1688: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1689:
1690: -- write message to log file indicating the failure of the concurrent program,
1691: -- return error retcode
1692:

Line 1696: WHEN FND_API.G_EXC_ERROR THEN

1692:
1693: errbuf := FND_MESSAGE.GET_STRING('CSD','CSD_CSDJSWIP_FAILURE');
1694: retcode := l_error;
1695:
1696: WHEN FND_API.G_EXC_ERROR THEN
1697:
1698: -- write message to log file indicating the failure of the concurrent program,
1699: -- return error retcode
1700:

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

1711:
1712: -- Get the count of the Messages from the message list, if the count is 1
1713: -- get the message as well
1714:
1715: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1716: p_count => l_msg_count,
1717: p_data => l_msg_data);
1718:
1719: IF l_msg_count = 1 THEN

Line 1730: l_msg_data := fnd_msg_pub.get(l_msg_ctr, FND_API.G_FALSE );

1726: -- message list, retrieve the messages and write it to the log file
1727:
1728: FOR l_msg_ctr IN 1..l_msg_count
1729: LOOP
1730: l_msg_data := fnd_msg_pub.get(l_msg_ctr, FND_API.G_FALSE );
1731: fnd_file.put_line( fnd_file.log, l_msg_data);
1732: END LOOP;
1733:
1734: END IF;

Line 1834: IF NOT FND_API.Compatible_API_Call

1830:
1831: -- Standard Start of API savepoint
1832: SAVEPOINT CREATE_WIP_JOB_PVT;
1833: -- Standard call to check for call compatibility.
1834: IF NOT FND_API.Compatible_API_Call
1835: (lc_api_version_number,
1836: p_api_version_number,
1837: lc_api_name,
1838: G_PKG_NAME)

Line 1840: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1836: p_api_version_number,
1837: lc_api_name,
1838: G_PKG_NAME)
1839: THEN
1840: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1841: END IF;
1842:
1843: -- Initialize message list if p_init_msg_list is set to TRUE
1844: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 1844: IF FND_API.to_boolean(p_init_msg_list) THEN

1840: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1841: END IF;
1842:
1843: -- Initialize message list if p_init_msg_list is set to TRUE
1844: IF FND_API.to_boolean(p_init_msg_list) THEN
1845: FND_MSG_PUB.initialize;
1846: END IF;
1847:
1848: -- Initialize API return status to success

Line 1849: x_return_status:=FND_API.G_RET_STS_SUCCESS;

1845: FND_MSG_PUB.initialize;
1846: END IF;
1847:
1848: -- Initialize API return status to success
1849: x_return_status:=FND_API.G_RET_STS_SUCCESS;
1850:
1851: -- initialize the job header rec.
1852:
1853: l_job_header_rec.organization_id :=

Line 1860: RAISE FND_API.G_EXC_ERROR;

1856: IF l_job_header_rec.organization_id is NULL THEN
1857:
1858: FND_MESSAGE.SET_NAME('CSD','CSD_DEF_REP_INV_NULL');
1859: FND_MSG_PUB.ADD;
1860: RAISE FND_API.G_EXC_ERROR;
1861: END IF;
1862:
1863:
1864: l_job_prefix := fnd_profile.value('CSD_DEFAULT_JOB_PREFIX');

Line 1873: RAISE FND_API.G_EXC_ERROR;

1869: IF l_job_prefix IS NULL THEN
1870:
1871: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_PREFIX_NULL');
1872: FND_MSG_PUB.ADD;
1873: RAISE FND_API.G_EXC_ERROR;
1874: END IF;
1875:
1876: l_job_header_rec.class_code :=
1877: fnd_profile.value('CSD_DEF_WIP_ACCOUNTING_CLASS');

Line 1883: RAISE FND_API.G_EXC_ERROR;

1879: IF l_job_header_rec.class_code is NULL THEN
1880:
1881: FND_MESSAGE.SET_NAME('CSD','CSD_CLASS_CODE_NULL');
1882: FND_MSG_PUB.ADD;
1883: RAISE FND_API.G_EXC_ERROR;
1884: END IF;
1885:
1886: -- Assign the WIP Job Status lookup codes corresponding to Released -- and Unreleased Job status,
1887: -- to be passed for WIP Interface Table

Line 1988: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1984: x_return_status =>
1985: x_return_status );
1986:
1987:
1988: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1989: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1990: END IF;
1991:
1992:

Line 1989: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1985: x_return_status );
1986:
1987:
1988: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1989: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1990: END IF;
1991:
1992:
1993: -- CALL WIP API to process records in wip interface table,

Line 2013: If (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

2009:
2010:
2011:
2012:
2013: If (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
2014:
2015: ROLLBACK to CREATE_WIP_JOB_PVT ;
2016: RETURN;
2017:

Line 2034: p_init_msg_list => FND_API.G_FALSE,

2030:
2031:
2032: csd_to_form_repair_job_xref.validate_and_write(
2033: p_api_version_number => lc_api_version_number,
2034: p_init_msg_list => FND_API.G_FALSE,
2035: p_commit => FND_API.G_FALSE,
2036: p_validation_level => NULL,
2037: p_action_code => 0,
2038: px_repair_job_xref_id => l_repair_xref_id,

Line 2035: p_commit => FND_API.G_FALSE,

2031:
2032: csd_to_form_repair_job_xref.validate_and_write(
2033: p_api_version_number => lc_api_version_number,
2034: p_init_msg_list => FND_API.G_FALSE,
2035: p_commit => FND_API.G_FALSE,
2036: p_validation_level => NULL,
2037: p_action_code => 0,
2038: px_repair_job_xref_id => l_repair_xref_id,
2039: p_created_by => l_user_id,

Line 2078: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2074: x_msg_count => x_msg_count,
2075: x_msg_data => x_msg_data);
2076:
2077:
2078: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2079: ROLLBACK to CREATE_WIP_JOB_PVT ;
2080:
2081: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2082: FND_LOG.STRING( FND_LOG.LEVEL_ERROR,

Line 2102: p_init_msg_list => FND_API.G_FALSE,

2098:
2099:
2100: csd_to_form_repair_history.validate_and_write(
2101: p_api_version_number => lc_api_version_number,
2102: p_init_msg_list => FND_API.G_FALSE,
2103: p_commit => FND_API.G_FALSE,
2104: p_validation_level => NULL,
2105: p_action_code => 0,
2106: px_repair_history_id => l_rep_hist_id,

Line 2103: p_commit => FND_API.G_FALSE,

2099:
2100: csd_to_form_repair_history.validate_and_write(
2101: p_api_version_number => lc_api_version_number,
2102: p_init_msg_list => FND_API.G_FALSE,
2103: p_commit => FND_API.G_FALSE,
2104: p_validation_level => NULL,
2105: p_action_code => 0,
2106: px_repair_history_id => l_rep_hist_id,
2107: p_OBJECT_VERSION_NUMBER => NULL,

Line 2170: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2166: x_return_status => x_return_status,
2167: x_msg_count => x_msg_count,
2168: x_msg_data => x_msg_data);
2169:
2170: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2171: ROLLBACK to CREATE_WIP_JOB_PVT ;
2172:
2173: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2174: FND_LOG.STRING( FND_LOG.LEVEL_ERROR,

Line 2184: IF FND_API.to_Boolean( p_commit )

2180:
2181: END IF;
2182:
2183: -- Standard check for p_commit
2184: IF FND_API.to_Boolean( p_commit )
2185: THEN
2186: COMMIT WORK;
2187: END IF;
2188:

Line 2191: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2187: END IF;
2188:
2189:
2190: EXCEPTION
2191: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2192: ROLLBACK to CREATE_WIP_JOB_PVT ;
2193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2194:
2195: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 2193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2189:
2190: EXCEPTION
2191: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2192: ROLLBACK to CREATE_WIP_JOB_PVT ;
2193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2194:
2195: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2196: p_count => x_msg_count,
2197: p_data => x_msg_data);

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

2191: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2192: ROLLBACK to CREATE_WIP_JOB_PVT ;
2193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2194:
2195: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2196: p_count => x_msg_count,
2197: p_data => x_msg_data);
2198:
2199: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 2206: WHEN FND_API.G_EXC_ERROR THEN

2202: 'G_EXC_UNEXPECTED_ERROR Exception');
2203: END IF;
2204:
2205:
2206: WHEN FND_API.G_EXC_ERROR THEN
2207: ROLLBACK to CREATE_WIP_JOB_PVT ;
2208: x_return_status := FND_API.G_RET_STS_ERROR;
2209:
2210:

Line 2208: x_return_status := FND_API.G_RET_STS_ERROR;

2204:
2205:
2206: WHEN FND_API.G_EXC_ERROR THEN
2207: ROLLBACK to CREATE_WIP_JOB_PVT ;
2208: x_return_status := FND_API.G_RET_STS_ERROR;
2209:
2210:
2211: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2212: p_count => x_msg_count,

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

2207: ROLLBACK to CREATE_WIP_JOB_PVT ;
2208: x_return_status := FND_API.G_RET_STS_ERROR;
2209:
2210:
2211: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2212: p_count => x_msg_count,
2213: p_data => x_msg_data);
2214:
2215: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 2223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2219: END IF;
2220:
2221: WHEN OTHERS THEN
2222: ROLLBACK to CREATE_WIP_JOB_PVT ;
2223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2224:
2225: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2226:
2227: -- Add Unexpected Error to Message List, here SQLERRM is used for

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

2230: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
2231: p_procedure_name => lc_api_name );
2232: END IF;
2233:
2234: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2235: p_count => x_msg_count,
2236: p_data => x_msg_data);
2237:
2238: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 2280: IF FND_API.to_boolean(p_init_msg_list) THEN

2276: 'Entering Private API create_job_from_estimate');
2277: END IF;
2278:
2279: -- Initialize message list if p_init_msg_list is set to TRUE
2280: IF FND_API.to_boolean(p_init_msg_list) THEN
2281: FND_MSG_PUB.initialize;
2282: END IF;
2283:
2284: -- Initialize API return status to success

Line 2285: x_return_status:=FND_API.G_RET_STS_SUCCESS;

2281: FND_MSG_PUB.initialize;
2282: END IF;
2283:
2284: -- Initialize API return status to success
2285: x_return_status:=FND_API.G_RET_STS_SUCCESS;
2286:
2287: -- get the material transactions table type
2288:
2289: import_estms_to_wipjob(p_rep_line_id,p_wip_entity_id,x_mtl_txn_dtls_tab_type);

Line 2314: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2310: p_mtl_txn_dtls_tbl => x_mtl_txn_dtls_tab_type,
2311: x_op_created => x_op_created);
2312:
2313:
2314: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2315: RAISE fnd_api.g_exc_error;
2316: END IF;
2317: END IF;
2318: COMMIT WORK;

Line 2315: RAISE fnd_api.g_exc_error;

2311: x_op_created => x_op_created);
2312:
2313:
2314: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2315: RAISE fnd_api.g_exc_error;
2316: END IF;
2317: END IF;
2318: COMMIT WORK;
2319: EXCEPTION

Line 2320: WHEN FND_API.G_EXC_ERROR THEN

2316: END IF;
2317: END IF;
2318: COMMIT WORK;
2319: EXCEPTION
2320: WHEN FND_API.G_EXC_ERROR THEN
2321: x_return_status := fnd_api.G_RET_STS_ERROR;
2322: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2323: p_count => x_msg_count,
2324: p_data => x_msg_data );

Line 2321: x_return_status := fnd_api.G_RET_STS_ERROR;

2317: END IF;
2318: COMMIT WORK;
2319: EXCEPTION
2320: WHEN FND_API.G_EXC_ERROR THEN
2321: x_return_status := fnd_api.G_RET_STS_ERROR;
2322: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2323: p_count => x_msg_count,
2324: p_data => x_msg_data );
2325: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2322: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

2318: COMMIT WORK;
2319: EXCEPTION
2320: WHEN FND_API.G_EXC_ERROR THEN
2321: x_return_status := fnd_api.G_RET_STS_ERROR;
2322: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2323: p_count => x_msg_count,
2324: p_data => x_msg_data );
2325: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2325: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2321: x_return_status := fnd_api.G_RET_STS_ERROR;
2322: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2323: p_count => x_msg_count,
2324: p_data => x_msg_data );
2325: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2327: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2328: p_count => x_msg_count,
2329: p_data => x_msg_data );

Line 2326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2322: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2323: p_count => x_msg_count,
2324: p_data => x_msg_data );
2325: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2327: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2328: p_count => x_msg_count,
2329: p_data => x_msg_data );
2330: WHEN OTHERS THEN

Line 2327: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

2323: p_count => x_msg_count,
2324: p_data => x_msg_data );
2325: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2327: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2328: p_count => x_msg_count,
2329: p_data => x_msg_data );
2330: WHEN OTHERS THEN
2331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2327: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2328: p_count => x_msg_count,
2329: p_data => x_msg_data );
2330: WHEN OTHERS THEN
2331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2332: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2333: p_count => x_msg_count,
2334: p_data => x_msg_data );
2335: END matrl_reqmnt_from_estms;

Line 2332: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

2328: p_count => x_msg_count,
2329: p_data => x_msg_data );
2330: WHEN OTHERS THEN
2331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2332: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2333: p_count => x_msg_count,
2334: p_data => x_msg_data );
2335: END matrl_reqmnt_from_estms;
2336: