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

Line 18: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

14: -- Pre-reqs :
15: --
16: -- Standard IN Parameters :
17: -- p_api_version IN NUMBER Required
18: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
19: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
20: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
21: --
22: -- Standard OUT Parameters :

Line 19: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

15: --
16: -- Standard IN Parameters :
17: -- p_api_version IN NUMBER Required
18: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
19: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
20: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
21: --
22: -- Standard OUT Parameters :
23: -- x_return_status OUT VARCHAR2 Required

Line 20: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

16: -- Standard IN Parameters :
17: -- p_api_version IN NUMBER Required
18: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
19: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
20: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
21: --
22: -- Standard OUT Parameters :
23: -- x_return_status OUT VARCHAR2 Required
24: -- x_msg_count OUT NUMBER Required

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

33: --
34: -- End of Comments --
35: PROCEDURE PROCESS_RA_DATA (
36: p_api_version IN NUMBER,
37: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
38: p_commit IN VARCHAR2 := FND_API.G_FALSE,
39: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
40: p_module_type IN VARCHAR2,
41: x_return_status OUT NOCOPY VARCHAR2,

Line 38: p_commit IN VARCHAR2 := FND_API.G_FALSE,

34: -- End of Comments --
35: PROCEDURE PROCESS_RA_DATA (
36: p_api_version IN NUMBER,
37: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
38: p_commit IN VARCHAR2 := FND_API.G_FALSE,
39: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
40: p_module_type IN VARCHAR2,
41: x_return_status OUT NOCOPY VARCHAR2,
42: x_msg_count OUT NOCOPY NUMBER,

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

35: PROCEDURE PROCESS_RA_DATA (
36: p_api_version IN NUMBER,
37: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
38: p_commit IN VARCHAR2 := FND_API.G_FALSE,
39: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
40: p_module_type IN VARCHAR2,
41: x_return_status OUT NOCOPY VARCHAR2,
42: x_msg_count OUT NOCOPY NUMBER,
43: x_msg_data OUT NOCOPY VARCHAR2,

Line 381: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

377: -- Standard start of API savepoint
378: SAVEPOINT PROCESS_RA_DATA_SP;
379:
380: -- Standard call to check for call compatibility
381: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
383: END IF;
384:
385: -- Initialize message list if p_init_msg_list is set to TRUE

Line 382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

378: SAVEPOINT PROCESS_RA_DATA_SP;
379:
380: -- Standard call to check for call compatibility
381: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
383: END IF;
384:
385: -- Initialize message list if p_init_msg_list is set to TRUE
386: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 386: IF FND_API.To_Boolean(p_init_msg_list) THEN

382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
383: END IF;
384:
385: -- Initialize message list if p_init_msg_list is set to TRUE
386: IF FND_API.To_Boolean(p_init_msg_list) THEN
387: FND_MSG_PUB.Initialize;
388: END IF;
389:
390: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 390: x_return_status := FND_API.G_RET_STS_SUCCESS;

386: IF FND_API.To_Boolean(p_init_msg_list) THEN
387: FND_MSG_PUB.Initialize;
388: END IF;
389:
390: x_return_status := FND_API.G_RET_STS_SUCCESS;
391:
392: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
393: fnd_log.string(fnd_log.level_statement,l_full_name,'RA -- PKG -- PROCESS_RA_DATA -------BEGIN-----------');
394: fnd_log.string(fnd_log.level_statement,l_full_name,'RA -- PKG -- PROCESS_RA_DATA -------p_start_date-----------' || p_start_date);

Line 424: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

420: END IF;
421: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');
422: FND_MESSAGE.Set_Token('NAME','ANALYSER.PROCESS_DATA');
423: FND_MSG_PUB.ADD;
424: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
425: END IF;
426:
427: IF (p_concurrent_flag = 'Y') THEN
428: fnd_file.put_line(fnd_file.log, 'RA Analyser Process ---- Fetching Counter Details Data from Setup ----');

Line 609: p_init_msg_list => FND_API.G_FALSE,

605:
606: AHL_UA_FLIGHT_SCHEDULES_PUB.Get_Flight_Schedule_Details(
607: -- standard IN params
608: p_api_version => 1,
609: p_init_msg_list => FND_API.G_FALSE,
610: p_commit => FND_API.G_FALSE,
611: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
612: p_default => FND_API.G_FALSE,
613: p_module_type => NULL,

Line 610: p_commit => FND_API.G_FALSE,

606: AHL_UA_FLIGHT_SCHEDULES_PUB.Get_Flight_Schedule_Details(
607: -- standard IN params
608: p_api_version => 1,
609: p_init_msg_list => FND_API.G_FALSE,
610: p_commit => FND_API.G_FALSE,
611: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
612: p_default => FND_API.G_FALSE,
613: p_module_type => NULL,
614: -- standard OUT params

Line 611: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

607: -- standard IN params
608: p_api_version => 1,
609: p_init_msg_list => FND_API.G_FALSE,
610: p_commit => FND_API.G_FALSE,
611: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
612: p_default => FND_API.G_FALSE,
613: p_module_type => NULL,
614: -- standard OUT params
615: x_return_status => l_return_status,

Line 612: p_default => FND_API.G_FALSE,

608: p_api_version => 1,
609: p_init_msg_list => FND_API.G_FALSE,
610: p_commit => FND_API.G_FALSE,
611: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
612: p_default => FND_API.G_FALSE,
613: p_module_type => NULL,
614: -- standard OUT params
615: x_return_status => l_return_status,
616: x_msg_count => l_msg_count,

Line 622: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

618: -- procedure params
619: p_flight_search_rec => l_flight_search_rec_type,
620: x_flight_schedules_tbl => l_flight_schedules_tbl);
621:
622: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
623: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
624: fnd_log.string(fnd_log.level_statement,l_full_name,'Called API AHL_UA_FLIGHT_SCHEDULES_PUB.Get_Flight_Schedule_Details Errored');
625: END IF;
626: IF (p_concurrent_flag = 'Y') THEN

Line 629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

625: END IF;
626: IF (p_concurrent_flag = 'Y') THEN
627: fnd_file.put_line(fnd_file.log, 'RA Analyser Process ---- Error in getting Flight Scedule Details --');
628: END IF;
629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
630: END IF;
631:
632: IF l_flight_schedules_tbl.COUNT > 0 THEN
633: FOR f in l_flight_schedules_tbl.FIRST .. l_flight_schedules_tbl.LAST LOOP

Line 634: IF (AHL_UTIL_UC_PKG.IS_UNIT_QUARANTINED(l_flight_schedules_tbl(f).UNIT_CONFIG_HEADER_ID,NULL) = FND_API.G_FALSE) THEN

630: END IF;
631:
632: IF l_flight_schedules_tbl.COUNT > 0 THEN
633: FOR f in l_flight_schedules_tbl.FIRST .. l_flight_schedules_tbl.LAST LOOP
634: IF (AHL_UTIL_UC_PKG.IS_UNIT_QUARANTINED(l_flight_schedules_tbl(f).UNIT_CONFIG_HEADER_ID,NULL) = FND_API.G_FALSE) THEN
635: l_fs_unit_sch_id_tbl(l_fs_index) := l_flight_schedules_tbl(f).UNIT_SCHEDULE_ID;
636: l_fs_arr_org_id_tbl(l_fs_index) := l_flight_schedules_tbl(f).ARRIVAL_ORG_ID;
637: l_fs_uc_header_id_tbl(l_fs_index) := l_flight_schedules_tbl(f).UNIT_CONFIG_HEADER_ID;
638: l_fs_csi_instance_id_tbl(l_fs_index) := l_flight_schedules_tbl(f).CSI_INSTANCE_ID;

Line 714: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

710: END IF;
711: IF (p_concurrent_flag = 'Y') THEN
712: fnd_file.put_line(fnd_file.log, 'RA Analyser Process ---- Invalid UC Header Id - Data Corruption ----');
713: END IF;
714: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
715: WHEN OTHERS THEN
716: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
717: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- OTHERS EXEC BLOCK -- UC_HEADER_ID ----- '||l_fs_uc_header_id_tbl(i));
718: END IF;

Line 719: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

715: WHEN OTHERS THEN
716: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
717: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- OTHERS EXEC BLOCK -- UC_HEADER_ID ----- '||l_fs_uc_header_id_tbl(i));
718: END IF;
719: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
720: END;
721:
722: -- Fetch Unit Config Tree Node Details for the Unit under consideration in the Loop.
723: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

Line 828: p_init_msg_list => FND_API.G_FALSE,

824: AHL_UMP_PROCESSUNIT_PVT.Get_Forecasted_Counter_Values(
825: x_return_status => l_return_status,
826: x_msg_data => l_msg_data,
827: x_msg_count => l_msg_count,
828: p_init_msg_list => FND_API.G_FALSE,
829: p_csi_item_instance_id => l_dtls_subject_id_tbl(j),
830: p_forecasted_date => l_fs_arrival_date_tbl(i),
831: x_counter_values_tbl => l_ctr_values_tbl);
832:

Line 833: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

829: p_csi_item_instance_id => l_dtls_subject_id_tbl(j),
830: p_forecasted_date => l_fs_arrival_date_tbl(i),
831: x_counter_values_tbl => l_ctr_values_tbl);
832:
833: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
834: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
835: fnd_log.string(fnd_log.level_statement,l_full_name,'Called API AHL_UMP_PROCESSUNIT_PVT.Get_Forecasted_Counter_Values Errored');
836: END IF;
837: IF (p_concurrent_flag = 'Y') THEN

Line 840: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

836: END IF;
837: IF (p_concurrent_flag = 'Y') THEN
838: fnd_file.put_line(fnd_file.log, 'RA Analyser Process ---- Error in getting Forecasted Counter Value for Node in Context --');
839: END IF;
840: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
841: END IF;
842:
843: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
844: fnd_log.string(fnd_log.level_statement,l_full_name,'Called API AHL_UMP_PROCESSUNIT_PVT.Get_Forecasted_Counter_Values After');

Line 855: p_encoded => FND_API.G_FALSE,

851:
852: FOR msg IN 1..fnd_msg_pub.count_msg LOOP
853:
854: fnd_msg_pub.get(p_msg_index => msg,
855: p_encoded => FND_API.G_FALSE,
856: p_data => l_msg_data,
857: p_msg_index_out => l_msg_index_out);
858:
859: fnd_log.string(fnd_log.level_statement,l_full_name,'UMP Returned - '||l_msg_data);

Line 1098: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

1094: WHEN TOO_MANY_ROWS THEN
1095: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1096: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- TOO_MANY_ROWS EXEC BLOCK -M- ORG_ID ----- '||l_fs_arr_org_id_tbl(i));
1097: END IF;
1098: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1099: WHEN OTHERS THEN
1100: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1101: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- OTHERS EXEC BLOCK -M- ORG_ID ----- '||l_fs_arr_org_id_tbl(i));
1102: END IF;

Line 1103: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

1099: WHEN OTHERS THEN
1100: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1101: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- OTHERS EXEC BLOCK -M- ORG_ID ----- '||l_fs_arr_org_id_tbl(i));
1102: END IF;
1103: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1104: END;
1105:
1106: IF (p_concurrent_flag = 'Y') THEN
1107: fnd_file.put_line(fnd_file.log, 'RA Analyser Process ---- MTBF Defined - Fetching Forecast Designator - AFTER ');

Line 1412: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

1408: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1409: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- TOO_MANY_ROWS EXEC BLOCK -H- ORG_ID ----- '||l_fs_arr_org_id_tbl(i));
1410: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- TOO_MANY_ROWS EXEC BLOCK -H- l_prob_value ----- '||l_prob_value);
1411: END IF;
1412: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1413: WHEN OTHERS THEN
1414: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1415: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- OTHERS EXEC BLOCK -H- ORG_ID ----- '||l_fs_arr_org_id_tbl(i));
1416: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- OTHERS EXEC BLOCK -H- l_prob_value ----- '||l_prob_value);

Line 1418: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

1414: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1415: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- OTHERS EXEC BLOCK -H- ORG_ID ----- '||l_fs_arr_org_id_tbl(i));
1416: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- OTHERS EXEC BLOCK -H- l_prob_value ----- '||l_prob_value);
1417: END IF;
1418: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1419: END;
1420: ELSE
1421: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1422: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- l_prob_value -- for historical--'||l_prob_value);

Line 1562: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1558: MSC_ATP_GLOBAL.Extend_ATP(l_atp_rec, x_return_status);
1559:
1560: MSC_ATP_GLOBAL.GET_ATP_SESSION_ID(l_session_id,l_return_status);
1561:
1562: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1563: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1564: fnd_log.string(fnd_log.level_statement,l_full_name,'Called API MSC_ATP_GLOBAL.GET_SESSION_ID U Errored');
1565: END IF;
1566: IF (p_concurrent_flag = 'Y') THEN

Line 1569: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1565: END IF;
1566: IF (p_concurrent_flag = 'Y') THEN
1567: fnd_file.put_line(fnd_file.log, 'RA Analyser Process ---- Error in getting on Session Id --');
1568: END IF;
1569: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1570: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1571: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1572: fnd_log.string(fnd_log.level_statement,l_full_name,'Called API MSC_ATP_GLOBAL.GET_SESSION_ID E Errored');
1573: END IF;

Line 1570: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

1566: IF (p_concurrent_flag = 'Y') THEN
1567: fnd_file.put_line(fnd_file.log, 'RA Analyser Process ---- Error in getting on Session Id --');
1568: END IF;
1569: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1570: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1571: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1572: fnd_log.string(fnd_log.level_statement,l_full_name,'Called API MSC_ATP_GLOBAL.GET_SESSION_ID E Errored');
1573: END IF;
1574: IF (p_concurrent_flag = 'Y') THEN

Line 1577: RAISE FND_API.G_EXC_ERROR;

1573: END IF;
1574: IF (p_concurrent_flag = 'Y') THEN
1575: fnd_file.put_line(fnd_file.log, 'RA Analyser Process ---- Error in getting on Session Id');
1576: END IF;
1577: RAISE FND_API.G_EXC_ERROR;
1578: END IF;
1579:
1580: --Assign values to input record for ATP api.
1581: l_atp_rec.Inventory_Item_Id := Mrp_Atp_Pub.number_arr(l_dtls_inv_item_id_tbl(j));

Line 1615: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1611: l_msg_data,
1612: l_msg_count
1613: );
1614:
1615: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1616: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1617: fnd_log.string(fnd_log.level_statement,l_full_name,'Called API MRP_ATP_PUB.Call_ATP U Errored');
1618: END IF;
1619: IF (p_concurrent_flag = 'Y') THEN

Line 1622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1618: END IF;
1619: IF (p_concurrent_flag = 'Y') THEN
1620: fnd_file.put_line(fnd_file.log, 'RA Analyser Process ---- Error in getting on Hand Quantity --' || l_session_id);
1621: END IF;
1622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1623: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1624: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1625: fnd_log.string(fnd_log.level_statement,l_full_name,'Called API MRP_ATP_PUB.Call_ATP E Errored');
1626: END IF;

Line 1623: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

1619: IF (p_concurrent_flag = 'Y') THEN
1620: fnd_file.put_line(fnd_file.log, 'RA Analyser Process ---- Error in getting on Hand Quantity --' || l_session_id);
1621: END IF;
1622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1623: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1624: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1625: fnd_log.string(fnd_log.level_statement,l_full_name,'Called API MRP_ATP_PUB.Call_ATP E Errored');
1626: END IF;
1627: IF (p_concurrent_flag = 'Y') THEN

Line 1630: RAISE FND_API.G_EXC_ERROR;

1626: END IF;
1627: IF (p_concurrent_flag = 'Y') THEN
1628: fnd_file.put_line(fnd_file.log, 'RA Analyser Process ---- Error in getting on Hand Quantity --' || l_session_id);
1629: END IF;
1630: RAISE FND_API.G_EXC_ERROR;
1631: END IF;
1632:
1633: IF (p_concurrent_flag = 'Y') THEN
1634: fnd_file.put_line(fnd_file.log, ' - A - Calling ATP API -- ' || x_atp_rec.Requested_Date_Quantity(1));

Line 1650: AND NVL(TRUNC(OSPL.NEED_BY_DATE), FND_API.G_MISS_DATE) = l_fs_arrival_date_tbl(i);

1646: WHERE OSPL.OSP_ORDER_ID = OSP.OSP_ORDER_ID
1647: AND OSP.STATUS_CODE <> 'CLOSED'
1648: AND INVENTORY_ITEM_ID = l_dtls_inv_item_id_tbl(j)
1649: AND OSPL.INVENTORY_ORG_ID= l_fs_arr_org_id_tbl(i)
1650: AND NVL(TRUNC(OSPL.NEED_BY_DATE), FND_API.G_MISS_DATE) = l_fs_arrival_date_tbl(i);
1651:
1652: IF (p_concurrent_flag = 'Y') THEN
1653: fnd_file.put_line(fnd_file.log, ' - B - Deriving VWP Figure -- ');
1654: END IF;

Line 1677: AND nvl(CII.INVENTORY_REVISION,FND_API.G_MISS_CHAR) = nvl(l_dtls_inv_revision_tbl(j),FND_API.G_MISS_CHAR)

1673: FROM CSI_II_RELATIONSHIPS CIIR,
1674: CSI_ITEM_INSTANCES CII
1675: WHERE CII.INVENTORY_ITEM_ID = l_dtls_inv_item_id_tbl(j)
1676: AND CII.INV_MASTER_ORGANIZATION_ID = l_dtls_inv_master_org_id_tbl(j)
1677: AND nvl(CII.INVENTORY_REVISION,FND_API.G_MISS_CHAR) = nvl(l_dtls_inv_revision_tbl(j),FND_API.G_MISS_CHAR)
1678: AND CII.INSTANCE_ID = CIIR.SUBJECT_ID
1679: START WITH CIIR.OBJECT_ID IN (
1680: Select DISTINCT Visit.ITEM_INSTANCE_ID
1681: from AHL_VISITS_B Visit,

Line 1716: AND nvl(CII.INVENTORY_REVISION,FND_API.G_MISS_CHAR) = nvl(l_dtls_inv_revision_tbl(j),FND_API.G_MISS_CHAR)

1712: AND l_fs_arrival_date_tbl(i) between TRUNC(Visit.START_DATE_TIME) AND TRUNC(Visit.CLOSE_DATE_TIME)
1713: AND Visit.ITEM_INSTANCE_ID = CII.INSTANCE_ID
1714: AND CII.INVENTORY_ITEM_ID = l_dtls_inv_item_id_tbl(j)
1715: AND CII.INV_MASTER_ORGANIZATION_ID = l_dtls_inv_master_org_id_tbl(j)
1716: AND nvl(CII.INVENTORY_REVISION,FND_API.G_MISS_CHAR) = nvl(l_dtls_inv_revision_tbl(j),FND_API.G_MISS_CHAR)
1717:
1718: UNION ALL
1719:
1720: -- Total Quantity from Visit, which does not have a unit at the header level.

Line 1738: AND nvl(CII.INVENTORY_REVISION,FND_API.G_MISS_CHAR) = nvl(l_dtls_inv_revision_tbl(j),FND_API.G_MISS_CHAR)

1734: AND l_fs_arrival_date_tbl(i) between TRUNC(Visit.START_DATE_TIME) AND TRUNC(Visit.CLOSE_DATE_TIME)
1735: AND TASKS.INSTANCE_ID = CII.INSTANCE_ID
1736: AND CII.INVENTORY_ITEM_ID = l_dtls_inv_item_id_tbl(j)
1737: AND CII.INV_MASTER_ORGANIZATION_ID = l_dtls_inv_master_org_id_tbl(j)
1738: AND nvl(CII.INVENTORY_REVISION,FND_API.G_MISS_CHAR) = nvl(l_dtls_inv_revision_tbl(j),FND_API.G_MISS_CHAR)
1739:
1740: UNION ALL
1741:
1742: -- Total Quantity from Visit, which does not have a unit at the header level.

Line 1750: AND nvl(CII.INVENTORY_REVISION,FND_API.G_MISS_CHAR) = nvl(l_dtls_inv_revision_tbl(j),FND_API.G_MISS_CHAR)

1746: FROM CSI_II_RELATIONSHIPS CIIR,
1747: CSI_ITEM_INSTANCES CII
1748: WHERE CII.INVENTORY_ITEM_ID = l_dtls_inv_item_id_tbl(j)
1749: AND CII.INV_MASTER_ORGANIZATION_ID = l_dtls_inv_master_org_id_tbl(j)
1750: AND nvl(CII.INVENTORY_REVISION,FND_API.G_MISS_CHAR) = nvl(l_dtls_inv_revision_tbl(j),FND_API.G_MISS_CHAR)
1751: AND CII.INSTANCE_ID = CIIR.SUBJECT_ID
1752: START WITH CIIR.OBJECT_ID IN (
1753: Select CII.INSTANCE_ID AS ITEM_INSTANCE
1754: from AHL_VISIT_TASKS_B TASKS,

Line 1768: AND nvl(CII.INVENTORY_REVISION,FND_API.G_MISS_CHAR) = nvl(l_dtls_inv_revision_tbl(j),FND_API.G_MISS_CHAR)

1764: AND l_fs_arrival_date_tbl(i) between TRUNC(Visit.START_DATE_TIME) AND TRUNC(Visit.CLOSE_DATE_TIME)
1765: AND TASKS.INSTANCE_ID = CII.INSTANCE_ID
1766: AND CII.INVENTORY_ITEM_ID = l_dtls_inv_item_id_tbl(j)
1767: AND CII.INV_MASTER_ORGANIZATION_ID = l_dtls_inv_master_org_id_tbl(j)
1768: AND nvl(CII.INVENTORY_REVISION,FND_API.G_MISS_CHAR) = nvl(l_dtls_inv_revision_tbl(j),FND_API.G_MISS_CHAR)
1769: )
1770: AND CIIR.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
1771: AND TRUNC(NVL(CIIR.ACTIVE_START_DATE,SYSDATE)) <= TRUNC(SYSDATE)
1772: AND TRUNC(SYSDATE) < TRUNC(NVL(CIIR.ACTIVE_END_DATE,SYSDATE+1))

Line 2167: IF FND_API.To_Boolean (p_commit) THEN

2163: dbms_lob.close( l_fct_data_lob );
2164: dbms_lob.freeTemporary( l_fct_data_lob );
2165:
2166: -- Standard check for p_commit
2167: IF FND_API.To_Boolean (p_commit) THEN
2168: COMMIT;
2169: END IF;
2170:
2171: IF (p_concurrent_flag = 'Y') THEN

Line 2182: p_encoded => fnd_api.g_false);

2178: -- Standard call to get message count and if count is 1, get message
2179: FND_MSG_PUB.Count_And_Get
2180: ( p_count => x_msg_count,
2181: p_data => x_msg_data,
2182: p_encoded => fnd_api.g_false);
2183:
2184: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2185: fnd_log.string(fnd_log.level_procedure,L_FULL_NAME||'.end','Return Status = ' || x_return_status);
2186: END IF;

Line 2189: WHEN FND_API.G_EXC_ERROR THEN

2185: fnd_log.string(fnd_log.level_procedure,L_FULL_NAME||'.end','Return Status = ' || x_return_status);
2186: END IF;
2187:
2188: EXCEPTION
2189: WHEN FND_API.G_EXC_ERROR THEN
2190: x_return_status := FND_API.G_RET_STS_ERROR;
2191: Rollback to PROCESS_RA_DATA_SP;
2192: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2193: p_data => x_msg_data,

Line 2190: x_return_status := FND_API.G_RET_STS_ERROR;

2186: END IF;
2187:
2188: EXCEPTION
2189: WHEN FND_API.G_EXC_ERROR THEN
2190: x_return_status := FND_API.G_RET_STS_ERROR;
2191: Rollback to PROCESS_RA_DATA_SP;
2192: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2193: p_data => x_msg_data,
2194: p_encoded => fnd_api.g_false);

Line 2194: p_encoded => fnd_api.g_false);

2190: x_return_status := FND_API.G_RET_STS_ERROR;
2191: Rollback to PROCESS_RA_DATA_SP;
2192: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2193: p_data => x_msg_data,
2194: p_encoded => fnd_api.g_false);
2195: IF (p_concurrent_flag = 'Y') THEN
2196: fnd_file.put_line(fnd_file.log, 'RA Analyser Process Failed. Refer to the error message below.');
2197: log_error_messages;
2198: END IF;

Line 2200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2196: fnd_file.put_line(fnd_file.log, 'RA Analyser Process Failed. Refer to the error message below.');
2197: log_error_messages;
2198: END IF;
2199:
2200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2202: Rollback to PROCESS_RA_DATA_SP;
2203: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2204: p_data => x_msg_data,

Line 2201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2197: log_error_messages;
2198: END IF;
2199:
2200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2202: Rollback to PROCESS_RA_DATA_SP;
2203: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2204: p_data => x_msg_data,
2205: p_encoded => fnd_api.g_false);

Line 2205: p_encoded => fnd_api.g_false);

2201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2202: Rollback to PROCESS_RA_DATA_SP;
2203: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2204: p_data => x_msg_data,
2205: p_encoded => fnd_api.g_false);
2206: IF (p_concurrent_flag = 'Y') THEN
2207: fnd_file.put_line(fnd_file.log, 'RA Analyser Process Failed. Refer to the error message below.');
2208: log_error_messages;
2209: END IF;

Line 2212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2208: log_error_messages;
2209: END IF;
2210:
2211: WHEN OTHERS THEN
2212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2213: Rollback to PROCESS_RA_DATA_SP;
2214: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2215: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
2216: p_procedure_name => 'PROCESS_RA_DATA',

Line 2221: p_encoded => fnd_api.g_false);

2217: p_error_text => SUBSTR(SQLERRM,1,240));
2218: END IF;
2219: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2220: p_data => x_msg_data,
2221: p_encoded => fnd_api.g_false);
2222: IF (p_concurrent_flag = 'Y') THEN
2223: fnd_file.put_line(fnd_file.log, 'RA Analyser Process Failed. Refer to the error message below.');
2224: log_error_messages;
2225: END IF;

Line 2255: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)

2251: -- Initialize error message stack by default
2252: FND_MSG_PUB.Initialize;
2253:
2254: -- Standard call to check for call compatibility
2255: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
2256: THEN
2257: retcode := 2;
2258: errbuf := FND_MSG_PUB.Get;
2259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2255: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
2256: THEN
2257: retcode := 2;
2258: errbuf := FND_MSG_PUB.Get;
2259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2260: END IF;
2261:
2262: PROCESS_RA_DATA (
2263: p_api_version => 1,

Line 2264: p_init_msg_list => FND_API.G_TRUE,

2260: END IF;
2261:
2262: PROCESS_RA_DATA (
2263: p_api_version => 1,
2264: p_init_msg_list => FND_API.G_TRUE,
2265: p_commit => FND_API.G_TRUE,
2266: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2267: p_module_type => NULL,
2268: x_return_status => l_return_status,

Line 2265: p_commit => FND_API.G_TRUE,

2261:
2262: PROCESS_RA_DATA (
2263: p_api_version => 1,
2264: p_init_msg_list => FND_API.G_TRUE,
2265: p_commit => FND_API.G_TRUE,
2266: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2267: p_module_type => NULL,
2268: x_return_status => l_return_status,
2269: x_msg_count => l_msg_count,

Line 2266: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

2262: PROCESS_RA_DATA (
2263: p_api_version => 1,
2264: p_init_msg_list => FND_API.G_TRUE,
2265: p_commit => FND_API.G_TRUE,
2266: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2267: p_module_type => NULL,
2268: x_return_status => l_return_status,
2269: x_msg_count => l_msg_count,
2270: x_msg_data => errbuf,

Line 2289: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2285: END LOOP;
2286:
2287: l_msg_count := FND_MSG_PUB.Count_Msg;
2288:
2289: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2290: retcode := 2; -- error based only on return status
2291: fnd_file.put(fnd_file.log, ' retcode - '||retcode);
2292: fnd_file.put(fnd_file.log, ' l_return_status - '||l_return_status);
2293: ELSIF (l_msg_count > 0 AND l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

Line 2293: ELSIF (l_msg_count > 0 AND l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

2289: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2290: retcode := 2; -- error based only on return status
2291: fnd_file.put(fnd_file.log, ' retcode - '||retcode);
2292: fnd_file.put(fnd_file.log, ' l_return_status - '||l_return_status);
2293: ELSIF (l_msg_count > 0 AND l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2294: retcode := 1; -- warning based on return status + msg count
2295: fnd_file.put(fnd_file.log, ' retcode - '||retcode);
2296: fnd_file.put(fnd_file.log, ' l_msg_count - '||l_msg_count);
2297: ELSE

Line 2329: p_encoded => FND_API.G_FALSE,

2325:
2326: FOR i IN 1..l_msg_count LOOP
2327: FND_MSG_PUB.get (
2328: p_msg_index => i,
2329: p_encoded => FND_API.G_FALSE,
2330: p_data => l_msg_data,
2331: p_msg_index_out => l_msg_index_out );
2332:
2333: fnd_file.put_line(FND_FILE.LOG, 'Err message-'||l_msg_index_out||':' || l_msg_data);