APPS.MTL_CROSS_REFERENCES_PVT dependencies on MTL_CROSS_REFERENCES_PVT

Line 1: PACKAGE BODY mtl_cross_references_pvt AS

1: PACKAGE BODY mtl_cross_references_pvt AS
2: /* $Header: INVVXRFB.pls 120.16.12020000.2 2012/10/03 11:44:28 ccsingh ship $ */
3:
4: -------------------------------------------------------------------------
5: -- Debug Profile option used to write Error_Handler.Write_Debug --

Line 136: SAVEPOINT MTL_CROSS_REFERENCES_PVT;

132: PRAGMA EXCEPTION_INIT (resource_busy, -54);
133:
134: BEGIN
135:
136: SAVEPOINT MTL_CROSS_REFERENCES_PVT;
137: X_return_status:= FND_API.G_RET_STS_SUCCESS ;
138:
139: l_gtin_msg_count := 0;
140:

Line 1151: ROLLBACK TO MTL_CROSS_REFERENCES_PVT; -- rolling back to savepoint

1147: WHEN VALIDATION_ERROR THEN
1148: X_return_status:= FND_API.g_RET_STS_ERROR;
1149: l_msg_count := l_msg_count +1;
1150: Error_Handler.Get_Entity_Message(G_Entity_Code, x_message_list);
1151: ROLLBACK TO MTL_CROSS_REFERENCES_PVT; -- rolling back to savepoint
1152:
1153: WHEN UNEXP_VALIDATION_ERROR THEN
1154: X_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
1155: l_msg_count := l_msg_count +1;

Line 1157: ROLLBACK TO MTL_CROSS_REFERENCES_PVT; -- rolling back to savepoint

1153: WHEN UNEXP_VALIDATION_ERROR THEN
1154: X_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
1155: l_msg_count := l_msg_count +1;
1156: Error_Handler.Get_Entity_Message(G_Entity_Code, x_message_list);
1157: ROLLBACK TO MTL_CROSS_REFERENCES_PVT; -- rolling back to savepoint
1158:
1159: WHEN resource_busy THEN
1160: Error_Handler.Add_Error_Message
1161: (

Line 1200: ROLLBACK TO MTL_CROSS_REFERENCES_PVT; -- rolling back to savepoint

1196: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;
1197: X_return_status:= FND_API.g_RET_STS_ERROR;
1198: l_msg_count := l_msg_count +1;
1199: Error_Handler.Get_Entity_Message(G_Entity_Code, x_message_list);
1200: ROLLBACK TO MTL_CROSS_REFERENCES_PVT; -- rolling back to savepoint
1201:
1202: END; -- internal begin
1203: END LOOP; -- p_XRef_Tbl
1204:

Line 1966: Write_Debug('Calling MTL_CROSS_REFERENCES_PVT.Process_Xref for Transaction ' ||To_Char(l_mtl_xref_rec.Transaction_Id));

1962: l_XRef_Rec.LAST_UPDATE_LOGIN := l_mtl_xref_rec.LAST_UPDATE_LOGIN;
1963:
1964: l_XRef_Tbl(1) := l_XRef_Rec;
1965:
1966: Write_Debug('Calling MTL_CROSS_REFERENCES_PVT.Process_Xref for Transaction ' ||To_Char(l_mtl_xref_rec.Transaction_Id));
1967:
1968: MTL_CROSS_REFERENCES_PVT.Process_Xref
1969: (p_init_msg_list => FND_API.G_TRUE
1970: ,p_commit => FND_API.G_TRUE

Line 1968: MTL_CROSS_REFERENCES_PVT.Process_Xref

1964: l_XRef_Tbl(1) := l_XRef_Rec;
1965:
1966: Write_Debug('Calling MTL_CROSS_REFERENCES_PVT.Process_Xref for Transaction ' ||To_Char(l_mtl_xref_rec.Transaction_Id));
1967:
1968: MTL_CROSS_REFERENCES_PVT.Process_Xref
1969: (p_init_msg_list => FND_API.G_TRUE
1970: ,p_commit => FND_API.G_TRUE
1971: ,p_XRef_Tbl => l_XRef_Tbl
1972: ,x_return_status => l_return_status

Line 2065: INVPUTLI.info('mtl_cross_references_pvt.LOG_ERROR: msg_name = '||msg_name);

2061:
2062: BEGIN
2063:
2064: IF l_inv_debug_level IN(101, 102) THEN
2065: INVPUTLI.info('mtl_cross_references_pvt.LOG_ERROR: msg_name = '||msg_name);
2066: END IF;
2067:
2068:
2069: INSERT INTO mtl_interface_errors

Line 2133: err_text := SUBSTRB('mtl_cross_references_pvt.LOG_ERROR: ' || SQLERRM, 1,240);

2129:
2130: EXCEPTION
2131:
2132: WHEN others THEN
2133: err_text := SUBSTRB('mtl_cross_references_pvt.LOG_ERROR: ' || SQLERRM, 1,240);
2134: RETURN (SQLCODE);
2135:
2136: END LOG_ERROR;
2137:

Line 2177: err_text := SUBSTR('MTL_CROSS_REFERENCES_PVT.Del_Processed_Recs' || SQLERRM, 1,240);

2173:
2174: EXCEPTION
2175:
2176: WHEN OTHERS THEN
2177: err_text := SUBSTR('MTL_CROSS_REFERENCES_PVT.Del_Processed_Recs' || SQLERRM, 1,240);
2178: RETURN (SQLCODE);
2179:
2180: END Del_Processed_Recs;
2181:

Line 2182: END MTL_CROSS_REFERENCES_PVT;

2178: RETURN (SQLCODE);
2179:
2180: END Del_Processed_Recs;
2181:
2182: END MTL_CROSS_REFERENCES_PVT;