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

Line 137: IF NOT FND_API.Compatible_API_Call ( l_api_version, p_api_version,

133:
134: x_return_status := G_RET_STS_SUCCESS;
135:
136: -- Check for call compatibility
137: IF NOT FND_API.Compatible_API_Call ( l_api_version, p_api_version,
138: l_api_name, G_PKG_NAME )
139: THEN
140: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
141: END IF;

Line 140: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;

136: -- Check for call compatibility
137: IF NOT FND_API.Compatible_API_Call ( l_api_version, p_api_version,
138: l_api_name, G_PKG_NAME )
139: THEN
140: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
141: END IF;
142:
143: -- Initialize message list
144: IF FND_API.To_Boolean (p_init_msg_list) THEN

Line 144: IF FND_API.To_Boolean (p_init_msg_list) THEN

140: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
141: END IF;
142:
143: -- Initialize message list
144: IF FND_API.To_Boolean (p_init_msg_list) THEN
145: Error_Handler.Initialize;
146: END IF;
147:
148: -- Set business object identifier in the System Information record

Line 175: RAISE FND_API.G_EXC_ERROR;

171: ,x_return_status => x_return_status
172: ,x_msg_count => x_msg_count);
173:
174: IF x_return_status = G_RET_STS_ERROR THEN
175: RAISE FND_API.G_EXC_ERROR;
176: ELSIF x_return_status = G_RET_STS_UNEXP_ERROR THEN
177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
178: END IF;
179:

Line 177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

173:
174: IF x_return_status = G_RET_STS_ERROR THEN
175: RAISE FND_API.G_EXC_ERROR;
176: ELSIF x_return_status = G_RET_STS_UNEXP_ERROR THEN
177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
178: END IF;
179:
180: END IF;
181:

Line 199: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN

195: x_return_status := l_return_status;
196: x_Item_Tbl := EGO_Item_PVT.G_Item_Tbl;
197:
198: EXCEPTION
199: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
200: x_return_status := G_RET_STS_UNEXP_ERROR;
201: WHEN others THEN
202: x_return_status := G_RET_STS_UNEXP_ERROR;
203: EGO_Item_Msg.Add_Error_Message ( EGO_Item_PVT.G_Item_indx, 'INV', 'INV_ITEM_UNEXPECTED_ERROR',

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

396: , p_New_Segment20
397: , l_Item_Tbl
398: , l_return_status);
399:
400: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
401: x_msg_count := NVL(x_msg_count,0)+1; --Bug:3947619
402: END IF;
403:
404: END IF;

Line 406: IF (l_return_status IN (FND_API.G_RET_STS_SUCCESS,G_MISS_CHAR) ) THEN

402: END IF;
403:
404: END IF;
405:
406: IF (l_return_status IN (FND_API.G_RET_STS_SUCCESS,G_MISS_CHAR) ) THEN
407: EGO_Item_PUB.Process_Items(
408: p_api_version => 1.0
409: , p_init_msg_list => p_init_msg_list
410: , p_commit => p_commit

Line 915: IF NOT FND_API.Compatible_API_Call (l_api_version,

911: AND organization_id = cp_organization_id;
912:
913: BEGIN
914: -- standard check for API validation
915: IF NOT FND_API.Compatible_API_Call (l_api_version,
916: p_api_version,
917: l_api_name,
918: G_PKG_NAME)
919: THEN

Line 920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

916: p_api_version,
917: l_api_name,
918: G_PKG_NAME)
919: THEN
920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
921: END IF;
922:
923: -- create save point
924: IF FND_API.To_Boolean(p_commit) THEN

Line 924: IF FND_API.To_Boolean(p_commit) THEN

920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
921: END IF;
922:
923: -- create save point
924: IF FND_API.To_Boolean(p_commit) THEN
925: SAVEPOINT Process_Item_Scalar;
926: END IF;
927:
928: -- Initialize message list

Line 929: IF FND_API.To_Boolean(p_init_msg_list) THEN

925: SAVEPOINT Process_Item_Scalar;
926: END IF;
927:
928: -- Initialize message list
929: IF FND_API.To_Boolean(p_init_msg_list) THEN
930: FND_MSG_PUB.Initialize;
931: END IF;
932:
933: -- Set business object identifier in the System Information record

Line 953: RAISE FND_API.G_EXC_ERROR;

949: ,x_item_table => l_item_tbl
950: ,x_return_status => x_return_status
951: ,x_msg_count => x_msg_count);
952: IF x_return_status = G_RET_STS_ERROR THEN
953: RAISE FND_API.G_EXC_ERROR;
954: ELSIF x_return_status = G_RET_STS_UNEXP_ERROR THEN
955: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
956: END IF;
957: END IF;

Line 955: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

951: ,x_msg_count => x_msg_count);
952: IF x_return_status = G_RET_STS_ERROR THEN
953: RAISE FND_API.G_EXC_ERROR;
954: ELSIF x_return_status = G_RET_STS_UNEXP_ERROR THEN
955: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
956: END IF;
957: END IF;
958:
959: IF p_Template_Id IS NOT NULL

Line 975: RAISE FND_API.G_EXC_ERROR;

971:
972: l_template_applied := TRUE;
973:
974: IF x_return_status = G_RET_STS_ERROR THEN
975: RAISE FND_API.G_EXC_ERROR;
976: ELSIF x_return_status = G_RET_STS_UNEXP_ERROR THEN
977: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
978: END IF;
979: END IF;

Line 977: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

973:
974: IF x_return_status = G_RET_STS_ERROR THEN
975: RAISE FND_API.G_EXC_ERROR;
976: ELSIF x_return_status = G_RET_STS_UNEXP_ERROR THEN
977: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
978: END IF;
979: END IF;
980: END IF;
981:

Line 1007: IF FND_API.To_Boolean(p_commit) THEN

1003: p_entity_index => 1
1004: ,p_application_short_name => 'EGO'
1005: ,p_message_name => 'EGO_REQUERY_ITEM_INFO'
1006: );
1007: IF FND_API.To_Boolean(p_commit) THEN
1008: ROLLBACK TO Process_Item_Scalar;
1009: END IF;
1010: x_msg_count := 1;
1011: RETURN;

Line 1035: RAISE FND_API.G_EXC_ERROR;

1031: ,x_return_status => x_return_status
1032: ,x_msg_count => x_msg_count);
1033:
1034: IF x_return_status = G_RET_STS_ERROR THEN
1035: RAISE FND_API.G_EXC_ERROR;
1036: ELSIF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1038: END IF;
1039: END IF;

Line 1037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1033:
1034: IF x_return_status = G_RET_STS_ERROR THEN
1035: RAISE FND_API.G_EXC_ERROR;
1036: ELSIF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1038: END IF;
1039: END IF;
1040:
1041: --During CREATE COPY_ITEM/TEMPLATE are applicable for NPR Catalog

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

1073: ,x_Item_Tbl => l_item_created_tbl
1074: ,x_return_status => x_return_status);
1075:
1076: --Bug: 3947619 incrementing the msg count if error message were logged
1077: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1078: x_msg_count := NVL(x_msg_count,0)+1;
1079: END IF;
1080: END IF;
1081:

Line 1082: IF NVL(x_return_status,FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS AND

1078: x_msg_count := NVL(x_msg_count,0)+1;
1079: END IF;
1080: END IF;
1081:
1082: IF NVL(x_return_status,FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS AND
1083: p_transaction_type IN (G_TTYPE_CREATE, G_TTYPE_UPDATE) THEN
1084:
1085: l_item_tbl(indx).item_number := p_item_number;
1086: l_item_tbl(indx).segment1 := p_segment1;

Line 1537: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND l_item_tbl(indx).process_item_record = 1 THEN

1533: INV_EGO_REVISION_VALIDATE.Set_Process_Control(NULL);
1534:
1535: l_item_created_tbl := EGO_Item_PVT.G_Item_Tbl;
1536:
1537: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND l_item_tbl(indx).process_item_record = 1 THEN
1538:
1539: x_inventory_item_id := l_item_created_tbl(indx).inventory_item_id;
1540: x_organization_id := l_item_created_tbl(indx).organization_id;
1541:

Line 1555: END IF; -- x_return_status = FND_API.G_RET_STS_SUCCESS from IOI

1551: ,p_organization_id => x_organization_id
1552: ,p_approval_status => l_approval_status );
1553: END IF;
1554:
1555: END IF; -- x_return_status = FND_API.G_RET_STS_SUCCESS from IOI
1556:
1557: ELSIF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1558:
1559: FND_MESSAGE.Set_Name ('EGO', 'EGO_PROGRAM_NOT_IMPLEMENTED');

Line 1557: ELSIF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1553: END IF;
1554:
1555: END IF; -- x_return_status = FND_API.G_RET_STS_SUCCESS from IOI
1556:
1557: ELSIF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1558:
1559: FND_MESSAGE.Set_Name ('EGO', 'EGO_PROGRAM_NOT_IMPLEMENTED');
1560: FND_MSG_PUB.Add;
1561: RAISE FND_API.G_EXC_ERROR;

Line 1561: RAISE FND_API.G_EXC_ERROR;

1557: ELSIF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1558:
1559: FND_MESSAGE.Set_Name ('EGO', 'EGO_PROGRAM_NOT_IMPLEMENTED');
1560: FND_MSG_PUB.Add;
1561: RAISE FND_API.G_EXC_ERROR;
1562:
1563: END IF; -- TRANSACTION_TYPE IN CREATE/UPDATE
1564:
1565: IF FND_API.To_Boolean(p_commit) THEN

Line 1565: IF FND_API.To_Boolean(p_commit) THEN

1561: RAISE FND_API.G_EXC_ERROR;
1562:
1563: END IF; -- TRANSACTION_TYPE IN CREATE/UPDATE
1564:
1565: IF FND_API.To_Boolean(p_commit) THEN
1566: COMMIT WORK;
1567: END IF;
1568:
1569: --EGO_Item_PVT.Process_Items returns the status which is correct, please donot override that.

Line 1575: WHEN FND_API.G_EXC_ERROR THEN

1571: --Bug 5997870.. Clear the values before returning so that it does not stick around till next call..
1572: Clear_Object_Version_Values;
1573:
1574: EXCEPTION
1575: WHEN FND_API.G_EXC_ERROR THEN
1576: Clear_Object_Version_Values;
1577:
1578: IF FND_API.To_Boolean(p_commit) THEN
1579: ROLLBACK TO Process_Item_Scalar;

Line 1578: IF FND_API.To_Boolean(p_commit) THEN

1574: EXCEPTION
1575: WHEN FND_API.G_EXC_ERROR THEN
1576: Clear_Object_Version_Values;
1577:
1578: IF FND_API.To_Boolean(p_commit) THEN
1579: ROLLBACK TO Process_Item_Scalar;
1580: END IF;
1581: x_return_status := G_RET_STS_ERROR;
1582: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 1582: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

1578: IF FND_API.To_Boolean(p_commit) THEN
1579: ROLLBACK TO Process_Item_Scalar;
1580: END IF;
1581: x_return_status := G_RET_STS_ERROR;
1582: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
1583: ,p_count => x_msg_count
1584: ,p_data => x_msg_data);
1585: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1586: Clear_Object_Version_Values;

Line 1585: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1581: x_return_status := G_RET_STS_ERROR;
1582: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
1583: ,p_count => x_msg_count
1584: ,p_data => x_msg_data);
1585: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1586: Clear_Object_Version_Values;
1587:
1588: IF FND_API.To_Boolean(p_commit) THEN
1589: ROLLBACK TO Process_Item_Scalar;

Line 1588: IF FND_API.To_Boolean(p_commit) THEN

1584: ,p_data => x_msg_data);
1585: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1586: Clear_Object_Version_Values;
1587:
1588: IF FND_API.To_Boolean(p_commit) THEN
1589: ROLLBACK TO Process_Item_Scalar;
1590: END IF;
1591: x_RETURN_STATUS := G_RET_STS_UNEXP_ERROR;
1592: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 1592: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

1588: IF FND_API.To_Boolean(p_commit) THEN
1589: ROLLBACK TO Process_Item_Scalar;
1590: END IF;
1591: x_RETURN_STATUS := G_RET_STS_UNEXP_ERROR;
1592: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
1593: ,p_count => x_msg_count
1594: ,p_data => x_msg_data);
1595: WHEN OTHERS THEN
1596: Clear_Object_Version_Values;

Line 1598: IF FND_API.To_Boolean(p_commit) THEN

1594: ,p_data => x_msg_data);
1595: WHEN OTHERS THEN
1596: Clear_Object_Version_Values;
1597:
1598: IF FND_API.To_Boolean(p_commit) THEN
1599: ROLLBACK TO Process_Item_Scalar;
1600: END IF;
1601: x_return_status := G_RET_STS_UNEXP_ERROR;
1602: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

Line 1607: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

1603: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
1604: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
1605: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
1606: FND_MSG_PUB.Add;
1607: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
1608: ,p_count => x_msg_count
1609: ,p_data => x_msg_data);
1610: END Process_Item;
1611:

Line 1627: IF NOT FND_API.Compatible_API_Call ( l_api_version, p_api_version,

1623: l_return_status VARCHAR2(1) := G_MISS_CHAR;
1624: BEGIN
1625: x_return_status := G_RET_STS_SUCCESS;
1626: -- Check for call compatibility
1627: IF NOT FND_API.Compatible_API_Call ( l_api_version, p_api_version,
1628: l_api_name, G_PKG_NAME )
1629: THEN
1630: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
1631: END IF;

Line 1630: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;

1626: -- Check for call compatibility
1627: IF NOT FND_API.Compatible_API_Call ( l_api_version, p_api_version,
1628: l_api_name, G_PKG_NAME )
1629: THEN
1630: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
1631: END IF;
1632:
1633: -- Initialize message list
1634: IF FND_API.To_Boolean (p_init_msg_list) THEN

Line 1634: IF FND_API.To_Boolean (p_init_msg_list) THEN

1630: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
1631: END IF;
1632:
1633: -- Initialize message list
1634: IF FND_API.To_Boolean (p_init_msg_list) THEN
1635: Error_Handler.Initialize;
1636: END IF;
1637:
1638: -- Set business object identifier in the System Information record

Line 1652: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN

1648:
1649: x_return_status := l_return_status;
1650:
1651: EXCEPTION
1652: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
1653: x_return_status := G_RET_STS_UNEXP_ERROR;
1654: WHEN others THEN
1655: x_return_status := G_RET_STS_UNEXP_ERROR;
1656: EGO_Item_Msg.Add_Error_Message ( EGO_Item_PVT.G_Item_Org_indx, 'INV', 'INV_ITEM_UNEXPECTED_ERROR',

Line 1795: x_return_status := FND_API.G_RET_STS_ERROR;

1791: ,p_translate2 => FALSE
1792: ,p_token_name3 => 'API_VERSION'
1793: ,p_token_value3 => '1.0'
1794: ,p_translate3 => FALSE);
1795: x_return_status := FND_API.G_RET_STS_ERROR;
1796: END IF;
1797:
1798: ELSE
1799:

Line 1876: x_return_status := FND_API.G_RET_STS_SUCCESS;

1872: x_Item_Tbl(1).segment18 := l_Segment_Rec.segment18;
1873: x_Item_Tbl(1).segment19 := l_Segment_Rec.segment19;
1874: x_Item_Tbl(1).segment20 := l_Segment_Rec.segment20;
1875:
1876: x_return_status := FND_API.G_RET_STS_SUCCESS;
1877:
1878: ELSIF p_Inventory_Item_Id <> l_Item_Id THEN
1879:
1880: EGO_Item_Msg.Add_Error_Message (

Line 1885: x_return_status := FND_API.G_RET_STS_ERROR;

1881: p_entity_index => 1
1882: ,p_application_short_name => 'INV'
1883: ,p_message_name => 'INV_DUPL_ORG_ITEM_SEG');
1884:
1885: x_return_status := FND_API.G_RET_STS_ERROR;
1886: ELSE
1887: --Segments are same not updated
1888: x_return_status := FND_API.G_RET_STS_SUCCESS;
1889: END IF;

Line 1888: x_return_status := FND_API.G_RET_STS_SUCCESS;

1884:
1885: x_return_status := FND_API.G_RET_STS_ERROR;
1886: ELSE
1887: --Segments are same not updated
1888: x_return_status := FND_API.G_RET_STS_SUCCESS;
1889: END IF;
1890:
1891: END Update_Item_Number;
1892:

Line 1915: IF FND_API.To_Boolean(p_commit) THEN

1911: ,x_errorcode => x_errorcode
1912: ,x_msg_count => x_msg_count
1913: ,x_msg_data => x_msg_data);
1914:
1915: IF FND_API.To_Boolean(p_commit) THEN
1916: COMMIT WORK;
1917: END IF;
1918:
1919: END Seed_Item_Long_Desc_Attr_Group;

Line 1937: IF FND_API.To_Boolean(p_commit) THEN

1933: ,x_return_status => x_return_status
1934: ,x_msg_data => x_msg_data
1935: );
1936:
1937: IF FND_API.To_Boolean(p_commit) THEN
1938: COMMIT WORK;
1939: END IF;
1940:
1941: END Seed_Item_Long_Desc_In_Bulk;

Line 1954: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE

1950: ,p_entity_id IN NUMBER DEFAULT NULL
1951: ,p_entity_index IN NUMBER DEFAULT NULL
1952: ,p_entity_code IN VARCHAR2 DEFAULT NULL
1953: ,p_debug_level IN NUMBER DEFAULT 0
1954: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
1955: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
1956: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
1957: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
1958: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 1955: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE

1951: ,p_entity_index IN NUMBER DEFAULT NULL
1952: ,p_entity_code IN VARCHAR2 DEFAULT NULL
1953: ,p_debug_level IN NUMBER DEFAULT 0
1954: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
1955: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
1956: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
1957: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
1958: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
1959: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 1956: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

1952: ,p_entity_code IN VARCHAR2 DEFAULT NULL
1953: ,p_debug_level IN NUMBER DEFAULT 0
1954: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
1955: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
1956: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
1957: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
1958: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
1959: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
1960: ,x_failed_row_id_list OUT NOCOPY VARCHAR2

Line 1957: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE

1953: ,p_debug_level IN NUMBER DEFAULT 0
1954: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
1955: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
1956: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
1957: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
1958: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
1959: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
1960: ,x_failed_row_id_list OUT NOCOPY VARCHAR2
1961: ,x_return_status OUT NOCOPY VARCHAR2

Line 1958: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE

1954: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
1955: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
1956: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
1957: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
1958: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
1959: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
1960: ,x_failed_row_id_list OUT NOCOPY VARCHAR2
1961: ,x_return_status OUT NOCOPY VARCHAR2
1962: ,x_errorcode OUT NOCOPY NUMBER

Line 1959: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

1955: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
1956: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
1957: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
1958: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
1959: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
1960: ,x_failed_row_id_list OUT NOCOPY VARCHAR2
1961: ,x_return_status OUT NOCOPY VARCHAR2
1962: ,x_errorcode OUT NOCOPY NUMBER
1963: ,x_msg_count OUT NOCOPY NUMBER

Line 2004: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE

2000: ,p_entity_id IN NUMBER DEFAULT NULL
2001: ,p_entity_index IN NUMBER DEFAULT NULL
2002: ,p_entity_code IN VARCHAR2 DEFAULT NULL
2003: ,p_debug_level IN NUMBER DEFAULT 0
2004: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
2005: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2006: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
2007: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2008: ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE

Line 2005: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

2001: ,p_entity_index IN NUMBER DEFAULT NULL
2002: ,p_entity_code IN VARCHAR2 DEFAULT NULL
2003: ,p_debug_level IN NUMBER DEFAULT 0
2004: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
2005: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2006: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
2007: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2008: ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
2009: ,x_attributes_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE

Line 2006: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE

2002: ,p_entity_code IN VARCHAR2 DEFAULT NULL
2003: ,p_debug_level IN NUMBER DEFAULT 0
2004: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
2005: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2006: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
2007: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2008: ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
2009: ,x_attributes_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
2010: ,x_return_status OUT NOCOPY VARCHAR2

Line 2007: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

2003: ,p_debug_level IN NUMBER DEFAULT 0
2004: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
2005: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2006: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
2007: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2008: ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
2009: ,x_attributes_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
2010: ,x_return_status OUT NOCOPY VARCHAR2
2011: ,x_errorcode OUT NOCOPY NUMBER

Line 2124: IF FND_API.To_Boolean(p_commit) THEN

2120: ,x_return_status => l_event_return_status );
2121: END IF;
2122: -- End 4105841 : Business Event Enhancement
2123:
2124: IF FND_API.To_Boolean(p_commit) THEN
2125: COMMIT WORK;
2126: END IF;
2127:
2128: IF FND_API.To_Boolean(p_commit) THEN

Line 2128: IF FND_API.To_Boolean(p_commit) THEN

2124: IF FND_API.To_Boolean(p_commit) THEN
2125: COMMIT WORK;
2126: END IF;
2127:
2128: IF FND_API.To_Boolean(p_commit) THEN
2129: COMMIT WORK;
2130: END IF;
2131: END Update_Item_Approval_Status;
2132:

Line 3279: IF FND_API.To_Boolean(p_commit) THEN

3275: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
3276: X_MSG_COUNT OUT NOCOPY NUMBER) IS
3277: BEGIN
3278: -- create save point
3279: IF FND_API.To_Boolean(p_commit) THEN
3280: SAVEPOINT Process_Item_Lifecycle;
3281: END IF;
3282:
3283: X_RETURN_STATUS := FND_API.g_RET_STS_SUCCESS;

Line 3283: X_RETURN_STATUS := FND_API.g_RET_STS_SUCCESS;

3279: IF FND_API.To_Boolean(p_commit) THEN
3280: SAVEPOINT Process_Item_Lifecycle;
3281: END IF;
3282:
3283: X_RETURN_STATUS := FND_API.g_RET_STS_SUCCESS;
3284: X_MSG_COUNT := 0;
3285:
3286: IF (P_TRANSACTION_TYPE = G_TTYPE_CREATE) THEN
3287: Create_Item_Lifecycle(

Line 3314: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN

3310: X_MSG_COUNT => X_MSG_COUNT);
3311: END IF;
3312:
3313: EXCEPTION
3314: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
3315: IF FND_API.To_Boolean(p_commit) THEN
3316: ROLLBACK TO Process_Item_Lifecycle;
3317: END IF;
3318: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3315: IF FND_API.To_Boolean(p_commit) THEN

3311: END IF;
3312:
3313: EXCEPTION
3314: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
3315: IF FND_API.To_Boolean(p_commit) THEN
3316: ROLLBACK TO Process_Item_Lifecycle;
3317: END IF;
3318: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
3319: WHEN others THEN

Line 3318: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

3314: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
3315: IF FND_API.To_Boolean(p_commit) THEN
3316: ROLLBACK TO Process_Item_Lifecycle;
3317: END IF;
3318: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
3319: WHEN others THEN
3320: IF FND_API.To_Boolean(p_commit) THEN
3321: ROLLBACK TO Process_Item_Lifecycle;
3322: END IF;

Line 3320: IF FND_API.To_Boolean(p_commit) THEN

3316: ROLLBACK TO Process_Item_Lifecycle;
3317: END IF;
3318: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
3319: WHEN others THEN
3320: IF FND_API.To_Boolean(p_commit) THEN
3321: ROLLBACK TO Process_Item_Lifecycle;
3322: END IF;
3323: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
3324: END Process_Item_Lifecycle;

Line 3323: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

3319: WHEN others THEN
3320: IF FND_API.To_Boolean(p_commit) THEN
3321: ROLLBACK TO Process_Item_Lifecycle;
3322: END IF;
3323: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
3324: END Process_Item_Lifecycle;
3325:
3326: ---------------------------------------------------------------------------
3327: Procedure Create_Item_Lifecycle(

Line 3340: IF FND_API.To_Boolean(p_commit) THEN

3336: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
3337: X_MSG_COUNT OUT NOCOPY NUMBER) IS
3338: BEGIN
3339: -- create save point
3340: IF FND_API.To_Boolean(p_commit) THEN
3341: SAVEPOINT Create_Item_Lifecycle;
3342: END IF;
3343: X_RETURN_STATUS := FND_API.g_RET_STS_SUCCESS;
3344: X_MSG_COUNT := 0;

Line 3343: X_RETURN_STATUS := FND_API.g_RET_STS_SUCCESS;

3339: -- create save point
3340: IF FND_API.To_Boolean(p_commit) THEN
3341: SAVEPOINT Create_Item_Lifecycle;
3342: END IF;
3343: X_RETURN_STATUS := FND_API.g_RET_STS_SUCCESS;
3344: X_MSG_COUNT := 0;
3345:
3346: UPDATE MTL_SYSTEM_ITEMS_B SET LIFECYCLE_ID = P_LIFECYCLE_ID
3347: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID

Line 3370: IF FND_API.To_Boolean(p_commit) THEN

3366: UPDATE MTL_PENDING_ITEM_STATUS SET STATUS_CODE = P_ITEM_STATUS
3367: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
3368: AND ORGANIZATION_ID = P_ORGANIZATION_ID;
3369:
3370: IF FND_API.To_Boolean(p_commit) THEN
3371: COMMIT WORK;
3372: END IF;
3373:
3374: EXCEPTION

Line 3375: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN

3371: COMMIT WORK;
3372: END IF;
3373:
3374: EXCEPTION
3375: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
3376: IF FND_API.To_Boolean(p_commit) THEN
3377: ROLLBACK TO Create_Item_Lifecycle;
3378: END IF;
3379: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3376: IF FND_API.To_Boolean(p_commit) THEN

3372: END IF;
3373:
3374: EXCEPTION
3375: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
3376: IF FND_API.To_Boolean(p_commit) THEN
3377: ROLLBACK TO Create_Item_Lifecycle;
3378: END IF;
3379: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
3380: WHEN others THEN

Line 3379: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

3375: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
3376: IF FND_API.To_Boolean(p_commit) THEN
3377: ROLLBACK TO Create_Item_Lifecycle;
3378: END IF;
3379: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
3380: WHEN others THEN
3381: IF FND_API.To_Boolean(p_commit) THEN
3382: ROLLBACK TO Create_Item_Lifecycle;
3383: END IF;

Line 3381: IF FND_API.To_Boolean(p_commit) THEN

3377: ROLLBACK TO Create_Item_Lifecycle;
3378: END IF;
3379: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
3380: WHEN others THEN
3381: IF FND_API.To_Boolean(p_commit) THEN
3382: ROLLBACK TO Create_Item_Lifecycle;
3383: END IF;
3384: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
3385: END Create_Item_Lifecycle;

Line 3384: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

3380: WHEN others THEN
3381: IF FND_API.To_Boolean(p_commit) THEN
3382: ROLLBACK TO Create_Item_Lifecycle;
3383: END IF;
3384: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
3385: END Create_Item_Lifecycle;
3386:
3387: ---------------------------------------------------------------------------
3388: Procedure Update_Item_Lifecycle(

Line 3420: IF FND_API.To_Boolean(p_commit) THEN

3416: L_CONTROL_LEVEL NUMBER;
3417:
3418: BEGIN
3419: -- create save point
3420: IF FND_API.To_Boolean(p_commit) THEN
3421: SAVEPOINT Update_Item_Lifecycle;
3422: END IF;
3423: X_RETURN_STATUS := FND_API.g_RET_STS_SUCCESS;
3424: X_MSG_COUNT := 0;

Line 3423: X_RETURN_STATUS := FND_API.g_RET_STS_SUCCESS;

3419: -- create save point
3420: IF FND_API.To_Boolean(p_commit) THEN
3421: SAVEPOINT Update_Item_Lifecycle;
3422: END IF;
3423: X_RETURN_STATUS := FND_API.g_RET_STS_SUCCESS;
3424: X_MSG_COUNT := 0;
3425:
3426: L_MASTER_ORGANIZATION_ID := EGO_ITEM_PUB.Get_Master_Organization_Id(P_ORGANIZATION_ID => P_ORGANIZATION_ID);
3427:

Line 3567: IF FND_API.To_Boolean(p_commit) THEN

3563: P_ITEM_CATALOG_GROUP_ID => P_CATALOG_GROUP_ID,
3564: X_RETURN_STATUS => X_RETURN_STATUS,
3565: X_MSG_COUNT => X_MSG_COUNT);
3566:
3567: IF FND_API.To_Boolean(p_commit) THEN
3568: COMMIT WORK;
3569: END IF;
3570:
3571: EXCEPTION

Line 3572: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN

3568: COMMIT WORK;
3569: END IF;
3570:
3571: EXCEPTION
3572: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
3573: IF FND_API.To_Boolean(p_commit) THEN
3574: ROLLBACK TO Update_Item_Lifecycle;
3575: END IF;
3576: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3573: IF FND_API.To_Boolean(p_commit) THEN

3569: END IF;
3570:
3571: EXCEPTION
3572: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
3573: IF FND_API.To_Boolean(p_commit) THEN
3574: ROLLBACK TO Update_Item_Lifecycle;
3575: END IF;
3576: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
3577: WHEN others THEN

Line 3576: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

3572: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
3573: IF FND_API.To_Boolean(p_commit) THEN
3574: ROLLBACK TO Update_Item_Lifecycle;
3575: END IF;
3576: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
3577: WHEN others THEN
3578: IF FND_API.To_Boolean(p_commit) THEN
3579: ROLLBACK TO Update_Item_Lifecycle;
3580: END IF;

Line 3578: IF FND_API.To_Boolean(p_commit) THEN

3574: ROLLBACK TO Update_Item_Lifecycle;
3575: END IF;
3576: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
3577: WHEN others THEN
3578: IF FND_API.To_Boolean(p_commit) THEN
3579: ROLLBACK TO Update_Item_Lifecycle;
3580: END IF;
3581: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
3582:

Line 3581: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

3577: WHEN others THEN
3578: IF FND_API.To_Boolean(p_commit) THEN
3579: ROLLBACK TO Update_Item_Lifecycle;
3580: END IF;
3581: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
3582:
3583: END Update_Item_Lifecycle;
3584:
3585: ---------------------------------------------------------------------------

Line 3598: IF FND_API.To_Boolean(p_commit) THEN

3594:
3595: BEGIN
3596:
3597: -- create save point
3598: IF FND_API.To_Boolean(p_commit) THEN
3599: SAVEPOINT Update_Item_Attr_Ext;
3600: END IF;
3601:
3602: X_RETURN_STATUS := FND_API.g_RET_STS_SUCCESS;

Line 3602: X_RETURN_STATUS := FND_API.g_RET_STS_SUCCESS;

3598: IF FND_API.To_Boolean(p_commit) THEN
3599: SAVEPOINT Update_Item_Attr_Ext;
3600: END IF;
3601:
3602: X_RETURN_STATUS := FND_API.g_RET_STS_SUCCESS;
3603: X_MSG_COUNT := 0;
3604:
3605: IF (P_ITEM_CATALOG_GROUP_ID IS NULL) THEN --delete query changed by absinha for Bug 3542129
3606: DELETE FROM EGO_MTL_SY_ITEMS_EXT_B WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID

Line 3622: IF FND_API.To_Boolean(p_commit) THEN

3618: SET ITEM_CATALOG_GROUP_ID = P_ITEM_CATALOG_GROUP_ID
3619: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID;
3620: END IF;
3621:
3622: IF FND_API.To_Boolean(p_commit) THEN
3623: COMMIT WORK;
3624: END IF;
3625:
3626: EXCEPTION

Line 3627: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN

3623: COMMIT WORK;
3624: END IF;
3625:
3626: EXCEPTION
3627: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
3628: IF FND_API.To_Boolean(p_commit) THEN
3629: ROLLBACK TO Update_Item_Attr_Ext;
3630: END IF;
3631: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3628: IF FND_API.To_Boolean(p_commit) THEN

3624: END IF;
3625:
3626: EXCEPTION
3627: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
3628: IF FND_API.To_Boolean(p_commit) THEN
3629: ROLLBACK TO Update_Item_Attr_Ext;
3630: END IF;
3631: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
3632: WHEN others THEN

Line 3631: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

3627: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
3628: IF FND_API.To_Boolean(p_commit) THEN
3629: ROLLBACK TO Update_Item_Attr_Ext;
3630: END IF;
3631: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
3632: WHEN others THEN
3633: IF FND_API.To_Boolean(p_commit) THEN
3634: ROLLBACK TO Update_Item_Attr_Ext;
3635: END IF;

Line 3633: IF FND_API.To_Boolean(p_commit) THEN

3629: ROLLBACK TO Update_Item_Attr_Ext;
3630: END IF;
3631: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
3632: WHEN others THEN
3633: IF FND_API.To_Boolean(p_commit) THEN
3634: ROLLBACK TO Update_Item_Attr_Ext;
3635: END IF;
3636: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
3637: END Update_Item_Attr_Ext;

Line 3636: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

3632: WHEN others THEN
3633: IF FND_API.To_Boolean(p_commit) THEN
3634: ROLLBACK TO Update_Item_Attr_Ext;
3635: END IF;
3636: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
3637: END Update_Item_Attr_Ext;
3638:
3639:
3640: FUNCTION Get_Master_Organization_Id(P_ORGANIZATION_ID IN NUMBER) RETURN NUMBER IS

Line 3880: IF NOT FND_API.Compatible_API_Call ( l_api_version, p_api_version,

3876:
3877: x_return_status := G_RET_STS_SUCCESS;
3878:
3879: -- Check for call compatibility
3880: IF NOT FND_API.Compatible_API_Call ( l_api_version, p_api_version,
3881: l_api_name, G_PKG_NAME )
3882: THEN
3883: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
3884: END IF;

Line 3883: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;

3879: -- Check for call compatibility
3880: IF NOT FND_API.Compatible_API_Call ( l_api_version, p_api_version,
3881: l_api_name, G_PKG_NAME )
3882: THEN
3883: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
3884: END IF;
3885:
3886: l_pk_column_name_value_pairs :=
3887: EGO_COL_NAME_VALUE_PAIR_ARRAY

Line 4299: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

4295:
4296: ---------------------------------------------------------------------------
4297: PROCEDURE Process_Item_Revision(
4298: p_api_version IN NUMBER
4299: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
4300: ,p_commit IN VARCHAR2 DEFAULT G_FALSE
4301: ,p_transaction_type IN VARCHAR2
4302: ,p_inventory_item_id IN NUMBER DEFAULT G_MISS_NUM
4303: ,p_item_number IN VARCHAR2 DEFAULT G_MISS_CHAR

Line 4351: IF NOT FND_API.Compatible_API_Call ( l_api_version, p_api_version,

4347: INVALID_ITEM_ORG EXCEPTION;
4348:
4349: BEGIN
4350:
4351: IF NOT FND_API.Compatible_API_Call ( l_api_version, p_api_version,
4352: l_api_name, G_PKG_NAME )
4353: THEN
4354: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
4355: END IF;

Line 4354: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;

4350:
4351: IF NOT FND_API.Compatible_API_Call ( l_api_version, p_api_version,
4352: l_api_name, G_PKG_NAME )
4353: THEN
4354: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
4355: END IF;
4356:
4357: BEGIN
4358: IF p_organization_id IS NULL THEN

Line 4441: x_return_status := FND_API.g_RET_STS_ERROR;

4437: EXCEPTION
4438: WHEN INVALID_ORG THEN
4439: FND_MESSAGE.Set_Name('EGO', 'EGO_INVALID_ORGANIZATION');
4440: FND_MSG_PUB.Add;
4441: x_return_status := FND_API.g_RET_STS_ERROR;
4442: WHEN INVALID_ITEM THEN
4443: FND_MESSAGE.Set_Name('EGO', 'EGO_INVALID_ITEM');
4444: FND_MSG_PUB.Add;
4445: x_return_status := FND_API.g_RET_STS_ERROR;

Line 4445: x_return_status := FND_API.g_RET_STS_ERROR;

4441: x_return_status := FND_API.g_RET_STS_ERROR;
4442: WHEN INVALID_ITEM THEN
4443: FND_MESSAGE.Set_Name('EGO', 'EGO_INVALID_ITEM');
4444: FND_MSG_PUB.Add;
4445: x_return_status := FND_API.g_RET_STS_ERROR;
4446: WHEN INVALID_ITEM_ORG THEN
4447: FND_MESSAGE.Set_Name('EGO', 'EGO_INVALID_ITEM_ORGANIZATION');
4448: FND_MSG_PUB.Add;
4449: x_return_status := FND_API.g_RET_STS_ERROR;

Line 4449: x_return_status := FND_API.g_RET_STS_ERROR;

4445: x_return_status := FND_API.g_RET_STS_ERROR;
4446: WHEN INVALID_ITEM_ORG THEN
4447: FND_MESSAGE.Set_Name('EGO', 'EGO_INVALID_ITEM_ORGANIZATION');
4448: FND_MSG_PUB.Add;
4449: x_return_status := FND_API.g_RET_STS_ERROR;
4450: WHEN OTHERS THEN
4451: x_return_status := G_RET_STS_UNEXP_ERROR;
4452: RAISE;
4453: END Process_Item_Revision;

Line 4482: IF FND_API.To_Boolean (p_init_msg_list) THEN

4478:
4479: x_return_status := G_RET_STS_SUCCESS;
4480:
4481: -- Initialize message list
4482: IF FND_API.To_Boolean (p_init_msg_list) THEN
4483: Error_Handler.Initialize;
4484: END IF;
4485:
4486: -- Set business object identifier in the System Information record

Line 4510: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;

4506:
4507: EXCEPTION
4508: WHEN others THEN
4509: l_err_text := SUBSTRB(SQLERRM, 1,240);
4510: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;
4511: EGO_Item_Msg.Add_Error_Message ( EGO_Item_PVT.G_Item_indx,
4512: 'INV', 'INV_ITEM_UNEXPECTED_ERROR',
4513: 'PACKAGE_NAME', G_PKG_NAME, FALSE,
4514: 'PROCEDURE_NAME', l_api_name, FALSE,

Line 4552: IF FND_API.To_Boolean (p_init_msg_list) THEN

4548:
4549: x_return_status := G_RET_STS_SUCCESS;
4550:
4551: -- Initialize message list
4552: IF FND_API.To_Boolean (p_init_msg_list) THEN
4553: Error_Handler.Initialize;
4554: END IF;
4555:
4556: -- Set business object identifier in the System Information record

Line 4569: RAISE FND_API.g_EXC_ERROR;

4565: THEN
4566: EGO_Item_Msg.Add_Error_Message (p_Entity_Index => EGO_Item_PVT.G_Item_indx,
4567: p_Application_Short_Name =>'INV',
4568: p_Message_Name =>'INV_IOI_ITEM_UPDATE_PRIV');
4569: RAISE FND_API.g_EXC_ERROR;
4570: ELSE
4571: IF p_transaction_type = 'CREATE' THEN
4572: INV_ITEM_CATEGORY_PUB.Create_Category_Assignment
4573: (

Line 4606: WHEN FND_API.G_EXC_ERROR THEN

4602: END IF;
4603: END IF;
4604:
4605: EXCEPTION
4606: WHEN FND_API.G_EXC_ERROR THEN
4607: x_return_status := FND_API.G_RET_STS_ERROR;
4608: FND_MSG_PUB.Count_And_Get
4609: ( p_count => x_msg_count,
4610: p_data => x_msg_data

Line 4607: x_return_status := FND_API.G_RET_STS_ERROR;

4603: END IF;
4604:
4605: EXCEPTION
4606: WHEN FND_API.G_EXC_ERROR THEN
4607: x_return_status := FND_API.G_RET_STS_ERROR;
4608: FND_MSG_PUB.Count_And_Get
4609: ( p_count => x_msg_count,
4610: p_data => x_msg_data
4611: );

Line 4614: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;

4610: p_data => x_msg_data
4611: );
4612: WHEN others THEN
4613: l_err_text := SUBSTRB(SQLERRM, 1,240);
4614: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;
4615: EGO_Item_Msg.Add_Error_Message ( EGO_Item_PVT.G_Item_indx,
4616: 'INV', 'INV_ITEM_UNEXPECTED_ERROR',
4617: 'PACKAGE_NAME', G_PKG_NAME, FALSE,
4618: 'PROCEDURE_NAME', l_api_name, FALSE,

Line 4640: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE

4636: ,p_multi_row_attrs_table IN UCCnet_Attrs_Multi_Row_Tbl_Typ
4637: ,p_entity_id IN NUMBER DEFAULT NULL
4638: ,p_entity_index IN NUMBER DEFAULT NULL
4639: ,p_entity_code IN VARCHAR2 DEFAULT NULL
4640: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
4641: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
4642: ,x_return_status OUT NOCOPY VARCHAR2
4643: ,x_errorcode OUT NOCOPY NUMBER
4644: ,x_msg_count OUT NOCOPY NUMBER

Line 4641: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

4637: ,p_entity_id IN NUMBER DEFAULT NULL
4638: ,p_entity_index IN NUMBER DEFAULT NULL
4639: ,p_entity_code IN VARCHAR2 DEFAULT NULL
4640: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
4641: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
4642: ,x_return_status OUT NOCOPY VARCHAR2
4643: ,x_errorcode OUT NOCOPY NUMBER
4644: ,x_msg_count OUT NOCOPY NUMBER
4645: ,x_msg_data OUT NOCOPY VARCHAR2) IS

Line 4713: , p_commit => FND_API.G_TRUE

4709: x_return_status := G_RET_STS_SUCCESS;
4710:
4711: EGO_IMPORT_PVT.Resolve_SSXRef_On_Data_Load
4712: ( p_data_set_id => p_batch_id
4713: , p_commit => FND_API.G_TRUE
4714: );
4715:
4716: EXCEPTION
4717: WHEN OTHERS THEN

Line 4719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4715:
4716: EXCEPTION
4717: WHEN OTHERS THEN
4718: l_err_text := SUBSTRB(SQLERRM, 1,240);
4719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4720: EGO_ITEM_MSG.Add_Error_Message ( EGO_ITEM_PVT.G_ITEM_INDX,
4721: 'EGO', 'EGO_ITEM_UNEXPECTED_ERROR',
4722: 'PACKAGE_NAME', G_PKG_NAME, FALSE,
4723: 'PROCEDURE_NAME', l_api_name, FALSE,