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 183: , p_init_msg_list => FND_API.G_FALSE

179: );
180:
181: INV_MGD_MVT_DEF_ATTR.Default_Value
182: ( p_api_version_number => 1.0
183: , p_init_msg_list => FND_API.G_FALSE
184: , p_movement_transaction => l_movement_transaction
185: , x_document_unit_price => l_movement_transaction.document_unit_price
186: , x_document_line_ext_value => l_movement_transaction.document_line_ext_value
187: , x_movement_amount => l_movement_transaction.movement_amount

Line 547: x_return_status := FND_API.G_RET_STS_ERROR;

543: EXCEPTION
544:
545: WHEN NO_DATA_FOUND THEN
546: g_movement_id := null;
547: x_return_status := FND_API.G_RET_STS_ERROR;
548: FND_MESSAGE.Set_Name('INV', 'INV_MGD_UPDATE_EXC');
549: FND_MSG_PUB.Add;
550: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
551: THEN

Line 560: WHEN FND_API.G_EXC_ERROR THEN

556: END IF;
557: RAISE g_no_data_transaction_exc;
558:
559:
560: WHEN FND_API.G_EXC_ERROR THEN
561: g_movement_id := null;
562: x_return_status := FND_API.G_RET_STS_ERROR;
563: -- Get message count and data
564: FND_MSG_PUB.Count_And_Get

Line 562: x_return_status := FND_API.G_RET_STS_ERROR;

558:
559:
560: WHEN FND_API.G_EXC_ERROR THEN
561: g_movement_id := null;
562: x_return_status := FND_API.G_RET_STS_ERROR;
563: -- Get message count and data
564: FND_MSG_PUB.Count_And_Get
565: ( p_count => x_msg_count
566: , p_data => x_msg_data

Line 569: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

565: ( p_count => x_msg_count
566: , p_data => x_msg_data
567: );
568:
569: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
570: g_movement_id := null;
571: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
572: -- Get message count and data
573: FND_MSG_PUB.Count_And_Get

Line 571: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

567: );
568:
569: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
570: g_movement_id := null;
571: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
572: -- Get message count and data
573: FND_MSG_PUB.Count_And_Get
574: ( p_count => x_msg_count
575: , p_data => x_msg_data

Line 900: x_return_status := FND_API.G_RET_STS_SUCCESS;

896: ,'enter procedure'
897: );
898: END IF;
899: l_movement_transaction := p_movement_statistics;
900: x_return_status := FND_API.G_RET_STS_SUCCESS;
901: /*bug #7499719 Call Out Program was not called for Update Movement Statistic*/
902: IF l_movement_transaction.movement_status IN ('O','V','P')
903: THEN
904: INV_MGD_MVT_DEF_ATTR.Default_Attr

Line 906: , p_init_msg_list => FND_API.G_FALSE

902: IF l_movement_transaction.movement_status IN ('O','V','P')
903: THEN
904: INV_MGD_MVT_DEF_ATTR.Default_Attr
905: ( p_api_version_number => 1.0
906: , p_init_msg_list => FND_API.G_FALSE
907: , p_movement_transaction => l_movement_transaction
908: , x_transaction_nature => l_movement_transaction.transaction_nature
909: , x_delivery_terms => l_movement_transaction.delivery_terms
910: , x_area => l_movement_transaction.area

Line 950: , p_init_msg_list => FND_API.G_FALSE

946: );
947:
948: INV_MGD_MVT_DEF_ATTR.Default_Value
949: ( p_api_version_number => 1.0
950: , p_init_msg_list => FND_API.G_FALSE
951: , p_movement_transaction => l_movement_transaction
952: , x_document_unit_price => l_movement_transaction.document_unit_price
953: , x_document_line_ext_value => l_movement_transaction.document_line_ext_value
954: , x_movement_amount => l_movement_transaction.movement_amount

Line 1158: WHEN FND_API.G_EXC_ERROR THEN

1154: );
1155: END IF;
1156:
1157: EXCEPTION
1158: WHEN FND_API.G_EXC_ERROR THEN
1159: x_return_status := FND_API.G_RET_STS_ERROR;
1160: -- Get message count and data
1161: FND_MSG_PUB.Count_And_Get
1162: ( p_count => x_msg_count

Line 1159: x_return_status := FND_API.G_RET_STS_ERROR;

1155: END IF;
1156:
1157: EXCEPTION
1158: WHEN FND_API.G_EXC_ERROR THEN
1159: x_return_status := FND_API.G_RET_STS_ERROR;
1160: -- Get message count and data
1161: FND_MSG_PUB.Count_And_Get
1162: ( p_count => x_msg_count
1163: , p_data => x_msg_data

Line 1166: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1162: ( p_count => x_msg_count
1163: , p_data => x_msg_data
1164: );
1165:
1166: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1167: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1168: -- Get message count and data
1169: FND_MSG_PUB.Count_And_Get
1170: ( p_count => x_msg_count

Line 1167: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1163: , p_data => x_msg_data
1164: );
1165:
1166: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1167: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1168: -- Get message count and data
1169: FND_MSG_PUB.Count_And_Get
1170: ( p_count => x_msg_count
1171: , p_data => x_msg_data

Line 1175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1171: , p_data => x_msg_data
1172: );
1173:
1174: WHEN OTHERS THEN
1175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1176: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1177: THEN
1178: FND_MSG_PUB.Add_Exc_Msg
1179: ( G_PKG_NAME

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

1304: );
1305: END IF;
1306:
1307: --Initiliaze the Message Stack IF Required
1308: --IF FND_API.to_Boolean(p_init_msg_list)
1309: --THEN
1310: FND_MSG_PUB.initialize;
1311: --END IF;
1312:

Line 1313: x_return_status := FND_API.G_RET_STS_SUCCESS;

1309: --THEN
1310: FND_MSG_PUB.initialize;
1311: --END IF;
1312:
1313: x_return_status := FND_API.G_RET_STS_SUCCESS;
1314: validate_rule_flag := 'Y';
1315:
1316: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1317: , p_data => x_msg_data );

Line 1405: , p_init_msg_list => FND_API.G_FALSE

1401: (p_movement_transaction => l_new_movement_transaction);
1402:
1403: INV_MGD_MVT_STATS_PVT.Create_Movement_Statistics
1404: ( p_api_version_number => 1.0
1405: , p_init_msg_list => FND_API.G_FALSE
1406: , x_movement_transaction => l_new_movement_transaction
1407: , x_msg_count => x_msg_count
1408: , x_msg_data => x_msg_data
1409: , x_return_status => x_return_status

Line 1494: IF x_return_status = FND_API.G_RET_STS_SUCCESS

1490: , x_msg_count => x_msg_count
1491: , x_msg_data => x_msg_data
1492: );
1493:
1494: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1495: THEN
1496: validate_rule_flag := 'Y';
1497: ELSE
1498: validate_rule_flag := 'N';

Line 1519: IF l_return_status=FND_API.G_RET_STS_ERROR

1515: );
1516:
1517: x_updated_flag := l_updated_flag;
1518:
1519: IF l_return_status=FND_API.G_RET_STS_ERROR
1520: AND l_record_status='N'
1521: THEN
1522: -- nothing corrected although we found error
1523: -- the API will return FND_API.G_RET_STS_ERROR

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

1519: IF l_return_status=FND_API.G_RET_STS_ERROR
1520: AND l_record_status='N'
1521: THEN
1522: -- nothing corrected although we found error
1523: -- the API will return FND_API.G_RET_STS_ERROR
1524: l_corrected := 'N';
1525: ELSE
1526: -- see state diagram for reason of setting status to V
1527: -- Added check for rule based validation if Y only then set status to V

Line 1602: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1598: END IF;
1599: --l_orig_mvmt_transaction.movement_status:='V';
1600: ELSE
1601: -- the invoice is not found, raise unexpected error exception
1602: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1603: END IF;
1604: END IF;
1605: END IF;
1606:

Line 1662: X_return_status:=FND_API.G_RET_STS_ERROR;

1658: IF l_corrected='N'
1659: THEN
1660: --ssui: bug 1072889, keep status as OPEN if exception but not corrected
1661: l_orig_mvmt_transaction.movement_status:='O';
1662: X_return_status:=FND_API.G_RET_STS_ERROR;
1663: END IF;
1664:
1665: -- set return exception list
1666: x_excp_list := g_final_excp_list;

Line 1679: WHEN FND_API.G_EXC_ERROR THEN

1675: );
1676: END IF;
1677:
1678: EXCEPTION
1679: WHEN FND_API.G_EXC_ERROR THEN
1680: x_return_status := FND_API.G_RET_STS_ERROR;
1681: -- Get message count and data
1682: FND_MSG_PUB.Count_And_Get
1683: ( p_count => x_msg_count

Line 1680: x_return_status := FND_API.G_RET_STS_ERROR;

1676: END IF;
1677:
1678: EXCEPTION
1679: WHEN FND_API.G_EXC_ERROR THEN
1680: x_return_status := FND_API.G_RET_STS_ERROR;
1681: -- Get message count and data
1682: FND_MSG_PUB.Count_And_Get
1683: ( p_count => x_msg_count
1684: , p_data => x_msg_data

Line 1687: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1683: ( p_count => x_msg_count
1684: , p_data => x_msg_data
1685: );
1686:
1687: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1689: -- Get message count and data
1690: FND_MSG_PUB.Count_And_Get
1691: ( p_count => x_msg_count

Line 1688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1684: , p_data => x_msg_data
1685: );
1686:
1687: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1689: -- Get message count and data
1690: FND_MSG_PUB.Count_And_Get
1691: ( p_count => x_msg_count
1692: , p_data => x_msg_data

Line 1696: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1692: , p_data => x_msg_data
1693: );
1694:
1695: WHEN OTHERS THEN
1696: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1697: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1698: THEN
1699: FND_MSG_PUB.Add_Exc_Msg
1700: ( G_PKG_NAME

Line 1755: x_return_status := FND_API.G_RET_STS_SUCCESS;

1751: -- Copy input transaction record to local record for processing
1752: l_orig_mvmt_transaction := x_movement_statistics;
1753:
1754: -- Init x_return_status and x_record_status
1755: x_return_status := FND_API.G_RET_STS_SUCCESS;
1756: -- x_record_status set to Y for correct record
1757: -- whenever record missing or incorrect then change the status to N
1758: x_record_status := 'Y';
1759: x_updated_flag := 'N';

Line 1783: x_return_status := FND_API.G_RET_STS_ERROR;

1779: , p_message_cd => 2
1780: );
1781: -- 'INCORRECT' value for delivery_terms, set return status to error to
1782: -- indicate validate found error
1783: x_return_status := FND_API.G_RET_STS_ERROR;
1784: -- indicate incorrect record
1785: x_record_status := 'N';
1786: END;
1787: END IF;

Line 1805: x_return_status := FND_API.G_RET_STS_ERROR;

1801: ,p_message_cd => 1
1802: );
1803:
1804: -- 'MISSING' value, so set return status to error
1805: x_return_status := FND_API.G_RET_STS_ERROR;
1806:
1807: */
1808:
1809: l_orig_mvmt_transaction.category_id

Line 1834: x_return_status := FND_API.G_RET_STS_ERROR;

1830: ,p_message_cd => 1
1831: );
1832:
1833: -- 'MISSING' value, so set return status to error
1834: x_return_status := FND_API.G_RET_STS_ERROR;
1835:
1836: END IF;
1837: END IF;
1838:

Line 1850: x_return_status := FND_API.G_RET_STS_ERROR;

1846: /* create_table_data(p_col_name => 'UNIT_WEIGHT'
1847: ,p_message_cd => 1
1848: );
1849: -- 'MISSING' value, so set return status to error
1850: x_return_status := FND_API.G_RET_STS_ERROR;
1851: */
1852: l_orig_mvmt_transaction.unit_weight :=
1853: INV_MGD_MVT_UTILS_PKG.Calc_Unit_Weight
1854: ( p_inventory_item_id => l_orig_mvmt_transaction.inventory_item_id

Line 1892: x_return_status := FND_API.G_RET_STS_ERROR;

1888: create_table_data(p_col_name => 'UNIT_WEIGHT'
1889: ,p_message_cd => 1
1890: );
1891: -- 'MISSING' value, so set return status to error
1892: x_return_status := FND_API.G_RET_STS_ERROR;
1893:
1894: END IF;
1895: END IF;
1896:

Line 1910: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1906:
1907: EXCEPTION
1908:
1909: WHEN OTHERS THEN
1910: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1911: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1912: THEN
1913: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Validate_Record');
1914: END IF;

Line 1970: x_return_status := FND_API.G_RET_STS_SUCCESS;

1966: IS
1967:
1968: BEGIN
1969:
1970: x_return_status := FND_API.G_RET_STS_SUCCESS;
1971:
1972: DELETE FROM MTL_MOVEMENT_STATISTICS
1973: WHERE movement_id = p_movement_transaction.movement_id
1974: AND movement_status in ('O','V')

Line 1980: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1976:
1977: EXCEPTION
1978:
1979: WHEN NO_DATA_FOUND THEN
1980: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1981:
1982: WHEN OTHERS THEN
1983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1984:

Line 1983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1979: WHEN NO_DATA_FOUND THEN
1980: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1981:
1982: WHEN OTHERS THEN
1983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1984:
1985: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1986: THEN
1987: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Delete_Movement_Statistics');

Line 2027: x_return_status := FND_API.G_RET_STS_SUCCESS;

2023: );
2024: END IF;
2025:
2026: ---- Initialize x_return_status
2027: x_return_status := FND_API.G_RET_STS_SUCCESS;
2028:
2029: l_mvt_transaction_rec:=p_mvt_transaction_rec;
2030:
2031: ----check if the value matches any of the value in the lookup table

Line 2124: x_return_status := FND_API.G_RET_STS_ERROR;

2120: --Invalid Value for attribute field
2121: create_table_data(p_col_name => p_attribute_code
2122: ,p_message_cd => 1
2123: );
2124: x_return_status := FND_API.G_RET_STS_ERROR;
2125:
2126: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2127: THEN
2128: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

Line 2161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2157: END IF;
2158:
2159: EXCEPTION
2160: WHEN OTHERS THEN
2161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2162: ---x_movement_transaction := p_mvt_transaction_rec;
2163: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2164: THEN
2165: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Partner_vat_number');

Line 2234: x_return_status := FND_API.G_RET_STS_SUCCESS;

2230: -- Copy input transaction record to local record for processing
2231: l_orig_mvmt_transaction := x_movement_transaction;
2232:
2233: -- Init x_return_status
2234: x_return_status := FND_API.G_RET_STS_SUCCESS;
2235:
2236: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2237: THEN
2238: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

Line 2354: x_return_status := FND_API.G_RET_STS_ERROR;

2350: create_table_data(p_col_name => Rules_rec.attribute_code
2351: ,p_message_cd => 2
2352: );
2353:
2354: x_return_status := FND_API.G_RET_STS_ERROR;
2355:
2356: END IF;
2357: END IF;
2358: ELSE

Line 2402: x_return_status := FND_API.G_RET_STS_ERROR;

2398: WHEN NO_DATA_FOUND THEN
2399: --Invalid Value for attribute field
2400: create_table_data(p_col_name => Rules_rec.attribute_code
2401: ,p_message_cd => 2);
2402: x_return_status := FND_API.G_RET_STS_ERROR;
2403: END;
2404: END IF;
2405:
2406: END IF; --Rules_rec.attribute_lookup_type

Line 2463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2459: END IF;
2460:
2461: EXCEPTION
2462: WHEN OTHERS THEN
2463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2464: x_movement_transaction := l_orig_mvmt_transaction;
2465: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2466: THEN
2467: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Validate_Rules');