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 178: RAISE FND_API.G_EXC_ERROR;

174: -- serial_tagging enh -- bug 9913552
175: invpagi2.G_copy_item_id:=p_Item_Tbl(l_tab_index).copy_inventory_item_Id;
176:
177: IF x_return_status = G_RET_STS_ERROR THEN
178: RAISE FND_API.G_EXC_ERROR;
179: ELSIF x_return_status = G_RET_STS_UNEXP_ERROR THEN
180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
181: END IF;
182:

Line 180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

176:
177: IF x_return_status = G_RET_STS_ERROR THEN
178: RAISE FND_API.G_EXC_ERROR;
179: ELSIF x_return_status = G_RET_STS_UNEXP_ERROR THEN
180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
181: END IF;
182:
183: END IF;
184:

Line 208: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN

204: x_return_status := l_return_status;
205: x_Item_Tbl := EGO_Item_PVT.G_Item_Tbl;
206:
207: EXCEPTION
208: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
209: x_return_status := G_RET_STS_UNEXP_ERROR;
210: WHEN others THEN
211: x_return_status := G_RET_STS_UNEXP_ERROR;
212: EGO_Item_Msg.Add_Error_Message ( EGO_Item_PVT.G_Item_indx, 'INV', 'INV_ITEM_UNEXPECTED_ERROR',

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

405: , p_New_Segment20
406: , l_Item_Tbl
407: , l_return_status);
408:
409: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
410: x_msg_count := NVL(x_msg_count,0)+1; --Bug:3947619
411: END IF;
412:
413: END IF;

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

411: END IF;
412:
413: END IF;
414:
415: IF (l_return_status IN (FND_API.G_RET_STS_SUCCESS,G_MISS_CHAR) ) THEN
416: EGO_Item_PUB.Process_Items(
417: p_api_version => 1.0
418: , p_init_msg_list => p_init_msg_list
419: , p_commit => p_commit

Line 934: IF NOT FND_API.Compatible_API_Call (l_api_version,

930: -- Bug 9852661
931:
932: BEGIN
933: -- standard check for API validation
934: IF NOT FND_API.Compatible_API_Call (l_api_version,
935: p_api_version,
936: l_api_name,
937: G_PKG_NAME)
938: THEN

Line 939: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

935: p_api_version,
936: l_api_name,
937: G_PKG_NAME)
938: THEN
939: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
940: END IF;
941:
942: -- create save point
943: IF FND_API.To_Boolean(p_commit) THEN

Line 943: IF FND_API.To_Boolean(p_commit) THEN

939: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
940: END IF;
941:
942: -- create save point
943: IF FND_API.To_Boolean(p_commit) THEN
944: SAVEPOINT Process_Item_Scalar;
945: END IF;
946:
947: -- Initialize message list

Line 948: IF FND_API.To_Boolean(p_init_msg_list) THEN

944: SAVEPOINT Process_Item_Scalar;
945: END IF;
946:
947: -- Initialize message list
948: IF FND_API.To_Boolean(p_init_msg_list) THEN
949: FND_MSG_PUB.Initialize;
950: END IF;
951:
952: -- Set business object identifier in the System Information record

Line 976: RAISE FND_API.G_EXC_ERROR;

972: -- serial_tagging enh -- bug 9913552
973: invpagi2.G_copy_item_id:=p_copy_inventory_item_Id;
974:
975: IF x_return_status = G_RET_STS_ERROR THEN
976: RAISE FND_API.G_EXC_ERROR;
977: ELSIF x_return_status = G_RET_STS_UNEXP_ERROR THEN
978: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
979: END IF;
980: END IF;

Line 978: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

974:
975: IF x_return_status = G_RET_STS_ERROR THEN
976: RAISE FND_API.G_EXC_ERROR;
977: ELSIF x_return_status = G_RET_STS_UNEXP_ERROR THEN
978: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
979: END IF;
980: END IF;
981:
982: IF p_Template_Id IS NOT NULL

Line 998: RAISE FND_API.G_EXC_ERROR;

994:
995: l_template_applied := TRUE;
996:
997: IF x_return_status = G_RET_STS_ERROR THEN
998: RAISE FND_API.G_EXC_ERROR;
999: ELSIF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1000: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1001: END IF;
1002: END IF;

Line 1000: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

996:
997: IF x_return_status = G_RET_STS_ERROR THEN
998: RAISE FND_API.G_EXC_ERROR;
999: ELSIF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1000: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1001: END IF;
1002: END IF;
1003: END IF;
1004:

Line 1030: IF FND_API.To_Boolean(p_commit) THEN

1026: p_entity_index => 1
1027: ,p_application_short_name => 'EGO'
1028: ,p_message_name => 'EGO_REQUERY_ITEM_INFO'
1029: );
1030: IF FND_API.To_Boolean(p_commit) THEN
1031: ROLLBACK TO Process_Item_Scalar;
1032: END IF;
1033: x_msg_count := 1;
1034: RETURN;

Line 1058: RAISE FND_API.G_EXC_ERROR;

1054: ,x_return_status => x_return_status
1055: ,x_msg_count => x_msg_count);
1056:
1057: IF x_return_status = G_RET_STS_ERROR THEN
1058: RAISE FND_API.G_EXC_ERROR;
1059: ELSIF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1060: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1061: END IF;
1062: END IF;

Line 1060: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1056:
1057: IF x_return_status = G_RET_STS_ERROR THEN
1058: RAISE FND_API.G_EXC_ERROR;
1059: ELSIF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1060: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1061: END IF;
1062: END IF;
1063:
1064: --During CREATE COPY_ITEM/TEMPLATE are applicable for NPR Catalog

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

1105: ,x_Item_Tbl => l_item_created_tbl
1106: ,x_return_status => x_return_status);
1107:
1108: --Bug: 3947619 incrementing the msg count if error message were logged
1109: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1110: x_msg_count := NVL(x_msg_count,0)+1;
1111: END IF;
1112: END IF;
1113: -- end bug 14739246

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

1112: END IF;
1113: -- end bug 14739246
1114: */
1115:
1116: IF NVL(x_return_status,FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS AND
1117: p_transaction_type IN (G_TTYPE_CREATE, G_TTYPE_UPDATE) THEN
1118:
1119: l_item_tbl(indx).item_number := p_item_number;
1120: l_item_tbl(indx).segment1 := p_segment1;

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

1608: INV_EGO_REVISION_VALIDATE.Set_Process_Control(NULL);
1609:
1610: l_item_created_tbl := EGO_Item_PVT.G_Item_Tbl;
1611:
1612: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND l_item_tbl(indx).process_item_record = 1 THEN
1613:
1614: x_inventory_item_id := l_item_created_tbl(indx).inventory_item_id;
1615: x_organization_id := l_item_created_tbl(indx).organization_id;
1616:

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

1633: ,p_approval_status => l_approval_status );
1634: END IF;
1635: END IF;
1636:
1637: END IF; -- x_return_status = FND_API.G_RET_STS_SUCCESS from IOI
1638:
1639: ELSIF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1640:
1641: FND_MESSAGE.Set_Name ('EGO', 'EGO_PROGRAM_NOT_IMPLEMENTED');

Line 1639: ELSIF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1635: END IF;
1636:
1637: END IF; -- x_return_status = FND_API.G_RET_STS_SUCCESS from IOI
1638:
1639: ELSIF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1640:
1641: FND_MESSAGE.Set_Name ('EGO', 'EGO_PROGRAM_NOT_IMPLEMENTED');
1642: FND_MSG_PUB.Add;
1643: RAISE FND_API.G_EXC_ERROR;

Line 1643: RAISE FND_API.G_EXC_ERROR;

1639: ELSIF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1640:
1641: FND_MESSAGE.Set_Name ('EGO', 'EGO_PROGRAM_NOT_IMPLEMENTED');
1642: FND_MSG_PUB.Add;
1643: RAISE FND_API.G_EXC_ERROR;
1644:
1645: END IF; -- TRANSACTION_TYPE IN CREATE/UPDATE
1646:
1647: IF FND_API.To_Boolean(p_commit) THEN

Line 1647: IF FND_API.To_Boolean(p_commit) THEN

1643: RAISE FND_API.G_EXC_ERROR;
1644:
1645: END IF; -- TRANSACTION_TYPE IN CREATE/UPDATE
1646:
1647: IF FND_API.To_Boolean(p_commit) THEN
1648: COMMIT WORK;
1649: END IF;
1650:
1651: --EGO_Item_PVT.Process_Items returns the status which is correct, please donot override that.

Line 1657: WHEN FND_API.G_EXC_ERROR THEN

1653: --Bug 5997870.. Clear the values before returning so that it does not stick around till next call..
1654: Clear_Object_Version_Values;
1655:
1656: EXCEPTION
1657: WHEN FND_API.G_EXC_ERROR THEN
1658: Clear_Object_Version_Values;
1659:
1660: IF FND_API.To_Boolean(p_commit) THEN
1661: ROLLBACK TO Process_Item_Scalar;

Line 1660: IF FND_API.To_Boolean(p_commit) THEN

1656: EXCEPTION
1657: WHEN FND_API.G_EXC_ERROR THEN
1658: Clear_Object_Version_Values;
1659:
1660: IF FND_API.To_Boolean(p_commit) THEN
1661: ROLLBACK TO Process_Item_Scalar;
1662: END IF;
1663: x_return_status := G_RET_STS_ERROR;
1664: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

1660: IF FND_API.To_Boolean(p_commit) THEN
1661: ROLLBACK TO Process_Item_Scalar;
1662: END IF;
1663: x_return_status := G_RET_STS_ERROR;
1664: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
1665: ,p_count => x_msg_count
1666: ,p_data => x_msg_data);
1667: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1668: Clear_Object_Version_Values;

Line 1667: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1663: x_return_status := G_RET_STS_ERROR;
1664: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
1665: ,p_count => x_msg_count
1666: ,p_data => x_msg_data);
1667: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1668: Clear_Object_Version_Values;
1669:
1670: IF FND_API.To_Boolean(p_commit) THEN
1671: ROLLBACK TO Process_Item_Scalar;

Line 1670: IF FND_API.To_Boolean(p_commit) THEN

1666: ,p_data => x_msg_data);
1667: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1668: Clear_Object_Version_Values;
1669:
1670: IF FND_API.To_Boolean(p_commit) THEN
1671: ROLLBACK TO Process_Item_Scalar;
1672: END IF;
1673: x_RETURN_STATUS := G_RET_STS_UNEXP_ERROR;
1674: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

1670: IF FND_API.To_Boolean(p_commit) THEN
1671: ROLLBACK TO Process_Item_Scalar;
1672: END IF;
1673: x_RETURN_STATUS := G_RET_STS_UNEXP_ERROR;
1674: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
1675: ,p_count => x_msg_count
1676: ,p_data => x_msg_data);
1677: WHEN OTHERS THEN
1678: Clear_Object_Version_Values;

Line 1680: IF FND_API.To_Boolean(p_commit) THEN

1676: ,p_data => x_msg_data);
1677: WHEN OTHERS THEN
1678: Clear_Object_Version_Values;
1679:
1680: IF FND_API.To_Boolean(p_commit) THEN
1681: ROLLBACK TO Process_Item_Scalar;
1682: END IF;
1683: x_return_status := G_RET_STS_UNEXP_ERROR;
1684: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

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

1685: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
1686: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
1687: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
1688: FND_MSG_PUB.Add;
1689: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
1690: ,p_count => x_msg_count
1691: ,p_data => x_msg_data);
1692: END Process_Item;
1693:

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

1705: l_return_status VARCHAR2(1) := G_MISS_CHAR;
1706: BEGIN
1707: x_return_status := G_RET_STS_SUCCESS;
1708: -- Check for call compatibility
1709: IF NOT FND_API.Compatible_API_Call ( l_api_version, p_api_version,
1710: l_api_name, G_PKG_NAME )
1711: THEN
1712: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
1713: END IF;

Line 1712: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;

1708: -- Check for call compatibility
1709: IF NOT FND_API.Compatible_API_Call ( l_api_version, p_api_version,
1710: l_api_name, G_PKG_NAME )
1711: THEN
1712: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
1713: END IF;
1714:
1715: -- Initialize message list
1716: IF FND_API.To_Boolean (p_init_msg_list) THEN

Line 1716: IF FND_API.To_Boolean (p_init_msg_list) THEN

1712: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
1713: END IF;
1714:
1715: -- Initialize message list
1716: IF FND_API.To_Boolean (p_init_msg_list) THEN
1717: Error_Handler.Initialize;
1718: END IF;
1719:
1720: -- Set business object identifier in the System Information record

Line 1734: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN

1730:
1731: x_return_status := l_return_status;
1732:
1733: EXCEPTION
1734: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
1735: x_return_status := G_RET_STS_UNEXP_ERROR;
1736: WHEN others THEN
1737: x_return_status := G_RET_STS_UNEXP_ERROR;
1738: EGO_Item_Msg.Add_Error_Message ( EGO_Item_PVT.G_Item_Org_indx, 'INV', 'INV_ITEM_UNEXPECTED_ERROR',

Line 1878: x_return_status := FND_API.G_RET_STS_ERROR;

1874: ,p_translate2 => FALSE
1875: ,p_token_name3 => 'API_VERSION'
1876: ,p_token_value3 => '1.0'
1877: ,p_translate3 => FALSE);
1878: x_return_status := FND_API.G_RET_STS_ERROR;
1879: END IF;
1880:
1881: ELSE
1882:

Line 2023: x_return_status := FND_API.G_RET_STS_SUCCESS;

2019: x_Item_Tbl(1).segment18 := l_Segment_Rec.segment18;
2020: x_Item_Tbl(1).segment19 := l_Segment_Rec.segment19;
2021: x_Item_Tbl(1).segment20 := l_Segment_Rec.segment20;
2022:
2023: x_return_status := FND_API.G_RET_STS_SUCCESS;
2024:
2025: ELSIF p_Inventory_Item_Id <> l_Item_Id THEN
2026:
2027: EGO_Item_Msg.Add_Error_Message (

Line 2032: x_return_status := FND_API.G_RET_STS_ERROR;

2028: p_entity_index => 1
2029: ,p_application_short_name => 'INV'
2030: ,p_message_name => 'INV_DUPL_ORG_ITEM_SEG');
2031:
2032: x_return_status := FND_API.G_RET_STS_ERROR;
2033: ELSE
2034: --Segments are same not updated
2035: x_return_status := FND_API.G_RET_STS_SUCCESS;
2036: END IF;

Line 2035: x_return_status := FND_API.G_RET_STS_SUCCESS;

2031:
2032: x_return_status := FND_API.G_RET_STS_ERROR;
2033: ELSE
2034: --Segments are same not updated
2035: x_return_status := FND_API.G_RET_STS_SUCCESS;
2036: END IF;
2037:
2038: END Update_Item_Number;
2039:

Line 2062: IF FND_API.To_Boolean(p_commit) THEN

2058: ,x_errorcode => x_errorcode
2059: ,x_msg_count => x_msg_count
2060: ,x_msg_data => x_msg_data);
2061:
2062: IF FND_API.To_Boolean(p_commit) THEN
2063: COMMIT WORK;
2064: END IF;
2065:
2066: END Seed_Item_Long_Desc_Attr_Group;

Line 2084: IF FND_API.To_Boolean(p_commit) THEN

2080: ,x_return_status => x_return_status
2081: ,x_msg_data => x_msg_data
2082: );
2083:
2084: IF FND_API.To_Boolean(p_commit) THEN
2085: COMMIT WORK;
2086: END IF;
2087:
2088: END Seed_Item_Long_Desc_In_Bulk;

Line 2101: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE

2097: ,p_entity_id IN NUMBER DEFAULT NULL
2098: ,p_entity_index IN NUMBER DEFAULT NULL
2099: ,p_entity_code IN VARCHAR2 DEFAULT NULL
2100: ,p_debug_level IN NUMBER DEFAULT 0
2101: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
2102: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
2103: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2104: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
2105: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 2102: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE

2098: ,p_entity_index IN NUMBER DEFAULT NULL
2099: ,p_entity_code IN VARCHAR2 DEFAULT NULL
2100: ,p_debug_level IN NUMBER DEFAULT 0
2101: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
2102: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
2103: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2104: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
2105: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
2106: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 2103: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

2099: ,p_entity_code IN VARCHAR2 DEFAULT NULL
2100: ,p_debug_level IN NUMBER DEFAULT 0
2101: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
2102: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
2103: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2104: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
2105: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
2106: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2107: ,x_failed_row_id_list OUT NOCOPY VARCHAR2

Line 2104: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE

2100: ,p_debug_level IN NUMBER DEFAULT 0
2101: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
2102: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
2103: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2104: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
2105: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
2106: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2107: ,x_failed_row_id_list OUT NOCOPY VARCHAR2
2108: ,x_return_status OUT NOCOPY VARCHAR2

Line 2105: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE

2101: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
2102: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
2103: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2104: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
2105: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
2106: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2107: ,x_failed_row_id_list OUT NOCOPY VARCHAR2
2108: ,x_return_status OUT NOCOPY VARCHAR2
2109: ,x_errorcode OUT NOCOPY NUMBER

Line 2106: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

2102: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
2103: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2104: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
2105: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
2106: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2107: ,x_failed_row_id_list OUT NOCOPY VARCHAR2
2108: ,x_return_status OUT NOCOPY VARCHAR2
2109: ,x_errorcode OUT NOCOPY NUMBER
2110: ,x_msg_count OUT NOCOPY NUMBER

Line 2151: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE

2147: ,p_entity_id IN NUMBER DEFAULT NULL
2148: ,p_entity_index IN NUMBER DEFAULT NULL
2149: ,p_entity_code IN VARCHAR2 DEFAULT NULL
2150: ,p_debug_level IN NUMBER DEFAULT 0
2151: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
2152: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2153: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
2154: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2155: ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE

Line 2152: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

2148: ,p_entity_index IN NUMBER DEFAULT NULL
2149: ,p_entity_code IN VARCHAR2 DEFAULT NULL
2150: ,p_debug_level IN NUMBER DEFAULT 0
2151: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
2152: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2153: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
2154: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2155: ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
2156: ,x_attributes_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE

Line 2153: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE

2149: ,p_entity_code IN VARCHAR2 DEFAULT NULL
2150: ,p_debug_level IN NUMBER DEFAULT 0
2151: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
2152: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2153: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
2154: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2155: ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
2156: ,x_attributes_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
2157: ,x_return_status OUT NOCOPY VARCHAR2

Line 2154: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

2150: ,p_debug_level IN NUMBER DEFAULT 0
2151: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
2152: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2153: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
2154: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2155: ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
2156: ,x_attributes_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
2157: ,x_return_status OUT NOCOPY VARCHAR2
2158: ,x_errorcode OUT NOCOPY NUMBER

Line 2275: IF FND_API.To_Boolean(p_commit) THEN

2271: ,x_return_status => l_event_return_status );
2272: END IF;
2273: -- End 4105841 : Business Event Enhancement
2274:
2275: IF FND_API.To_Boolean(p_commit) THEN
2276: COMMIT WORK;
2277: END IF;
2278:
2279: IF FND_API.To_Boolean(p_commit) THEN

Line 2279: IF FND_API.To_Boolean(p_commit) THEN

2275: IF FND_API.To_Boolean(p_commit) THEN
2276: COMMIT WORK;
2277: END IF;
2278:
2279: IF FND_API.To_Boolean(p_commit) THEN
2280: COMMIT WORK;
2281: END IF;
2282: END Update_Item_Approval_Status;
2283:

Line 3472: IF FND_API.To_Boolean(p_commit) THEN

3468: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
3469: X_MSG_COUNT OUT NOCOPY NUMBER) IS
3470: BEGIN
3471: -- create save point
3472: IF FND_API.To_Boolean(p_commit) THEN
3473: SAVEPOINT Process_Item_Lifecycle;
3474: END IF;
3475:
3476: X_RETURN_STATUS := FND_API.g_RET_STS_SUCCESS;

Line 3476: X_RETURN_STATUS := FND_API.g_RET_STS_SUCCESS;

3472: IF FND_API.To_Boolean(p_commit) THEN
3473: SAVEPOINT Process_Item_Lifecycle;
3474: END IF;
3475:
3476: X_RETURN_STATUS := FND_API.g_RET_STS_SUCCESS;
3477: X_MSG_COUNT := 0;
3478:
3479: IF (P_TRANSACTION_TYPE = G_TTYPE_CREATE) THEN
3480: Create_Item_Lifecycle(

Line 3507: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN

3503: X_MSG_COUNT => X_MSG_COUNT);
3504: END IF;
3505:
3506: EXCEPTION
3507: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
3508: IF FND_API.To_Boolean(p_commit) THEN
3509: ROLLBACK TO Process_Item_Lifecycle;
3510: END IF;
3511: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3508: IF FND_API.To_Boolean(p_commit) THEN

3504: END IF;
3505:
3506: EXCEPTION
3507: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
3508: IF FND_API.To_Boolean(p_commit) THEN
3509: ROLLBACK TO Process_Item_Lifecycle;
3510: END IF;
3511: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
3512: WHEN others THEN

Line 3511: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

3507: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
3508: IF FND_API.To_Boolean(p_commit) THEN
3509: ROLLBACK TO Process_Item_Lifecycle;
3510: END IF;
3511: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
3512: WHEN others THEN
3513: IF FND_API.To_Boolean(p_commit) THEN
3514: ROLLBACK TO Process_Item_Lifecycle;
3515: END IF;

Line 3513: IF FND_API.To_Boolean(p_commit) THEN

3509: ROLLBACK TO Process_Item_Lifecycle;
3510: END IF;
3511: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
3512: WHEN others THEN
3513: IF FND_API.To_Boolean(p_commit) THEN
3514: ROLLBACK TO Process_Item_Lifecycle;
3515: END IF;
3516: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
3517: END Process_Item_Lifecycle;

Line 3516: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

3512: WHEN others THEN
3513: IF FND_API.To_Boolean(p_commit) THEN
3514: ROLLBACK TO Process_Item_Lifecycle;
3515: END IF;
3516: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
3517: END Process_Item_Lifecycle;
3518:
3519: ---------------------------------------------------------------------------
3520: Procedure Create_Item_Lifecycle(

Line 3533: IF FND_API.To_Boolean(p_commit) THEN

3529: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
3530: X_MSG_COUNT OUT NOCOPY NUMBER) IS
3531: BEGIN
3532: -- create save point
3533: IF FND_API.To_Boolean(p_commit) THEN
3534: SAVEPOINT Create_Item_Lifecycle;
3535: END IF;
3536: X_RETURN_STATUS := FND_API.g_RET_STS_SUCCESS;
3537: X_MSG_COUNT := 0;

Line 3536: X_RETURN_STATUS := FND_API.g_RET_STS_SUCCESS;

3532: -- create save point
3533: IF FND_API.To_Boolean(p_commit) THEN
3534: SAVEPOINT Create_Item_Lifecycle;
3535: END IF;
3536: X_RETURN_STATUS := FND_API.g_RET_STS_SUCCESS;
3537: X_MSG_COUNT := 0;
3538:
3539: UPDATE MTL_SYSTEM_ITEMS_B SET LIFECYCLE_ID = P_LIFECYCLE_ID
3540: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID

Line 3563: IF FND_API.To_Boolean(p_commit) THEN

3559: UPDATE MTL_PENDING_ITEM_STATUS SET STATUS_CODE = P_ITEM_STATUS
3560: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
3561: AND ORGANIZATION_ID = P_ORGANIZATION_ID;
3562:
3563: IF FND_API.To_Boolean(p_commit) THEN
3564: COMMIT WORK;
3565: END IF;
3566:
3567: EXCEPTION

Line 3568: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN

3564: COMMIT WORK;
3565: END IF;
3566:
3567: EXCEPTION
3568: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
3569: IF FND_API.To_Boolean(p_commit) THEN
3570: ROLLBACK TO Create_Item_Lifecycle;
3571: END IF;
3572: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3569: IF FND_API.To_Boolean(p_commit) THEN

3565: END IF;
3566:
3567: EXCEPTION
3568: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
3569: IF FND_API.To_Boolean(p_commit) THEN
3570: ROLLBACK TO Create_Item_Lifecycle;
3571: END IF;
3572: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
3573: WHEN others THEN

Line 3572: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 3574: IF FND_API.To_Boolean(p_commit) THEN

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

Line 3577: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 3629: IF FND_API.To_Boolean(p_commit) THEN

3625: L_UPDATE_STATUS_HIS_IND boolean default true;
3626:
3627: BEGIN
3628: -- create save point
3629: IF FND_API.To_Boolean(p_commit) THEN
3630: SAVEPOINT Update_Item_Lifecycle;
3631: END IF;
3632: X_RETURN_STATUS := FND_API.g_RET_STS_SUCCESS;
3633: X_MSG_COUNT := 0;

Line 3632: X_RETURN_STATUS := FND_API.g_RET_STS_SUCCESS;

3628: -- create save point
3629: IF FND_API.To_Boolean(p_commit) THEN
3630: SAVEPOINT Update_Item_Lifecycle;
3631: END IF;
3632: X_RETURN_STATUS := FND_API.g_RET_STS_SUCCESS;
3633: X_MSG_COUNT := 0;
3634:
3635: --Bug 13489639
3636: SELECT MAX(MPIS.status_code) INTO L_CURRENT_STATUS_CODE FROM MTL_PENDING_ITEM_STATUS MPIS WHERE MPIS.INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID AND MPIS.ORGANIZATION_ID = P_ORGANIZATION_ID AND

Line 3820: IF FND_API.To_Boolean(p_commit) THEN

3816: P_ITEM_CATALOG_GROUP_ID => P_CATALOG_GROUP_ID,
3817: X_RETURN_STATUS => X_RETURN_STATUS,
3818: X_MSG_COUNT => X_MSG_COUNT);
3819:
3820: IF FND_API.To_Boolean(p_commit) THEN
3821: COMMIT WORK;
3822: END IF;
3823:
3824: EXCEPTION

Line 3825: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN

3821: COMMIT WORK;
3822: END IF;
3823:
3824: EXCEPTION
3825: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
3826: IF FND_API.To_Boolean(p_commit) THEN
3827: ROLLBACK TO Update_Item_Lifecycle;
3828: END IF;
3829: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3826: IF FND_API.To_Boolean(p_commit) THEN

3822: END IF;
3823:
3824: EXCEPTION
3825: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
3826: IF FND_API.To_Boolean(p_commit) THEN
3827: ROLLBACK TO Update_Item_Lifecycle;
3828: END IF;
3829: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
3830: WHEN others THEN

Line 3829: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

3825: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
3826: IF FND_API.To_Boolean(p_commit) THEN
3827: ROLLBACK TO Update_Item_Lifecycle;
3828: END IF;
3829: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
3830: WHEN others THEN
3831: IF FND_API.To_Boolean(p_commit) THEN
3832: ROLLBACK TO Update_Item_Lifecycle;
3833: END IF;

Line 3831: IF FND_API.To_Boolean(p_commit) THEN

3827: ROLLBACK TO Update_Item_Lifecycle;
3828: END IF;
3829: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
3830: WHEN others THEN
3831: IF FND_API.To_Boolean(p_commit) THEN
3832: ROLLBACK TO Update_Item_Lifecycle;
3833: END IF;
3834: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
3835:

Line 3834: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

3830: WHEN others THEN
3831: IF FND_API.To_Boolean(p_commit) THEN
3832: ROLLBACK TO Update_Item_Lifecycle;
3833: END IF;
3834: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
3835:
3836: END Update_Item_Lifecycle;
3837:
3838: ---------------------------------------------------------------------------

Line 3851: IF FND_API.To_Boolean(p_commit) THEN

3847:
3848: BEGIN
3849:
3850: -- create save point
3851: IF FND_API.To_Boolean(p_commit) THEN
3852: SAVEPOINT Update_Item_Attr_Ext;
3853: END IF;
3854:
3855: X_RETURN_STATUS := FND_API.g_RET_STS_SUCCESS;

Line 3855: X_RETURN_STATUS := FND_API.g_RET_STS_SUCCESS;

3851: IF FND_API.To_Boolean(p_commit) THEN
3852: SAVEPOINT Update_Item_Attr_Ext;
3853: END IF;
3854:
3855: X_RETURN_STATUS := FND_API.g_RET_STS_SUCCESS;
3856: X_MSG_COUNT := 0;
3857:
3858: IF (P_ITEM_CATALOG_GROUP_ID IS NULL) THEN --delete query changed by absinha for Bug 3542129
3859: DELETE FROM EGO_MTL_SY_ITEMS_EXT_B WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID

Line 3875: IF FND_API.To_Boolean(p_commit) THEN

3871: SET ITEM_CATALOG_GROUP_ID = P_ITEM_CATALOG_GROUP_ID
3872: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID;
3873: END IF;
3874:
3875: IF FND_API.To_Boolean(p_commit) THEN
3876: COMMIT WORK;
3877: END IF;
3878:
3879: EXCEPTION

Line 3880: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN

3876: COMMIT WORK;
3877: END IF;
3878:
3879: EXCEPTION
3880: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
3881: IF FND_API.To_Boolean(p_commit) THEN
3882: ROLLBACK TO Update_Item_Attr_Ext;
3883: END IF;
3884: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3881: IF FND_API.To_Boolean(p_commit) THEN

3877: END IF;
3878:
3879: EXCEPTION
3880: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
3881: IF FND_API.To_Boolean(p_commit) THEN
3882: ROLLBACK TO Update_Item_Attr_Ext;
3883: END IF;
3884: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
3885: WHEN others THEN

Line 3884: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

3880: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
3881: IF FND_API.To_Boolean(p_commit) THEN
3882: ROLLBACK TO Update_Item_Attr_Ext;
3883: END IF;
3884: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
3885: WHEN others THEN
3886: IF FND_API.To_Boolean(p_commit) THEN
3887: ROLLBACK TO Update_Item_Attr_Ext;
3888: END IF;

Line 3886: IF FND_API.To_Boolean(p_commit) THEN

3882: ROLLBACK TO Update_Item_Attr_Ext;
3883: END IF;
3884: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
3885: WHEN others THEN
3886: IF FND_API.To_Boolean(p_commit) THEN
3887: ROLLBACK TO Update_Item_Attr_Ext;
3888: END IF;
3889: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
3890: END Update_Item_Attr_Ext;

Line 3889: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

3885: WHEN others THEN
3886: IF FND_API.To_Boolean(p_commit) THEN
3887: ROLLBACK TO Update_Item_Attr_Ext;
3888: END IF;
3889: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
3890: END Update_Item_Attr_Ext;
3891:
3892:
3893: FUNCTION Get_Master_Organization_Id(P_ORGANIZATION_ID IN NUMBER) RETURN NUMBER IS

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

4124:
4125: x_return_status := G_RET_STS_SUCCESS;
4126:
4127: -- Check for call compatibility
4128: IF NOT FND_API.Compatible_API_Call ( l_api_version, p_api_version,
4129: l_api_name, G_PKG_NAME )
4130: THEN
4131: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
4132: END IF;

Line 4131: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;

4127: -- Check for call compatibility
4128: IF NOT FND_API.Compatible_API_Call ( l_api_version, p_api_version,
4129: l_api_name, G_PKG_NAME )
4130: THEN
4131: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
4132: END IF;
4133:
4134: l_pk_column_name_value_pairs :=
4135: EGO_COL_NAME_VALUE_PAIR_ARRAY

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

4543:
4544: ---------------------------------------------------------------------------
4545: PROCEDURE Process_Item_Revision(
4546: p_api_version IN NUMBER
4547: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
4548: ,p_commit IN VARCHAR2 DEFAULT G_FALSE
4549: ,p_transaction_type IN VARCHAR2
4550: ,p_inventory_item_id IN NUMBER DEFAULT G_MISS_NUM
4551: ,p_item_number IN VARCHAR2 DEFAULT G_MISS_CHAR

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

4595: INVALID_ITEM_ORG EXCEPTION;
4596:
4597: BEGIN
4598:
4599: IF NOT FND_API.Compatible_API_Call ( l_api_version, p_api_version,
4600: l_api_name, G_PKG_NAME )
4601: THEN
4602: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
4603: END IF;

Line 4602: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;

4598:
4599: IF NOT FND_API.Compatible_API_Call ( l_api_version, p_api_version,
4600: l_api_name, G_PKG_NAME )
4601: THEN
4602: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
4603: END IF;
4604:
4605: BEGIN
4606: IF p_organization_id IS NULL THEN

Line 4690: x_return_status := FND_API.g_RET_STS_ERROR;

4686: EXCEPTION
4687: WHEN INVALID_ORG THEN
4688: FND_MESSAGE.Set_Name('EGO', 'EGO_INVALID_ORGANIZATION');
4689: FND_MSG_PUB.Add;
4690: x_return_status := FND_API.g_RET_STS_ERROR;
4691: WHEN INVALID_ITEM THEN
4692: FND_MESSAGE.Set_Name('EGO', 'EGO_INVALID_ITEM');
4693: FND_MSG_PUB.Add;
4694: x_return_status := FND_API.g_RET_STS_ERROR;

Line 4694: x_return_status := FND_API.g_RET_STS_ERROR;

4690: x_return_status := FND_API.g_RET_STS_ERROR;
4691: WHEN INVALID_ITEM THEN
4692: FND_MESSAGE.Set_Name('EGO', 'EGO_INVALID_ITEM');
4693: FND_MSG_PUB.Add;
4694: x_return_status := FND_API.g_RET_STS_ERROR;
4695: WHEN INVALID_ITEM_ORG THEN
4696: FND_MESSAGE.Set_Name('EGO', 'EGO_INVALID_ITEM_ORGANIZATION');
4697: FND_MSG_PUB.Add;
4698: x_return_status := FND_API.g_RET_STS_ERROR;

Line 4698: x_return_status := FND_API.g_RET_STS_ERROR;

4694: x_return_status := FND_API.g_RET_STS_ERROR;
4695: WHEN INVALID_ITEM_ORG THEN
4696: FND_MESSAGE.Set_Name('EGO', 'EGO_INVALID_ITEM_ORGANIZATION');
4697: FND_MSG_PUB.Add;
4698: x_return_status := FND_API.g_RET_STS_ERROR;
4699: WHEN OTHERS THEN
4700: x_return_status := G_RET_STS_UNEXP_ERROR;
4701: RAISE;
4702: END Process_Item_Revision;

Line 4731: IF FND_API.To_Boolean (p_init_msg_list) THEN

4727:
4728: x_return_status := G_RET_STS_SUCCESS;
4729:
4730: -- Initialize message list
4731: IF FND_API.To_Boolean (p_init_msg_list) THEN
4732: Error_Handler.Initialize;
4733: END IF;
4734:
4735: -- Set business object identifier in the System Information record

Line 4759: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;

4755:
4756: EXCEPTION
4757: WHEN others THEN
4758: l_err_text := SUBSTRB(SQLERRM, 1,240);
4759: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;
4760: EGO_Item_Msg.Add_Error_Message ( EGO_Item_PVT.G_Item_indx,
4761: 'INV', 'INV_ITEM_UNEXPECTED_ERROR',
4762: 'PACKAGE_NAME', G_PKG_NAME, FALSE,
4763: 'PROCEDURE_NAME', l_api_name, FALSE,

Line 4802: IF FND_API.To_Boolean (p_init_msg_list) THEN

4798:
4799: x_return_status := G_RET_STS_SUCCESS;
4800:
4801: -- Initialize message list
4802: IF FND_API.To_Boolean (p_init_msg_list) THEN
4803: Error_Handler.Initialize;
4804: END IF;
4805:
4806: -- Set business object identifier in the System Information record

Line 4819: RAISE FND_API.g_EXC_ERROR;

4815: THEN
4816: EGO_Item_Msg.Add_Error_Message (p_Entity_Index => EGO_Item_PVT.G_Item_indx,
4817: p_Application_Short_Name =>'INV',
4818: p_Message_Name =>'INV_IOI_ITEM_UPDATE_PRIV');
4819: RAISE FND_API.g_EXC_ERROR;
4820: ELSE
4821: IF p_transaction_type = G_TTYPE_CREATE THEN
4822: INV_ITEM_CATEGORY_PUB.Create_Category_Assignment
4823: (

Line 4876: WHEN FND_API.G_EXC_ERROR THEN

4872: END IF;
4873: END IF;
4874:
4875: EXCEPTION
4876: WHEN FND_API.G_EXC_ERROR THEN
4877: x_return_status := FND_API.G_RET_STS_ERROR;
4878: FND_MSG_PUB.Count_And_Get
4879: ( p_count => x_msg_count,
4880: p_data => x_msg_data

Line 4877: x_return_status := FND_API.G_RET_STS_ERROR;

4873: END IF;
4874:
4875: EXCEPTION
4876: WHEN FND_API.G_EXC_ERROR THEN
4877: x_return_status := FND_API.G_RET_STS_ERROR;
4878: FND_MSG_PUB.Count_And_Get
4879: ( p_count => x_msg_count,
4880: p_data => x_msg_data
4881: );

Line 4884: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;

4880: p_data => x_msg_data
4881: );
4882: WHEN others THEN
4883: l_err_text := SUBSTRB(SQLERRM, 1,240);
4884: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;
4885: EGO_Item_Msg.Add_Error_Message ( EGO_Item_PVT.G_Item_indx,
4886: 'INV', 'INV_ITEM_UNEXPECTED_ERROR',
4887: 'PACKAGE_NAME', G_PKG_NAME, FALSE,
4888: 'PROCEDURE_NAME', l_api_name, FALSE,

Line 4910: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE

4906: ,p_multi_row_attrs_table IN UCCnet_Attrs_Multi_Row_Tbl_Typ
4907: ,p_entity_id IN NUMBER DEFAULT NULL
4908: ,p_entity_index IN NUMBER DEFAULT NULL
4909: ,p_entity_code IN VARCHAR2 DEFAULT NULL
4910: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
4911: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
4912: ,x_return_status OUT NOCOPY VARCHAR2
4913: ,x_errorcode OUT NOCOPY NUMBER
4914: ,x_msg_count OUT NOCOPY NUMBER

Line 4911: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

4907: ,p_entity_id IN NUMBER DEFAULT NULL
4908: ,p_entity_index IN NUMBER DEFAULT NULL
4909: ,p_entity_code IN VARCHAR2 DEFAULT NULL
4910: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
4911: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
4912: ,x_return_status OUT NOCOPY VARCHAR2
4913: ,x_errorcode OUT NOCOPY NUMBER
4914: ,x_msg_count OUT NOCOPY NUMBER
4915: ,x_msg_data OUT NOCOPY VARCHAR2) IS

Line 4983: , p_commit => FND_API.G_TRUE

4979: x_return_status := G_RET_STS_SUCCESS;
4980:
4981: EGO_IMPORT_PVT.Resolve_SSXRef_On_Data_Load
4982: ( p_data_set_id => p_batch_id
4983: , p_commit => FND_API.G_TRUE
4984: );
4985:
4986: EXCEPTION
4987: WHEN OTHERS THEN

Line 4989: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4985:
4986: EXCEPTION
4987: WHEN OTHERS THEN
4988: l_err_text := SUBSTRB(SQLERRM, 1,240);
4989: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4990: EGO_ITEM_MSG.Add_Error_Message ( EGO_ITEM_PVT.G_ITEM_INDX,
4991: 'EGO', 'EGO_ITEM_UNEXPECTED_ERROR',
4992: 'PACKAGE_NAME', G_PKG_NAME, FALSE,
4993: 'PROCEDURE_NAME', l_api_name, FALSE,