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

Line 65: -- p_init_msg_list FND_API.G_FALSE not to reset list

61:
62: --========================================================================
63: -- PROCEDURE : Create_Movement_Statistics PUBLIC
64: -- PARAMETERS: p_api_version_number known api version
65: -- p_init_msg_list FND_API.G_FALSE not to reset list
66: -- p_transaction_type transaction type(inv,rec.,PO etc)
67: -- x_return_status return status
68: -- x_msg_count number of messages in the list
69: -- x_msg_data message text

Line 109: x_return_status := FND_API.G_RET_STS_SUCCESS;

105: ,'enter procedure'
106: );
107: END IF;
108:
109: x_return_status := FND_API.G_RET_STS_SUCCESS;
110: l_return_status1 := 'S';
111: l_return_status2 := 'S';
112:
113: g_movement_id := NULL;

Line 117: IF NOT FND_API.Compatible_API_Call

113: g_movement_id := NULL;
114: g_parent_movement_id := NULL;
115:
116: -- Standard call to check for call compatibility
117: IF NOT FND_API.Compatible_API_Call
118: ( l_api_version_number
119: , p_api_version_number
120: , l_api_name
121: , G_PKG_NAME

Line 124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

120: , l_api_name
121: , G_PKG_NAME
122: )
123: THEN
124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
125: END IF;
126:
127: l_movement_transaction := x_movement_transaction;
128: l_insert_flag := 'Y';

Line 139: , p_init_msg_list => FND_API.G_FALSE

135: IF l_movement_transaction.movement_status IN ('O','V','P')
136: THEN
137: INV_MGD_MVT_DEF_ATTR.Default_Attr
138: ( p_api_version_number => 1.0
139: , p_init_msg_list => FND_API.G_FALSE
140: , p_movement_transaction => l_movement_transaction
141: , x_transaction_nature => l_movement_transaction.transaction_nature
142: , x_delivery_terms => l_movement_transaction.delivery_terms
143: , x_area => l_movement_transaction.area

Line 163: , p_init_msg_list => FND_API.G_FALSE

159: );
160:
161: INV_MGD_MVT_DEF_ATTR.Default_Value
162: ( p_api_version_number => 1.0
163: , p_init_msg_list => FND_API.G_FALSE
164: , p_movement_transaction => l_movement_transaction
165: , x_document_unit_price => l_movement_transaction.document_unit_price
166: , x_document_line_ext_value => l_movement_transaction.document_line_ext_value
167: , x_movement_amount => l_movement_transaction.movement_amount

Line 527: x_return_status := FND_API.G_RET_STS_ERROR;

523: EXCEPTION
524:
525: WHEN NO_DATA_FOUND THEN
526: g_movement_id := null;
527: x_return_status := FND_API.G_RET_STS_ERROR;
528: FND_MESSAGE.Set_Name('INV', 'INV_MGD_UPDATE_EXC');
529: FND_MSG_PUB.Add;
530: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
531: THEN

Line 540: WHEN FND_API.G_EXC_ERROR THEN

536: END IF;
537: RAISE g_no_data_transaction_exc;
538:
539:
540: WHEN FND_API.G_EXC_ERROR THEN
541: g_movement_id := null;
542: x_return_status := FND_API.G_RET_STS_ERROR;
543: -- Get message count and data
544: FND_MSG_PUB.Count_And_Get

Line 542: x_return_status := FND_API.G_RET_STS_ERROR;

538:
539:
540: WHEN FND_API.G_EXC_ERROR THEN
541: g_movement_id := null;
542: x_return_status := FND_API.G_RET_STS_ERROR;
543: -- Get message count and data
544: FND_MSG_PUB.Count_And_Get
545: ( p_count => x_msg_count
546: , p_data => x_msg_data

Line 549: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

545: ( p_count => x_msg_count
546: , p_data => x_msg_data
547: );
548:
549: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
550: g_movement_id := null;
551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
552: -- Get message count and data
553: FND_MSG_PUB.Count_And_Get

Line 551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

547: );
548:
549: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
550: g_movement_id := null;
551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
552: -- Get message count and data
553: FND_MSG_PUB.Count_And_Get
554: ( p_count => x_msg_count
555: , p_data => x_msg_data

Line 880: x_return_status := FND_API.G_RET_STS_SUCCESS;

876: ,'enter procedure'
877: );
878: END IF;
879: l_movement_transaction := p_movement_statistics;
880: x_return_status := FND_API.G_RET_STS_SUCCESS;
881: /*bug #7499719 Call Out Program was not called for Update Movement Statistic*/
882: IF l_movement_transaction.movement_status IN ('O','V','P')
883: THEN
884: INV_MGD_MVT_DEF_ATTR.Default_Attr

Line 886: , p_init_msg_list => FND_API.G_FALSE

882: IF l_movement_transaction.movement_status IN ('O','V','P')
883: THEN
884: INV_MGD_MVT_DEF_ATTR.Default_Attr
885: ( p_api_version_number => 1.0
886: , p_init_msg_list => FND_API.G_FALSE
887: , p_movement_transaction => l_movement_transaction
888: , x_transaction_nature => l_movement_transaction.transaction_nature
889: , x_delivery_terms => l_movement_transaction.delivery_terms
890: , x_area => l_movement_transaction.area

Line 910: , p_init_msg_list => FND_API.G_FALSE

906: );
907:
908: INV_MGD_MVT_DEF_ATTR.Default_Value
909: ( p_api_version_number => 1.0
910: , p_init_msg_list => FND_API.G_FALSE
911: , p_movement_transaction => l_movement_transaction
912: , x_document_unit_price => l_movement_transaction.document_unit_price
913: , x_document_line_ext_value => l_movement_transaction.document_line_ext_value
914: , x_movement_amount => l_movement_transaction.movement_amount

Line 1118: WHEN FND_API.G_EXC_ERROR THEN

1114: );
1115: END IF;
1116:
1117: EXCEPTION
1118: WHEN FND_API.G_EXC_ERROR THEN
1119: x_return_status := FND_API.G_RET_STS_ERROR;
1120: -- Get message count and data
1121: FND_MSG_PUB.Count_And_Get
1122: ( p_count => x_msg_count

Line 1119: x_return_status := FND_API.G_RET_STS_ERROR;

1115: END IF;
1116:
1117: EXCEPTION
1118: WHEN FND_API.G_EXC_ERROR THEN
1119: x_return_status := FND_API.G_RET_STS_ERROR;
1120: -- Get message count and data
1121: FND_MSG_PUB.Count_And_Get
1122: ( p_count => x_msg_count
1123: , p_data => x_msg_data

Line 1126: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1122: ( p_count => x_msg_count
1123: , p_data => x_msg_data
1124: );
1125:
1126: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1128: -- Get message count and data
1129: FND_MSG_PUB.Count_And_Get
1130: ( p_count => x_msg_count

Line 1127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1123: , p_data => x_msg_data
1124: );
1125:
1126: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1128: -- Get message count and data
1129: FND_MSG_PUB.Count_And_Get
1130: ( p_count => x_msg_count
1131: , p_data => x_msg_data

Line 1135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1131: , p_data => x_msg_data
1132: );
1133:
1134: WHEN OTHERS THEN
1135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1136: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1137: THEN
1138: FND_MSG_PUB.Add_Exc_Msg
1139: ( G_PKG_NAME

Line 1268: --IF FND_API.to_Boolean(p_init_msg_list)

1264: );
1265: END IF;
1266:
1267: --Initiliaze the Message Stack IF Required
1268: --IF FND_API.to_Boolean(p_init_msg_list)
1269: --THEN
1270: FND_MSG_PUB.initialize;
1271: --END IF;
1272:

Line 1273: x_return_status := FND_API.G_RET_STS_SUCCESS;

1269: --THEN
1270: FND_MSG_PUB.initialize;
1271: --END IF;
1272:
1273: x_return_status := FND_API.G_RET_STS_SUCCESS;
1274: validate_rule_flag := 'Y';
1275:
1276: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1277: , p_data => x_msg_data );

Line 1365: , p_init_msg_list => FND_API.G_FALSE

1361: (p_movement_transaction => l_new_movement_transaction);
1362:
1363: INV_MGD_MVT_STATS_PVT.Create_Movement_Statistics
1364: ( p_api_version_number => 1.0
1365: , p_init_msg_list => FND_API.G_FALSE
1366: , x_movement_transaction => l_new_movement_transaction
1367: , x_msg_count => x_msg_count
1368: , x_msg_data => x_msg_data
1369: , x_return_status => x_return_status

Line 1454: IF x_return_status = FND_API.G_RET_STS_SUCCESS

1450: , x_msg_count => x_msg_count
1451: , x_msg_data => x_msg_data
1452: );
1453:
1454: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1455: THEN
1456: validate_rule_flag := 'Y';
1457: ELSE
1458: validate_rule_flag := 'N';

Line 1479: IF l_return_status=FND_API.G_RET_STS_ERROR

1475: );
1476:
1477: x_updated_flag := l_updated_flag;
1478:
1479: IF l_return_status=FND_API.G_RET_STS_ERROR
1480: AND l_record_status='N'
1481: THEN
1482: -- nothing corrected although we found error
1483: -- the API will return FND_API.G_RET_STS_ERROR

Line 1483: -- the API will return FND_API.G_RET_STS_ERROR

1479: IF l_return_status=FND_API.G_RET_STS_ERROR
1480: AND l_record_status='N'
1481: THEN
1482: -- nothing corrected although we found error
1483: -- the API will return FND_API.G_RET_STS_ERROR
1484: l_corrected := 'N';
1485: ELSE
1486: -- see state diagram for reason of setting status to V
1487: -- Added check for rule based validation if Y only then set status to V

Line 1562: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1558: END IF;
1559: --l_orig_mvmt_transaction.movement_status:='V';
1560: ELSE
1561: -- the invoice is not found, raise unexpected error exception
1562: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1563: END IF;
1564: END IF;
1565: END IF;
1566:

Line 1622: X_return_status:=FND_API.G_RET_STS_ERROR;

1618: IF l_corrected='N'
1619: THEN
1620: --ssui: bug 1072889, keep status as OPEN if exception but not corrected
1621: l_orig_mvmt_transaction.movement_status:='O';
1622: X_return_status:=FND_API.G_RET_STS_ERROR;
1623: END IF;
1624:
1625: -- set return exception list
1626: x_excp_list := g_final_excp_list;

Line 1639: WHEN FND_API.G_EXC_ERROR THEN

1635: );
1636: END IF;
1637:
1638: EXCEPTION
1639: WHEN FND_API.G_EXC_ERROR THEN
1640: x_return_status := FND_API.G_RET_STS_ERROR;
1641: -- Get message count and data
1642: FND_MSG_PUB.Count_And_Get
1643: ( p_count => x_msg_count

Line 1640: x_return_status := FND_API.G_RET_STS_ERROR;

1636: END IF;
1637:
1638: EXCEPTION
1639: WHEN FND_API.G_EXC_ERROR THEN
1640: x_return_status := FND_API.G_RET_STS_ERROR;
1641: -- Get message count and data
1642: FND_MSG_PUB.Count_And_Get
1643: ( p_count => x_msg_count
1644: , p_data => x_msg_data

Line 1647: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1643: ( p_count => x_msg_count
1644: , p_data => x_msg_data
1645: );
1646:
1647: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1648: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1649: -- Get message count and data
1650: FND_MSG_PUB.Count_And_Get
1651: ( p_count => x_msg_count

Line 1648: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1644: , p_data => x_msg_data
1645: );
1646:
1647: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1648: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1649: -- Get message count and data
1650: FND_MSG_PUB.Count_And_Get
1651: ( p_count => x_msg_count
1652: , p_data => x_msg_data

Line 1656: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1652: , p_data => x_msg_data
1653: );
1654:
1655: WHEN OTHERS THEN
1656: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1657: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1658: THEN
1659: FND_MSG_PUB.Add_Exc_Msg
1660: ( G_PKG_NAME

Line 1715: x_return_status := FND_API.G_RET_STS_SUCCESS;

1711: -- Copy input transaction record to local record for processing
1712: l_orig_mvmt_transaction := x_movement_statistics;
1713:
1714: -- Init x_return_status and x_record_status
1715: x_return_status := FND_API.G_RET_STS_SUCCESS;
1716: -- x_record_status set to Y for correct record
1717: -- whenever record missing or incorrect then change the status to N
1718: x_record_status := 'Y';
1719: x_updated_flag := 'N';

Line 1743: x_return_status := FND_API.G_RET_STS_ERROR;

1739: , p_message_cd => 2
1740: );
1741: -- 'INCORRECT' value for delivery_terms, set return status to error to
1742: -- indicate validate found error
1743: x_return_status := FND_API.G_RET_STS_ERROR;
1744: -- indicate incorrect record
1745: x_record_status := 'N';
1746: END;
1747: END IF;

Line 1765: x_return_status := FND_API.G_RET_STS_ERROR;

1761: ,p_message_cd => 1
1762: );
1763:
1764: -- 'MISSING' value, so set return status to error
1765: x_return_status := FND_API.G_RET_STS_ERROR;
1766:
1767: */
1768:
1769: l_orig_mvmt_transaction.category_id

Line 1794: x_return_status := FND_API.G_RET_STS_ERROR;

1790: ,p_message_cd => 1
1791: );
1792:
1793: -- 'MISSING' value, so set return status to error
1794: x_return_status := FND_API.G_RET_STS_ERROR;
1795:
1796: END IF;
1797: END IF;
1798:

Line 1810: x_return_status := FND_API.G_RET_STS_ERROR;

1806: /* create_table_data(p_col_name => 'UNIT_WEIGHT'
1807: ,p_message_cd => 1
1808: );
1809: -- 'MISSING' value, so set return status to error
1810: x_return_status := FND_API.G_RET_STS_ERROR;
1811: */
1812: l_orig_mvmt_transaction.unit_weight :=
1813: INV_MGD_MVT_UTILS_PKG.Calc_Unit_Weight
1814: ( p_inventory_item_id => l_orig_mvmt_transaction.inventory_item_id

Line 1852: x_return_status := FND_API.G_RET_STS_ERROR;

1848: create_table_data(p_col_name => 'UNIT_WEIGHT'
1849: ,p_message_cd => 1
1850: );
1851: -- 'MISSING' value, so set return status to error
1852: x_return_status := FND_API.G_RET_STS_ERROR;
1853:
1854: END IF;
1855: END IF;
1856:

Line 1870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1866:
1867: EXCEPTION
1868:
1869: WHEN OTHERS THEN
1870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1871: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1872: THEN
1873: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Validate_Record');
1874: END IF;

Line 1930: x_return_status := FND_API.G_RET_STS_SUCCESS;

1926: IS
1927:
1928: BEGIN
1929:
1930: x_return_status := FND_API.G_RET_STS_SUCCESS;
1931:
1932: DELETE FROM MTL_MOVEMENT_STATISTICS
1933: WHERE movement_id = p_movement_transaction.movement_id
1934: AND movement_status in ('O','V')

Line 1940: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1936:
1937: EXCEPTION
1938:
1939: WHEN NO_DATA_FOUND THEN
1940: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1941:
1942: WHEN OTHERS THEN
1943: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1944:

Line 1943: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1939: WHEN NO_DATA_FOUND THEN
1940: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1941:
1942: WHEN OTHERS THEN
1943: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1944:
1945: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1946: THEN
1947: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Delete_Movement_Statistics');

Line 1987: x_return_status := FND_API.G_RET_STS_SUCCESS;

1983: );
1984: END IF;
1985:
1986: ---- Initialize x_return_status
1987: x_return_status := FND_API.G_RET_STS_SUCCESS;
1988:
1989: l_mvt_transaction_rec:=p_mvt_transaction_rec;
1990:
1991: ----check if the value matches any of the value in the lookup table

Line 2084: x_return_status := FND_API.G_RET_STS_ERROR;

2080: --Invalid Value for attribute field
2081: create_table_data(p_col_name => p_attribute_code
2082: ,p_message_cd => 1
2083: );
2084: x_return_status := FND_API.G_RET_STS_ERROR;
2085:
2086: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2087: THEN
2088: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

Line 2121: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2117: END IF;
2118:
2119: EXCEPTION
2120: WHEN OTHERS THEN
2121: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2122: ---x_movement_transaction := p_mvt_transaction_rec;
2123: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2124: THEN
2125: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Partner_vat_number');

Line 2194: x_return_status := FND_API.G_RET_STS_SUCCESS;

2190: -- Copy input transaction record to local record for processing
2191: l_orig_mvmt_transaction := x_movement_transaction;
2192:
2193: -- Init x_return_status
2194: x_return_status := FND_API.G_RET_STS_SUCCESS;
2195:
2196: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2197: THEN
2198: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

Line 2314: x_return_status := FND_API.G_RET_STS_ERROR;

2310: create_table_data(p_col_name => Rules_rec.attribute_code
2311: ,p_message_cd => 2
2312: );
2313:
2314: x_return_status := FND_API.G_RET_STS_ERROR;
2315:
2316: END IF;
2317: END IF;
2318: ELSE

Line 2362: x_return_status := FND_API.G_RET_STS_ERROR;

2358: WHEN NO_DATA_FOUND THEN
2359: --Invalid Value for attribute field
2360: create_table_data(p_col_name => Rules_rec.attribute_code
2361: ,p_message_cd => 2);
2362: x_return_status := FND_API.G_RET_STS_ERROR;
2363: END;
2364: END IF;
2365:
2366: END IF; --Rules_rec.attribute_lookup_type

Line 2423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2419: END IF;
2420:
2421: EXCEPTION
2422: WHEN OTHERS THEN
2423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2424: x_movement_transaction := l_orig_mvmt_transaction;
2425: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2426: THEN
2427: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Validate_Rules');