31:
32: ---------------------------------------------------------------
33: -- API Return Status . --
34: ---------------------------------------------------------------
35: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
36: G_RET_STS_WARNING CONSTANT VARCHAR2(1) := 'W';
37: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
38: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
39:
33: -- API Return Status . --
34: ---------------------------------------------------------------
35: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
36: G_RET_STS_WARNING CONSTANT VARCHAR2(1) := 'W';
37: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
38: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
39:
40: ---------------------------------------------------------------
41: -- Used for Error Reporting. --
34: ---------------------------------------------------------------
35: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
36: G_RET_STS_WARNING CONSTANT VARCHAR2(1) := 'W';
37: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
38: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
39:
40: ---------------------------------------------------------------
41: -- Used for Error Reporting. --
42: ---------------------------------------------------------------
254: BEGIN
255: ----------------------------------------------------------------
256: -- Open the Debug Log Session, only if Profile is set to TRUE --
257: ----------------------------------------------------------------
258: IF (G_DEBUG = 1 OR FND_API.to_Boolean(p_debug_flag)) THEN
259:
260:
261: G_OUTPUT_DIR := p_output_dir ;
262: G_ERROR_FILE_NAME := p_file_name ;
856:
857:
858: PROCEDURE WRITE_MSG_TO_INTF_TBL
859: ( p_api_version IN NUMBER
860: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
861: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
862: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
863: , x_return_status OUT NOCOPY VARCHAR2
864: , x_msg_count OUT NOCOPY NUMBER
857:
858: PROCEDURE WRITE_MSG_TO_INTF_TBL
859: ( p_api_version IN NUMBER
860: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
861: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
862: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
863: , x_return_status OUT NOCOPY VARCHAR2
864: , x_msg_count OUT NOCOPY NUMBER
865: , x_msg_data OUT NOCOPY VARCHAR2
858: PROCEDURE WRITE_MSG_TO_INTF_TBL
859: ( p_api_version IN NUMBER
860: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
861: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
862: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
863: , x_return_status OUT NOCOPY VARCHAR2
864: , x_msg_count OUT NOCOPY NUMBER
865: , x_msg_data OUT NOCOPY VARCHAR2
866: , p_api_caller IN VARCHAR2 := NULL
863: , x_return_status OUT NOCOPY VARCHAR2
864: , x_msg_count OUT NOCOPY NUMBER
865: , x_msg_data OUT NOCOPY VARCHAR2
866: , p_api_caller IN VARCHAR2 := NULL
867: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE
868: , p_output_dir IN VARCHAR2 := NULL
869: , p_debug_filename IN VARCHAR2 := NULL
870: , p_batch_id IN NUMBER
871: , p_transaction_id IN NUMBER
892: -- Standard Start of API savepoint
893: SAVEPOINT WRITE_MSG_TO_INTF_TBL;
894:
895: -- Standard call to check for call compatibility.
896: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
897: p_api_version ,
898: l_api_name ,
899: G_PKG_NAME )
900: THEN
897: p_api_version ,
898: l_api_name ,
899: G_PKG_NAME )
900: THEN
901: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
902: END IF;
903:
904: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
905: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
900: THEN
901: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
902: END IF;
903:
904: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
905: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
906: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
907:
908:
901: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
902: END IF;
903:
904: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
905: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
906: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
907:
908:
909:
902: END IF;
903:
904: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
905: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
906: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
907:
908:
909:
910: -- Initialize message list if p_init_msg_list is set to TRUE.
907:
908:
909:
910: -- Initialize message list if p_init_msg_list is set to TRUE.
911: IF FND_API.to_Boolean( l_init_msg_list ) THEN
912: FND_MSG_PUB.initialize;
913: END IF;
914:
915: Open_Debug_Session(p_debug, p_output_dir, p_debug_filename) ;
956: -- End of API body.
957:
958:
959: -- Standard check of p_commit.
960: IF FND_API.To_Boolean( p_commit ) THEN
961: COMMIT WORK;
962: END IF;
963:
964: -- Standard call to get message count and if count is 1, get message info.
975: Close_Debug_Session;
976:
977:
978: EXCEPTION
979: WHEN FND_API.G_EXC_ERROR THEN
980: ROLLBACK TO WRITE_MSG_TO_INTF_TBL;
981: x_return_status := G_RET_STS_ERROR ;
982: FND_MSG_PUB.Count_And_Get
983: ( p_count => x_msg_count ,
985: );
986:
987: Close_Debug_Session;
988:
989: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
990: ROLLBACK TO WRITE_MSG_TO_INTF_TBL;
991: x_return_status := G_RET_STS_UNEXP_ERROR ;
992: FND_MSG_PUB.Count_And_Get
993: ( p_count => x_msg_count ,
1027: * Purpose : Perform Validation for Change Import
1028: *********************************************************************/
1029: PROCEDURE VALIDATE_RECORDS
1030: ( p_api_version IN NUMBER
1031: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
1032: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
1033: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
1034: , x_return_status OUT NOCOPY VARCHAR2
1035: , x_msg_count OUT NOCOPY NUMBER
1028: *********************************************************************/
1029: PROCEDURE VALIDATE_RECORDS
1030: ( p_api_version IN NUMBER
1031: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
1032: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
1033: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
1034: , x_return_status OUT NOCOPY VARCHAR2
1035: , x_msg_count OUT NOCOPY NUMBER
1036: , x_msg_data OUT NOCOPY VARCHAR2
1029: PROCEDURE VALIDATE_RECORDS
1030: ( p_api_version IN NUMBER
1031: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
1032: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
1033: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
1034: , x_return_status OUT NOCOPY VARCHAR2
1035: , x_msg_count OUT NOCOPY NUMBER
1036: , x_msg_data OUT NOCOPY VARCHAR2
1037: , p_write_msg_to_intftbl IN VARCHAR2 := NULL -- FND_API.G_FALSE
1033: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
1034: , x_return_status OUT NOCOPY VARCHAR2
1035: , x_msg_count OUT NOCOPY NUMBER
1036: , x_msg_data OUT NOCOPY VARCHAR2
1037: , p_write_msg_to_intftbl IN VARCHAR2 := NULL -- FND_API.G_FALSE
1038: , p_api_caller IN VARCHAR2 := NULL
1039: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE
1040: , p_output_dir IN VARCHAR2 := NULL
1041: , p_debug_filename IN VARCHAR2 := NULL
1035: , x_msg_count OUT NOCOPY NUMBER
1036: , x_msg_data OUT NOCOPY VARCHAR2
1037: , p_write_msg_to_intftbl IN VARCHAR2 := NULL -- FND_API.G_FALSE
1038: , p_api_caller IN VARCHAR2 := NULL
1039: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE
1040: , p_output_dir IN VARCHAR2 := NULL
1041: , p_debug_filename IN VARCHAR2 := NULL
1042: , p_batch_id IN NUMBER
1043: , p_batch_type IN VARCHAR2 := NULL
1079: -- Standard Start of API savepoint
1080: SAVEPOINT VALIDATE_RECORDS;
1081:
1082: -- Standard call to check for call compatibility.
1083: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1084: p_api_version ,
1085: l_api_name ,
1086: G_PKG_NAME )
1087: THEN
1084: p_api_version ,
1085: l_api_name ,
1086: G_PKG_NAME )
1087: THEN
1088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1089: END IF;
1090:
1091:
1092: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
1088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1089: END IF;
1090:
1091:
1092: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
1093: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
1094: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
1095: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
1096: l_msg_process_flag := FALSE ;
1089: END IF;
1090:
1091:
1092: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
1093: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
1094: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
1095: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
1096: l_msg_process_flag := FALSE ;
1097:
1090:
1091:
1092: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
1093: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
1094: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
1095: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
1096: l_msg_process_flag := FALSE ;
1097:
1098:
1091:
1092: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
1093: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
1094: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
1095: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
1096: l_msg_process_flag := FALSE ;
1097:
1098:
1099: -- Initialize message list if l_init_msg_list is set to TRUE.
1096: l_msg_process_flag := FALSE ;
1097:
1098:
1099: -- Initialize message list if l_init_msg_list is set to TRUE.
1100: IF FND_API.to_Boolean( l_init_msg_list ) THEN
1101: FND_MSG_PUB.initialize;
1102: END IF;
1103:
1104: -- Open Debug Session by a give param or profile option.
1176:
1177: END IF ;
1178:
1179:
1180: IF l_validation_level > FND_API.G_VALID_LEVEL_NONE AND
1181: FND_API.to_Boolean(l_write_msg_to_intftbl) AND
1182: l_msg_process_flag
1183: THEN
1184:
1177: END IF ;
1178:
1179:
1180: IF l_validation_level > FND_API.G_VALID_LEVEL_NONE AND
1181: FND_API.to_Boolean(l_write_msg_to_intftbl) AND
1182: l_msg_process_flag
1183: THEN
1184:
1185: Write_Debug('Insert Error Message for the records which is set to CM Process per Change ID value set above validation. . .' );
1278: l_dyn_sql := l_dyn_sql || ' SET INTF.change_id = null ' ;
1279:
1280: -- If validation level is more than None
1281: -- set the process flag to ERROR:3
1282: IF l_validation_level > FND_API.G_VALID_LEVEL_NONE
1283: THEN
1284: l_dyn_sql := l_dyn_sql || ' , INTF.' || l_intf_proc_flag_col(i) || ' = ' || G_PS_ERROR ;
1285: END IF ;
1286:
1305: -- End of API body.
1306:
1307:
1308: -- Standard check of l_commit.
1309: IF FND_API.To_Boolean( l_commit ) THEN
1310: COMMIT WORK;
1311: END IF;
1312:
1313: -- Standard call to get message count and if count is 1, get message info.
1323: Close_Debug_Session;
1324:
1325:
1326: EXCEPTION
1327: WHEN FND_API.G_EXC_ERROR THEN
1328: ROLLBACK TO VALIDATE_RECORDS;
1329: x_return_status := G_RET_STS_ERROR ;
1330: FND_MSG_PUB.Count_And_Get
1331: ( p_count => x_msg_count ,
1334:
1335: Close_Debug_Session;
1336:
1337:
1338: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1339: ROLLBACK TO VALIDATE_RECORDS;
1340: x_return_status := G_RET_STS_UNEXP_ERROR ;
1341: FND_MSG_PUB.Count_And_Get
1342: ( p_count => x_msg_count ,
1855:
1856:
1857: PROCEDURE VALIDATE_GDSN_ATTR_CHGS
1858: ( p_api_version IN NUMBER
1859: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
1860: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
1861: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
1862: , x_return_status OUT NOCOPY VARCHAR2
1863: , x_msg_count OUT NOCOPY NUMBER
1856:
1857: PROCEDURE VALIDATE_GDSN_ATTR_CHGS
1858: ( p_api_version IN NUMBER
1859: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
1860: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
1861: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
1862: , x_return_status OUT NOCOPY VARCHAR2
1863: , x_msg_count OUT NOCOPY NUMBER
1864: , x_msg_data OUT NOCOPY VARCHAR2
1857: PROCEDURE VALIDATE_GDSN_ATTR_CHGS
1858: ( p_api_version IN NUMBER
1859: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
1860: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
1861: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
1862: , x_return_status OUT NOCOPY VARCHAR2
1863: , x_msg_count OUT NOCOPY NUMBER
1864: , x_msg_data OUT NOCOPY VARCHAR2
1865: , p_write_msg_to_intftbl IN VARCHAR2 := NULL -- FND_API.G_FALSE
1861: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
1862: , x_return_status OUT NOCOPY VARCHAR2
1863: , x_msg_count OUT NOCOPY NUMBER
1864: , x_msg_data OUT NOCOPY VARCHAR2
1865: , p_write_msg_to_intftbl IN VARCHAR2 := NULL -- FND_API.G_FALSE
1866: , p_api_caller IN VARCHAR2 := NULL
1867: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE
1868: , p_output_dir IN VARCHAR2 := NULL
1869: , p_debug_filename IN VARCHAR2 := NULL
1863: , x_msg_count OUT NOCOPY NUMBER
1864: , x_msg_data OUT NOCOPY VARCHAR2
1865: , p_write_msg_to_intftbl IN VARCHAR2 := NULL -- FND_API.G_FALSE
1866: , p_api_caller IN VARCHAR2 := NULL
1867: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE
1868: , p_output_dir IN VARCHAR2 := NULL
1869: , p_debug_filename IN VARCHAR2 := NULL
1870: , p_batch_id IN NUMBER
1871: , p_cm_process_type IN VARCHAR2 := NULL
1912: -- Standard Start of API savepoint
1913: SAVEPOINT VALIDATE_GDSN_ATTR_CHGS;
1914:
1915: -- Standard call to check for call compatibility.
1916: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1917: p_api_version ,
1918: l_api_name ,
1919: G_PKG_NAME )
1920: THEN
1917: p_api_version ,
1918: l_api_name ,
1919: G_PKG_NAME )
1920: THEN
1921: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1922: END IF;
1923:
1924:
1925: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
1921: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1922: END IF;
1923:
1924:
1925: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
1926: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
1927: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
1928: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
1929:
1922: END IF;
1923:
1924:
1925: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
1926: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
1927: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
1928: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
1929:
1930:
1923:
1924:
1925: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
1926: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
1927: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
1928: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
1929:
1930:
1931: -- Initialize message list if l_init_msg_list is set to TRUE.
1924:
1925: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
1926: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
1927: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
1928: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
1929:
1930:
1931: -- Initialize message list if l_init_msg_list is set to TRUE.
1932: IF FND_API.to_Boolean( l_init_msg_list ) THEN
1928: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
1929:
1930:
1931: -- Initialize message list if l_init_msg_list is set to TRUE.
1932: IF FND_API.to_Boolean( l_init_msg_list ) THEN
1933: FND_MSG_PUB.initialize;
1934: END IF;
1935:
1936: -- Open Debug Session by a give param or profile option.
1992: ( 'EGO_GTIN_ATTRS_PVT',
1993: 'Get_Gdsn_Intf_Rows' ,
1994: SQLERRM ) ;
1995:
1996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1997:
1998:
1999: END ;
2000:
2019: FOR cnt IN 1..l_msg_count LOOP
2020: Write_Debug('Error msg - '||cnt ||': '|| FND_MSG_PUB.Get(p_msg_index => cnt, p_encoded => 'F'));
2021:
2022: l_msg_text := FND_MSG_PUB.Get(p_msg_index => cnt, p_encoded => 'F');
2023: IF FND_API.to_Boolean(l_write_msg_to_intftbl)
2024: THEN
2025:
2026: Insert_Mtl_Intf_Err
2027: ( p_transaction_id => i.TRANSACTION_ID
2042:
2043: Write_Debug('Unexpected Error msg - '|| l_msg_data);
2044:
2045: l_msg_text := l_msg_data;
2046: IF FND_API.to_Boolean(l_write_msg_to_intftbl)
2047: THEN
2048:
2049: Insert_Mtl_Intf_Err
2050: ( p_transaction_id => i.TRANSACTION_ID
2058: ) ;
2059:
2060: END IF ;
2061:
2062: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2063:
2064:
2065: END IF; -- IF l_msg_count
2066:
2109: ( 'EGO_GTIN_ATTRS_PVT',
2110: 'Validate_Attributes' ,
2111: SQLERRM ) ;
2112:
2113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2114:
2115:
2116: END ;
2117:
2137: Write_Debug('Error msg - '||cnt ||': '|| FND_MSG_PUB.Get(p_msg_index => cnt, p_encoded => 'F'));
2138:
2139: l_msg_text := FND_MSG_PUB.Get(p_msg_index => cnt, p_encoded => 'F');
2140:
2141: IF FND_API.to_Boolean(l_write_msg_to_intftbl)
2142: THEN
2143:
2144: Insert_Mtl_Intf_Err
2145: ( p_transaction_id => i.TRANSACTION_ID
2160:
2161: Write_Debug('Unexpected Error msg - '|| l_msg_data);
2162:
2163: l_msg_text := l_msg_data;
2164: IF FND_API.to_Boolean(l_write_msg_to_intftbl)
2165: THEN
2166:
2167: Insert_Mtl_Intf_Err
2168: ( p_transaction_id => i.TRANSACTION_ID
2176: ) ;
2177:
2178: END IF ;
2179:
2180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2181:
2182:
2183: END IF; -- IF l_msg_count
2184:
2189: -- End of API body.
2190:
2191:
2192: -- Standard check of l_commit.
2193: IF FND_API.To_Boolean( l_commit ) THEN
2194: COMMIT WORK;
2195: END IF;
2196:
2197: -- Standard call to get message count and if count is 1, get message info.
2208: Close_Debug_Session;
2209:
2210:
2211: EXCEPTION
2212: WHEN FND_API.G_EXC_ERROR THEN
2213: ROLLBACK TO VALIDATE_GDSN_ATTR_CHGS;
2214: x_return_status := G_RET_STS_ERROR ;
2215: FND_MSG_PUB.Count_And_Get
2216: ( p_count => x_msg_count ,
2219:
2220:
2221: Close_Debug_Session;
2222:
2223: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2224: ROLLBACK TO VALIDATE_GDSN_ATTR_CHGS;
2225: x_return_status := G_RET_STS_UNEXP_ERROR ;
2226: FND_MSG_PUB.Count_And_Get
2227: ( p_count => x_msg_count ,
2267: -- Parameters :
2268: -- IN : p_api_version IN NUMBER Required
2269: -- p_init_msg_list IN VARCHAR2 Optional
2270: -- Default = NULL
2271: -- FND_API.G_FALSE
2272: -- FND_API.G_TRUE
2273: -- p_commit IN VARCHAR2 Optional
2274: -- Default = NULL
2275: -- FND_API.G_FALSE
2268: -- IN : p_api_version IN NUMBER Required
2269: -- p_init_msg_list IN VARCHAR2 Optional
2270: -- Default = NULL
2271: -- FND_API.G_FALSE
2272: -- FND_API.G_TRUE
2273: -- p_commit IN VARCHAR2 Optional
2274: -- Default = NULL
2275: -- FND_API.G_FALSE
2276: -- FND_API.G_TRUE
2271: -- FND_API.G_FALSE
2272: -- FND_API.G_TRUE
2273: -- p_commit IN VARCHAR2 Optional
2274: -- Default = NULL
2275: -- FND_API.G_FALSE
2276: -- FND_API.G_TRUE
2277: -- p_validation_level IN NUMBER Optional
2278: -- Default = NULL
2279: -- Values:
2272: -- FND_API.G_TRUE
2273: -- p_commit IN VARCHAR2 Optional
2274: -- Default = NULL
2275: -- FND_API.G_FALSE
2276: -- FND_API.G_TRUE
2277: -- p_validation_level IN NUMBER Optional
2278: -- Default = NULL
2279: -- Values:
2280: -- FND_API.G_VALID_LEVEL_NONE 0
2276: -- FND_API.G_TRUE
2277: -- p_validation_level IN NUMBER Optional
2278: -- Default = NULL
2279: -- Values:
2280: -- FND_API.G_VALID_LEVEL_NONE 0
2281: -- FND_API.G_VALID_LEVEL_FULL 100
2282: -- p_write_msg_to_intftbl IN VARCHAR2 Optional
2283: -- Default = NULL
2284: -- FND_API.G_FALSE
2277: -- p_validation_level IN NUMBER Optional
2278: -- Default = NULL
2279: -- Values:
2280: -- FND_API.G_VALID_LEVEL_NONE 0
2281: -- FND_API.G_VALID_LEVEL_FULL 100
2282: -- p_write_msg_to_intftbl IN VARCHAR2 Optional
2283: -- Default = NULL
2284: -- FND_API.G_FALSE
2285: -- FND_API.G_TRUE
2280: -- FND_API.G_VALID_LEVEL_NONE 0
2281: -- FND_API.G_VALID_LEVEL_FULL 100
2282: -- p_write_msg_to_intftbl IN VARCHAR2 Optional
2283: -- Default = NULL
2284: -- FND_API.G_FALSE
2285: -- FND_API.G_TRUE
2286: -- p_api_caller IN VARCHAR2 Optional
2287: --
2288: -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
2281: -- FND_API.G_VALID_LEVEL_FULL 100
2282: -- p_write_msg_to_intftbl IN VARCHAR2 Optional
2283: -- Default = NULL
2284: -- FND_API.G_FALSE
2285: -- FND_API.G_TRUE
2286: -- p_api_caller IN VARCHAR2 Optional
2287: --
2288: -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
2289: -- x_msg_count OUT NOCOPY NUMBER
2293: --
2294: -- Notes : Note text-- API name : POPULATE_MFGPARTNUM_INTF
2295: PROCEDURE POPULATE_MFGPARTNUM_INTF
2296: ( p_api_version IN NUMBER
2297: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
2298: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
2299: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
2300: , x_return_status OUT NOCOPY VARCHAR2
2301: , x_msg_count OUT NOCOPY NUMBER
2294: -- Notes : Note text-- API name : POPULATE_MFGPARTNUM_INTF
2295: PROCEDURE POPULATE_MFGPARTNUM_INTF
2296: ( p_api_version IN NUMBER
2297: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
2298: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
2299: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
2300: , x_return_status OUT NOCOPY VARCHAR2
2301: , x_msg_count OUT NOCOPY NUMBER
2302: , x_msg_data OUT NOCOPY VARCHAR2
2295: PROCEDURE POPULATE_MFGPARTNUM_INTF
2296: ( p_api_version IN NUMBER
2297: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
2298: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
2299: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
2300: , x_return_status OUT NOCOPY VARCHAR2
2301: , x_msg_count OUT NOCOPY NUMBER
2302: , x_msg_data OUT NOCOPY VARCHAR2
2303: , p_write_msg_to_intftbl IN VARCHAR2 := NULL -- FND_API.G_FALSE
2299: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
2300: , x_return_status OUT NOCOPY VARCHAR2
2301: , x_msg_count OUT NOCOPY NUMBER
2302: , x_msg_data OUT NOCOPY VARCHAR2
2303: , p_write_msg_to_intftbl IN VARCHAR2 := NULL -- FND_API.G_FALSE
2304: , p_api_caller IN VARCHAR2 := NULL
2305: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE
2306: , p_output_dir IN VARCHAR2 := NULL
2307: , p_debug_filename IN VARCHAR2 := NULL
2301: , x_msg_count OUT NOCOPY NUMBER
2302: , x_msg_data OUT NOCOPY VARCHAR2
2303: , p_write_msg_to_intftbl IN VARCHAR2 := NULL -- FND_API.G_FALSE
2304: , p_api_caller IN VARCHAR2 := NULL
2305: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE
2306: , p_output_dir IN VARCHAR2 := NULL
2307: , p_debug_filename IN VARCHAR2 := NULL
2308: , p_batch_id IN NUMBER
2309: )
2330: -- Standard Start of API savepoint
2331: SAVEPOINT POPULATE_MFGPARTNUM_INTF;
2332:
2333: -- Standard call to check for call compatibility.
2334: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
2335: p_api_version ,
2336: l_api_name ,
2337: G_PKG_NAME )
2338: THEN
2335: p_api_version ,
2336: l_api_name ,
2337: G_PKG_NAME )
2338: THEN
2339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2340: END IF;
2341:
2342: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
2343: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
2338: THEN
2339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2340: END IF;
2341:
2342: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
2343: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
2344: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
2345: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
2346:
2339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2340: END IF;
2341:
2342: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
2343: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
2344: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
2345: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
2346:
2347:
2340: END IF;
2341:
2342: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
2343: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
2344: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
2345: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
2346:
2347:
2348: -- Initialize message list if l_init_msg_list is set to TRUE.
2341:
2342: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
2343: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
2344: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
2345: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
2346:
2347:
2348: -- Initialize message list if l_init_msg_list is set to TRUE.
2349: IF FND_API.to_Boolean( l_init_msg_list ) THEN
2345: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
2346:
2347:
2348: -- Initialize message list if l_init_msg_list is set to TRUE.
2349: IF FND_API.to_Boolean( l_init_msg_list ) THEN
2350: FND_MSG_PUB.initialize;
2351: END IF;
2352:
2353: -- Open Debug Session by a give param or profile option.
2427:
2428:
2429: EGO_ITEM_AML_GRP.Populate_Intf_With_Proddata (
2430: p_api_version => 1.0
2431: ,p_commit => FND_API.G_FALSE
2432: ,p_data_set_id => p_batch_id
2433: ,p_pf_to_process => G_CM_TO_BE_PROCESSED -- p_pf_to_process
2434: ,p_pf_after_population => G_CM_TO_BE_PROCESSED -- p_pf_after_population
2435: ,x_return_status => l_return_status
2446: x_return_status := l_return_status ;
2447: x_msg_count := l_msg_count ;
2448: x_msg_data := l_msg_data ;
2449:
2450: RAISE FND_API.G_EXC_ERROR ;
2451: END IF ;
2452:
2453:
2454:
2647: -- End of API body.
2648:
2649:
2650: -- Standard check of p_commit.
2651: IF FND_API.To_Boolean( p_commit ) THEN
2652: COMMIT WORK;
2653: END IF;
2654:
2655: -- Standard call to get message count and if count is 1, get message info.
2668: EXCEPTION
2669: WHEN NO_ROWS_IN_INTF_TABLE THEN
2670: NULL;
2671:
2672: WHEN FND_API.G_EXC_ERROR THEN
2673: ROLLBACK TO POPULATE_MFGPARTNUM_INTF;
2674: x_return_status := G_RET_STS_ERROR ;
2675: FND_MSG_PUB.Count_And_Get
2676: ( p_count => x_msg_count ,
2681: -- Close Error Handler Debug Session.
2682: -----------------------------------------------------
2683: Close_Debug_Session;
2684:
2685: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2686: ROLLBACK TO POPULATE_MFGPARTNUM_INTF;
2687: x_return_status := G_RET_STS_UNEXP_ERROR ;
2688: FND_MSG_PUB.Count_And_Get
2689: ( p_count => x_msg_count ,
2732: -- Parameters :
2733: -- IN : p_api_version IN NUMBER Required
2734: -- p_init_msg_list IN VARCHAR2 Optional
2735: -- Default = NULL
2736: -- FND_API.G_FALSE
2737: -- FND_API.G_TRUE
2738: -- p_commit IN VARCHAR2 Optional
2739: -- Default = NULL
2740: -- FND_API.G_FALSE
2733: -- IN : p_api_version IN NUMBER Required
2734: -- p_init_msg_list IN VARCHAR2 Optional
2735: -- Default = NULL
2736: -- FND_API.G_FALSE
2737: -- FND_API.G_TRUE
2738: -- p_commit IN VARCHAR2 Optional
2739: -- Default = NULL
2740: -- FND_API.G_FALSE
2741: -- FND_API.G_TRUE
2736: -- FND_API.G_FALSE
2737: -- FND_API.G_TRUE
2738: -- p_commit IN VARCHAR2 Optional
2739: -- Default = NULL
2740: -- FND_API.G_FALSE
2741: -- FND_API.G_TRUE
2742: -- p_validation_level IN NUMBER Optional
2743: -- Default = NULL
2744: -- Values:
2737: -- FND_API.G_TRUE
2738: -- p_commit IN VARCHAR2 Optional
2739: -- Default = NULL
2740: -- FND_API.G_FALSE
2741: -- FND_API.G_TRUE
2742: -- p_validation_level IN NUMBER Optional
2743: -- Default = NULL
2744: -- Values:
2745: -- FND_API.G_VALID_LEVEL_NONE 0
2741: -- FND_API.G_TRUE
2742: -- p_validation_level IN NUMBER Optional
2743: -- Default = NULL
2744: -- Values:
2745: -- FND_API.G_VALID_LEVEL_NONE 0
2746: -- FND_API.G_VALID_LEVEL_FULL 100
2747: -- p_write_msg_to_intftbl IN VARCHAR2 Optional
2748: -- Default = NULL
2749: -- FND_API.G_FALSE
2742: -- p_validation_level IN NUMBER Optional
2743: -- Default = NULL
2744: -- Values:
2745: -- FND_API.G_VALID_LEVEL_NONE 0
2746: -- FND_API.G_VALID_LEVEL_FULL 100
2747: -- p_write_msg_to_intftbl IN VARCHAR2 Optional
2748: -- Default = NULL
2749: -- FND_API.G_FALSE
2750: -- FND_API.G_TRUE
2745: -- FND_API.G_VALID_LEVEL_NONE 0
2746: -- FND_API.G_VALID_LEVEL_FULL 100
2747: -- p_write_msg_to_intftbl IN VARCHAR2 Optional
2748: -- Default = NULL
2749: -- FND_API.G_FALSE
2750: -- FND_API.G_TRUE
2751: -- p_api_caller IN VARCHAR2 Optional
2752: --
2753: -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
2746: -- FND_API.G_VALID_LEVEL_FULL 100
2747: -- p_write_msg_to_intftbl IN VARCHAR2 Optional
2748: -- Default = NULL
2749: -- FND_API.G_FALSE
2750: -- FND_API.G_TRUE
2751: -- p_api_caller IN VARCHAR2 Optional
2752: --
2753: -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
2754: -- x_msg_count OUT NOCOPY NUMBER
2760: -- Initial version 1.0
2761: --
2762: PROCEDURE POPULATE_EXISTING_CHANGE
2763: ( p_api_version IN NUMBER
2764: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
2765: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
2766: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
2767: , x_return_status OUT NOCOPY VARCHAR2
2768: , x_msg_count OUT NOCOPY NUMBER
2761: --
2762: PROCEDURE POPULATE_EXISTING_CHANGE
2763: ( p_api_version IN NUMBER
2764: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
2765: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
2766: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
2767: , x_return_status OUT NOCOPY VARCHAR2
2768: , x_msg_count OUT NOCOPY NUMBER
2769: , x_msg_data OUT NOCOPY VARCHAR2
2762: PROCEDURE POPULATE_EXISTING_CHANGE
2763: ( p_api_version IN NUMBER
2764: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
2765: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
2766: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
2767: , x_return_status OUT NOCOPY VARCHAR2
2768: , x_msg_count OUT NOCOPY NUMBER
2769: , x_msg_data OUT NOCOPY VARCHAR2
2770: , p_write_msg_to_intftbl IN VARCHAR2 := NULL -- FND_API.G_FALSE
2766: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
2767: , x_return_status OUT NOCOPY VARCHAR2
2768: , x_msg_count OUT NOCOPY NUMBER
2769: , x_msg_data OUT NOCOPY VARCHAR2
2770: , p_write_msg_to_intftbl IN VARCHAR2 := NULL -- FND_API.G_FALSE
2771: , p_api_caller IN VARCHAR2 := NULL
2772: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE
2773: , p_output_dir IN VARCHAR2 := NULL
2774: , p_debug_filename IN VARCHAR2 := NULL
2768: , x_msg_count OUT NOCOPY NUMBER
2769: , x_msg_data OUT NOCOPY VARCHAR2
2770: , p_write_msg_to_intftbl IN VARCHAR2 := NULL -- FND_API.G_FALSE
2771: , p_api_caller IN VARCHAR2 := NULL
2772: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE
2773: , p_output_dir IN VARCHAR2 := NULL
2774: , p_debug_filename IN VARCHAR2 := NULL
2775: , p_batch_id IN NUMBER
2776: , p_change_number IN VARCHAR2 := NULL
2814: -- Standard Start of API savepoint
2815: SAVEPOINT POPULATE_EXISTING_CHANGE;
2816:
2817: -- Standard call to check for call compatibility.
2818: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
2819: p_api_version ,
2820: l_api_name ,
2821: G_PKG_NAME )
2822: THEN
2819: p_api_version ,
2820: l_api_name ,
2821: G_PKG_NAME )
2822: THEN
2823: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2824: END IF;
2825:
2826: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
2827: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
2822: THEN
2823: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2824: END IF;
2825:
2826: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
2827: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
2828: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
2829: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
2830:
2823: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2824: END IF;
2825:
2826: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
2827: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
2828: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
2829: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
2830:
2831:
2824: END IF;
2825:
2826: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
2827: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
2828: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
2829: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
2830:
2831:
2832: -- Initialize message list if p_init_msg_list is set to TRUE.
2825:
2826: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
2827: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
2828: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
2829: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
2830:
2831:
2832: -- Initialize message list if p_init_msg_list is set to TRUE.
2833: IF FND_API.to_Boolean( l_init_msg_list ) THEN
2829: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
2830:
2831:
2832: -- Initialize message list if p_init_msg_list is set to TRUE.
2833: IF FND_API.to_Boolean( l_init_msg_list ) THEN
2834: FND_MSG_PUB.initialize;
2835: END IF;
2836:
2837: -- Open Debug Session by a give param or profile option.
3008:
3009: ---bug fix 13004839 end
3010:
3011:
3012: IF l_validation_level > FND_API.G_VALID_LEVEL_NONE AND
3013: FND_API.to_Boolean(l_write_msg_to_intftbl)
3014: THEN
3015:
3016: Write_Debug('Insert Error Message for the records which can not find CO for the Org. . .' );
3009: ---bug fix 13004839 end
3010:
3011:
3012: IF l_validation_level > FND_API.G_VALID_LEVEL_NONE AND
3013: FND_API.to_Boolean(l_write_msg_to_intftbl)
3014: THEN
3015:
3016: Write_Debug('Insert Error Message for the records which can not find CO for the Org. . .' );
3017:
3088: l_dyn_sql := l_dyn_sql || ' SET INTF.change_id = null ' ;
3089:
3090: -- If validation level is more than None
3091: -- set the process flag to ERROR:3
3092: IF l_validation_level > FND_API.G_VALID_LEVEL_NONE
3093: THEN
3094: l_dyn_sql := l_dyn_sql || ' , INTF.' || l_intf_proc_flag_col(i) || ' = ' || G_PS_ERROR ;
3095: END IF ;
3096:
3130: -- End of API body.
3131:
3132:
3133: -- Standard check of p_commit.
3134: IF FND_API.To_Boolean( p_commit ) THEN
3135: COMMIT WORK;
3136: END IF;
3137:
3138: -- Standard call to get message count and if count is 1, get message info.
3147: Close_Debug_Session;
3148:
3149:
3150: EXCEPTION
3151: WHEN FND_API.G_EXC_ERROR THEN
3152: ROLLBACK TO POPULATE_EXISTING_CHANGE;
3153: x_return_status := G_RET_STS_ERROR ;
3154: FND_MSG_PUB.Count_And_Get
3155: ( p_count => x_msg_count ,
3160: -- Close Error Handler Debug Session.
3161: -----------------------------------------------------
3162: Close_Debug_Session;
3163:
3164: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3165: ROLLBACK TO POPULATE_EXISTING_CHANGE;
3166: x_return_status := G_RET_STS_UNEXP_ERROR ;
3167: FND_MSG_PUB.Count_And_Get
3168: ( p_count => x_msg_count ,
3209: -- Parameters :
3210: -- IN : p_api_version IN NUMBER Required
3211: -- p_init_msg_list IN VARCHAR2 Optional
3212: -- Default = NULL
3213: -- FND_API.G_FALSE
3214: -- FND_API.G_TRUE
3215: -- p_commit IN VARCHAR2 Optional
3216: -- Default = NULL
3217: -- FND_API.G_FALSE
3210: -- IN : p_api_version IN NUMBER Required
3211: -- p_init_msg_list IN VARCHAR2 Optional
3212: -- Default = NULL
3213: -- FND_API.G_FALSE
3214: -- FND_API.G_TRUE
3215: -- p_commit IN VARCHAR2 Optional
3216: -- Default = NULL
3217: -- FND_API.G_FALSE
3218: -- FND_API.G_TRUE
3213: -- FND_API.G_FALSE
3214: -- FND_API.G_TRUE
3215: -- p_commit IN VARCHAR2 Optional
3216: -- Default = NULL
3217: -- FND_API.G_FALSE
3218: -- FND_API.G_TRUE
3219: -- p_validation_level IN NUMBER Optional
3220: -- Default = NULL
3221: -- Values:
3214: -- FND_API.G_TRUE
3215: -- p_commit IN VARCHAR2 Optional
3216: -- Default = NULL
3217: -- FND_API.G_FALSE
3218: -- FND_API.G_TRUE
3219: -- p_validation_level IN NUMBER Optional
3220: -- Default = NULL
3221: -- Values:
3222: -- FND_API.G_VALID_LEVEL_NONE 0
3218: -- FND_API.G_TRUE
3219: -- p_validation_level IN NUMBER Optional
3220: -- Default = NULL
3221: -- Values:
3222: -- FND_API.G_VALID_LEVEL_NONE 0
3223: -- FND_API.G_VALID_LEVEL_FULL 100
3224: -- p_write_msg_to_intftbl IN VARCHAR2 Optional
3225: -- Default = NULL
3226: -- FND_API.G_FALSE
3219: -- p_validation_level IN NUMBER Optional
3220: -- Default = NULL
3221: -- Values:
3222: -- FND_API.G_VALID_LEVEL_NONE 0
3223: -- FND_API.G_VALID_LEVEL_FULL 100
3224: -- p_write_msg_to_intftbl IN VARCHAR2 Optional
3225: -- Default = NULL
3226: -- FND_API.G_FALSE
3227: -- FND_API.G_TRUE
3222: -- FND_API.G_VALID_LEVEL_NONE 0
3223: -- FND_API.G_VALID_LEVEL_FULL 100
3224: -- p_write_msg_to_intftbl IN VARCHAR2 Optional
3225: -- Default = NULL
3226: -- FND_API.G_FALSE
3227: -- FND_API.G_TRUE
3228: -- p_api_caller IN VARCHAR2 Optional
3229: --
3230: -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
3223: -- FND_API.G_VALID_LEVEL_FULL 100
3224: -- p_write_msg_to_intftbl IN VARCHAR2 Optional
3225: -- Default = NULL
3226: -- FND_API.G_FALSE
3227: -- FND_API.G_TRUE
3228: -- p_api_caller IN VARCHAR2 Optional
3229: --
3230: -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
3231: -- x_msg_count OUT NOCOPY NUMBER
3237: -- Initial version 1.0
3238: --
3239: PROCEDURE POPULATE_EXISTING_REV_ITEMS
3240: ( p_api_version IN NUMBER
3241: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
3242: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
3243: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
3244: , x_return_status OUT NOCOPY VARCHAR2
3245: , x_msg_count OUT NOCOPY NUMBER
3238: --
3239: PROCEDURE POPULATE_EXISTING_REV_ITEMS
3240: ( p_api_version IN NUMBER
3241: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
3242: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
3243: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
3244: , x_return_status OUT NOCOPY VARCHAR2
3245: , x_msg_count OUT NOCOPY NUMBER
3246: , x_msg_data OUT NOCOPY VARCHAR2
3239: PROCEDURE POPULATE_EXISTING_REV_ITEMS
3240: ( p_api_version IN NUMBER
3241: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
3242: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
3243: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
3244: , x_return_status OUT NOCOPY VARCHAR2
3245: , x_msg_count OUT NOCOPY NUMBER
3246: , x_msg_data OUT NOCOPY VARCHAR2
3247: , p_write_msg_to_intftbl IN VARCHAR2 := NULL -- FND_API.G_FALSE
3243: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
3244: , x_return_status OUT NOCOPY VARCHAR2
3245: , x_msg_count OUT NOCOPY NUMBER
3246: , x_msg_data OUT NOCOPY VARCHAR2
3247: , p_write_msg_to_intftbl IN VARCHAR2 := NULL -- FND_API.G_FALSE
3248: , p_api_caller IN VARCHAR2 := NULL
3249: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE
3250: , p_output_dir IN VARCHAR2 := NULL
3251: , p_debug_filename IN VARCHAR2 := NULL
3245: , x_msg_count OUT NOCOPY NUMBER
3246: , x_msg_data OUT NOCOPY VARCHAR2
3247: , p_write_msg_to_intftbl IN VARCHAR2 := NULL -- FND_API.G_FALSE
3248: , p_api_caller IN VARCHAR2 := NULL
3249: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE
3250: , p_output_dir IN VARCHAR2 := NULL
3251: , p_debug_filename IN VARCHAR2 := NULL
3252: , p_batch_id IN NUMBER
3253: , p_process_entity IN VARCHAR2 := NULL
3290: -- Standard Start of API savepoint
3291: SAVEPOINT POPULATE_EXISTING_REV_ITEMS;
3292:
3293: -- Standard call to check for call compatibility.
3294: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
3295: p_api_version ,
3296: l_api_name ,
3297: G_PKG_NAME )
3298: THEN
3295: p_api_version ,
3296: l_api_name ,
3297: G_PKG_NAME )
3298: THEN
3299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3300: END IF;
3301:
3302: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
3303: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
3298: THEN
3299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3300: END IF;
3301:
3302: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
3303: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
3304: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
3305: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
3306:
3299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3300: END IF;
3301:
3302: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
3303: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
3304: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
3305: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
3306:
3307:
3300: END IF;
3301:
3302: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
3303: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
3304: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
3305: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
3306:
3307:
3308: -- Initialize message list if p_init_msg_list is set to TRUE.
3301:
3302: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
3303: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
3304: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
3305: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
3306:
3307:
3308: -- Initialize message list if p_init_msg_list is set to TRUE.
3309: IF FND_API.to_Boolean( l_init_msg_list ) THEN
3305: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
3306:
3307:
3308: -- Initialize message list if p_init_msg_list is set to TRUE.
3309: IF FND_API.to_Boolean( l_init_msg_list ) THEN
3310: FND_MSG_PUB.initialize;
3311: END IF;
3312:
3313: -- Open Debug Session by a give param or profile option.
3385: END IF ;
3386:
3387:
3388: -- param: p_default_seq_id
3389: IF l_validation_level > FND_API.G_VALID_LEVEL_NONE
3390: THEN
3391: l_dyn_sql := l_dyn_sql || ', -100';
3392: ELSE
3393: l_dyn_sql := l_dyn_sql || ', TO_NUMBER(null)';
3411:
3412: EXECUTE IMMEDIATE l_dyn_sql USING p_batch_id ;
3413:
3414:
3415: IF l_validation_level > FND_API.G_VALID_LEVEL_NONE
3416: THEN
3417: -- Initialize message list if p_init_msg_list is set to TRUE.
3418: IF FND_API.to_Boolean(l_write_msg_to_intftbl) THEN
3419:
3414:
3415: IF l_validation_level > FND_API.G_VALID_LEVEL_NONE
3416: THEN
3417: -- Initialize message list if p_init_msg_list is set to TRUE.
3418: IF FND_API.to_Boolean(l_write_msg_to_intftbl) THEN
3419:
3420: Write_Debug('Insert Error Message for the records which can not find CO for the Org. . .' );
3421:
3422: FND_MESSAGE.SET_NAME('ENG','ENG_IMPT_RI_NOT_FOUND');
3514: Write_Debug('Calling POPULATE_MFGPARTNUM_INTF. . . ' );
3515:
3516: POPULATE_MFGPARTNUM_INTF
3517: ( p_api_version => 1.0
3518: , p_init_msg_list => FND_API.G_FALSE
3519: , p_commit => FND_API.G_FALSE
3520: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
3521: , x_return_status => l_return_status
3522: , x_msg_count => l_msg_count
3515:
3516: POPULATE_MFGPARTNUM_INTF
3517: ( p_api_version => 1.0
3518: , p_init_msg_list => FND_API.G_FALSE
3519: , p_commit => FND_API.G_FALSE
3520: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
3521: , x_return_status => l_return_status
3522: , x_msg_count => l_msg_count
3523: , x_msg_data => l_msg_data
3516: POPULATE_MFGPARTNUM_INTF
3517: ( p_api_version => 1.0
3518: , p_init_msg_list => FND_API.G_FALSE
3519: , p_commit => FND_API.G_FALSE
3520: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
3521: , x_return_status => l_return_status
3522: , x_msg_count => l_msg_count
3523: , x_msg_data => l_msg_data
3524: , p_write_msg_to_intftbl => FND_API.G_TRUE
3520: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
3521: , x_return_status => l_return_status
3522: , x_msg_count => l_msg_count
3523: , x_msg_data => l_msg_data
3524: , p_write_msg_to_intftbl => FND_API.G_TRUE
3525: , p_api_caller => NULL
3526: , p_debug => p_debug
3527: , p_output_dir => p_output_dir
3528: , p_debug_filename => p_debug_filename
3539: x_return_status := l_return_status ;
3540: x_msg_count := l_msg_count ;
3541: x_msg_data := l_msg_data ;
3542:
3543: RAISE FND_API.G_EXC_ERROR ;
3544: END IF ;
3545:
3546: END IF ;
3547:
3553: -- End of API body.
3554:
3555:
3556: -- Standard check of p_commit.
3557: IF FND_API.To_Boolean( p_commit ) THEN
3558: COMMIT WORK;
3559: END IF;
3560:
3561: -- Standard call to get message count and if count is 1, get message info.
3571: Close_Debug_Session;
3572:
3573:
3574: EXCEPTION
3575: WHEN FND_API.G_EXC_ERROR THEN
3576: ROLLBACK TO POPULATE_EXISTING_REV_ITEMS;
3577: x_return_status := G_RET_STS_ERROR ;
3578: FND_MSG_PUB.Count_And_Get
3579: ( p_count => x_msg_count ,
3584: -- Close Error Handler Debug Session.
3585: -----------------------------------------------------
3586: Close_Debug_Session;
3587:
3588: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3589:
3590: ROLLBACK TO POPULATE_EXISTING_REV_ITEMS;
3591: x_return_status := G_RET_STS_UNEXP_ERROR ;
3592: FND_MSG_PUB.Count_And_Get
3635: -- Parameters :
3636: -- IN : p_api_version IN NUMBER Required
3637: -- p_init_msg_list IN VARCHAR2 Optional
3638: -- Default = NULL
3639: -- FND_API.G_FALSE
3640: -- FND_API.G_TRUE
3641: -- p_commit IN VARCHAR2 Optional
3642: -- Default = NULL
3643: -- FND_API.G_FALSE
3636: -- IN : p_api_version IN NUMBER Required
3637: -- p_init_msg_list IN VARCHAR2 Optional
3638: -- Default = NULL
3639: -- FND_API.G_FALSE
3640: -- FND_API.G_TRUE
3641: -- p_commit IN VARCHAR2 Optional
3642: -- Default = NULL
3643: -- FND_API.G_FALSE
3644: -- FND_API.G_TRUE
3639: -- FND_API.G_FALSE
3640: -- FND_API.G_TRUE
3641: -- p_commit IN VARCHAR2 Optional
3642: -- Default = NULL
3643: -- FND_API.G_FALSE
3644: -- FND_API.G_TRUE
3645: -- p_validation_level IN NUMBER Optional
3646: -- Default = NULL
3647: -- Values:
3640: -- FND_API.G_TRUE
3641: -- p_commit IN VARCHAR2 Optional
3642: -- Default = NULL
3643: -- FND_API.G_FALSE
3644: -- FND_API.G_TRUE
3645: -- p_validation_level IN NUMBER Optional
3646: -- Default = NULL
3647: -- Values:
3648: -- FND_API.G_VALID_LEVEL_NONE 0
3644: -- FND_API.G_TRUE
3645: -- p_validation_level IN NUMBER Optional
3646: -- Default = NULL
3647: -- Values:
3648: -- FND_API.G_VALID_LEVEL_NONE 0
3649: -- FND_API.G_VALID_LEVEL_FULL 100
3650: -- p_write_msg_to_intftbl IN VARCHAR2 Optional
3651: -- Default = NULL
3652: -- FND_API.G_FALSE
3645: -- p_validation_level IN NUMBER Optional
3646: -- Default = NULL
3647: -- Values:
3648: -- FND_API.G_VALID_LEVEL_NONE 0
3649: -- FND_API.G_VALID_LEVEL_FULL 100
3650: -- p_write_msg_to_intftbl IN VARCHAR2 Optional
3651: -- Default = NULL
3652: -- FND_API.G_FALSE
3653: -- FND_API.G_TRUE
3648: -- FND_API.G_VALID_LEVEL_NONE 0
3649: -- FND_API.G_VALID_LEVEL_FULL 100
3650: -- p_write_msg_to_intftbl IN VARCHAR2 Optional
3651: -- Default = NULL
3652: -- FND_API.G_FALSE
3653: -- FND_API.G_TRUE
3654: -- p_api_caller IN VARCHAR2 Optional
3655: --
3656: -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
3649: -- FND_API.G_VALID_LEVEL_FULL 100
3650: -- p_write_msg_to_intftbl IN VARCHAR2 Optional
3651: -- Default = NULL
3652: -- FND_API.G_FALSE
3653: -- FND_API.G_TRUE
3654: -- p_api_caller IN VARCHAR2 Optional
3655: --
3656: -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
3657: -- x_msg_count OUT NOCOPY NUMBER
3663: -- Initial version 1.0
3664: --
3665: PROCEDURE UPDATE_PROCESS_STATUS
3666: ( p_api_version IN NUMBER
3667: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
3668: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
3669: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
3670: , x_return_status OUT NOCOPY VARCHAR2
3671: , x_msg_count OUT NOCOPY NUMBER
3664: --
3665: PROCEDURE UPDATE_PROCESS_STATUS
3666: ( p_api_version IN NUMBER
3667: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
3668: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
3669: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
3670: , x_return_status OUT NOCOPY VARCHAR2
3671: , x_msg_count OUT NOCOPY NUMBER
3672: , x_msg_data OUT NOCOPY VARCHAR2
3665: PROCEDURE UPDATE_PROCESS_STATUS
3666: ( p_api_version IN NUMBER
3667: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
3668: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
3669: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
3670: , x_return_status OUT NOCOPY VARCHAR2
3671: , x_msg_count OUT NOCOPY NUMBER
3672: , x_msg_data OUT NOCOPY VARCHAR2
3673: , p_write_msg_to_intftbl IN VARCHAR2 := NULL -- FND_API.G_FALSE
3669: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
3670: , x_return_status OUT NOCOPY VARCHAR2
3671: , x_msg_count OUT NOCOPY NUMBER
3672: , x_msg_data OUT NOCOPY VARCHAR2
3673: , p_write_msg_to_intftbl IN VARCHAR2 := NULL -- FND_API.G_FALSE
3674: , p_api_caller IN VARCHAR2 := NULL
3675: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE
3676: , p_output_dir IN VARCHAR2 := NULL
3677: , p_debug_filename IN VARCHAR2 := NULL
3671: , x_msg_count OUT NOCOPY NUMBER
3672: , x_msg_data OUT NOCOPY VARCHAR2
3673: , p_write_msg_to_intftbl IN VARCHAR2 := NULL -- FND_API.G_FALSE
3674: , p_api_caller IN VARCHAR2 := NULL
3675: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE
3676: , p_output_dir IN VARCHAR2 := NULL
3677: , p_debug_filename IN VARCHAR2 := NULL
3678: , p_batch_id IN NUMBER
3679: , p_from_status IN NUMBER
3717: -- Standard Start of API savepoint
3718: SAVEPOINT UPDATE_PROCESS_STATUS;
3719:
3720: -- Standard call to check for call compatibility.
3721: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
3722: p_api_version ,
3723: l_api_name ,
3724: G_PKG_NAME )
3725: THEN
3722: p_api_version ,
3723: l_api_name ,
3724: G_PKG_NAME )
3725: THEN
3726: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3727: END IF;
3728:
3729: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
3730: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
3725: THEN
3726: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3727: END IF;
3728:
3729: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
3730: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
3731: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
3732: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
3733:
3726: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3727: END IF;
3728:
3729: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
3730: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
3731: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
3732: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
3733:
3734:
3727: END IF;
3728:
3729: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
3730: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
3731: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
3732: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
3733:
3734:
3735: -- Initialize message list if p_init_msg_list is set to TRUE.
3728:
3729: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
3730: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
3731: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
3732: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
3733:
3734:
3735: -- Initialize message list if p_init_msg_list is set to TRUE.
3736: IF FND_API.to_Boolean( l_init_msg_list ) THEN
3732: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
3733:
3734:
3735: -- Initialize message list if p_init_msg_list is set to TRUE.
3736: IF FND_API.to_Boolean( l_init_msg_list ) THEN
3737: FND_MSG_PUB.initialize;
3738: END IF;
3739:
3740: -- Open Debug Session by a give param or profile option.
3827: -- End of API body.
3828:
3829:
3830: -- Standard check of p_commit.
3831: IF FND_API.To_Boolean( p_commit ) THEN
3832: COMMIT WORK;
3833: END IF;
3834:
3835: -- Standard call to get message count and if count is 1, get message info.
3845: Close_Debug_Session;
3846:
3847:
3848: EXCEPTION
3849: WHEN FND_API.G_EXC_ERROR THEN
3850: ROLLBACK TO UPDATE_PROCESS_STATUS;
3851: x_return_status := G_RET_STS_ERROR ;
3852: FND_MSG_PUB.Count_And_Get
3853: ( p_count => x_msg_count ,
3858: -- Close Error Handler Debug Session.
3859: -----------------------------------------------------
3860: Close_Debug_Session;
3861:
3862: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3863: ROLLBACK TO UPDATE_PROCESS_STATUS;
3864: x_return_status := G_RET_STS_UNEXP_ERROR ;
3865: FND_MSG_PUB.Count_And_Get
3866: ( p_count => x_msg_count ,
4102: Write_Debug('Before calling Eng_Revised_Item_Pkg.Query_Target_Revised_Item') ;
4103:
4104: Eng_Revised_Items_Pkg.Query_Target_Revised_Item (
4105: p_api_version => 1.0
4106: , p_init_msg_list => FND_API.G_FALSE
4107: , x_return_status => l_return_status
4108: , x_msg_count => l_msg_count
4109: , x_msg_data => l_msg_data
4110: , p_change_id => p_change_id
4121:
4122: IF l_return_status <> G_RET_STS_SUCCESS
4123: THEN
4124: Write_Debug('After calling Eng_Revised_Item_Pkg.Query_Target_Revised_Item: Return Msg: ' || l_msg_data );
4125: RAISE FND_API.G_EXC_ERROR ;
4126: END IF ;
4127:
4128: IF l_rev_item_seq_id IS NULL OR l_rev_item_seq_id <= 0
4129: THEN
4143: -- Procedure to create component interface rows given the component details
4144: --
4145: PROCEDURE CREATE_ORPHAN_COMPONENT_INTF
4146: ( p_api_version IN NUMBER
4147: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
4148: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
4149: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
4150: , x_return_status OUT NOCOPY VARCHAR2
4151: , x_msg_count OUT NOCOPY NUMBER
4144: --
4145: PROCEDURE CREATE_ORPHAN_COMPONENT_INTF
4146: ( p_api_version IN NUMBER
4147: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
4148: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
4149: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
4150: , x_return_status OUT NOCOPY VARCHAR2
4151: , x_msg_count OUT NOCOPY NUMBER
4152: , x_msg_data OUT NOCOPY VARCHAR2
4145: PROCEDURE CREATE_ORPHAN_COMPONENT_INTF
4146: ( p_api_version IN NUMBER
4147: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
4148: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
4149: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
4150: , x_return_status OUT NOCOPY VARCHAR2
4151: , x_msg_count OUT NOCOPY NUMBER
4152: , x_msg_data OUT NOCOPY VARCHAR2
4153: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE
4149: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
4150: , x_return_status OUT NOCOPY VARCHAR2
4151: , x_msg_count OUT NOCOPY NUMBER
4152: , x_msg_data OUT NOCOPY VARCHAR2
4153: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE
4154: , p_output_dir IN VARCHAR2 := NULL
4155: , p_debug_filename IN VARCHAR2 := NULL
4156: , p_organization_id IN NUMBER
4157: , p_assembly_item_id IN NUMBER
4189: -- Standard Start of API savepoint
4190: SAVEPOINT CREATE_ORPHAN_COMPONENT_INTF;
4191:
4192: -- Standard call to check for call compatibility.
4193: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
4194: p_api_version ,
4195: l_api_name ,
4196: G_PKG_NAME )
4197: THEN
4194: p_api_version ,
4195: l_api_name ,
4196: G_PKG_NAME )
4197: THEN
4198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4199: END IF;
4200:
4201: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
4202: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
4197: THEN
4198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4199: END IF;
4200:
4201: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
4202: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
4203: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
4204:
4205:
4198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4199: END IF;
4200:
4201: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
4202: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
4203: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
4204:
4205:
4206:
4199: END IF;
4200:
4201: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
4202: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
4203: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
4204:
4205:
4206:
4207: -- Initialize message list if p_init_msg_list is set to TRUE.
4204:
4205:
4206:
4207: -- Initialize message list if p_init_msg_list is set to TRUE.
4208: IF FND_API.to_Boolean( l_init_msg_list ) THEN
4209: FND_MSG_PUB.initialize;
4210: END IF;
4211:
4212: -- Open Debug Session by a give param or profile option.
4366: Write_Debug('Done Inserting data into interface tables:');
4367: -- End of API body.
4368:
4369: -- Standard check of p_commit.
4370: IF FND_API.To_Boolean( p_commit ) THEN
4371: COMMIT WORK;
4372: END IF;
4373:
4374: -- Standard call to get message count and if count is 1, get message info.
4383: -----------------------------------------------------
4384: Close_Debug_Session;
4385:
4386: EXCEPTION
4387: WHEN FND_API.G_EXC_ERROR THEN
4388: ROLLBACK TO CREATE_ORPHAN_COMPONENT_INTF;
4389: x_return_status := G_RET_STS_ERROR ;
4390: FND_MSG_PUB.Count_And_Get
4391: ( p_count => x_msg_count ,
4396: -- Close Error Handler Debug Session.
4397: -----------------------------------------------------
4398: Close_Debug_Session;
4399:
4400: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4401: ROLLBACK TO CREATE_ORPHAN_COMPONENT_INTF;
4402: x_return_status := G_RET_STS_UNEXP_ERROR ;
4403: FND_MSG_PUB.Count_And_Get
4404: ( p_count => x_msg_count ,
4445: -- Procedure to create structure header interface rows given the component details
4446: --
4447: PROCEDURE CREATE_ORPHAN_HEADER_INTF
4448: ( p_api_version IN NUMBER
4449: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
4450: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
4451: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
4452: , x_return_status OUT NOCOPY VARCHAR2
4453: , x_msg_count OUT NOCOPY NUMBER
4446: --
4447: PROCEDURE CREATE_ORPHAN_HEADER_INTF
4448: ( p_api_version IN NUMBER
4449: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
4450: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
4451: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
4452: , x_return_status OUT NOCOPY VARCHAR2
4453: , x_msg_count OUT NOCOPY NUMBER
4454: , x_msg_data OUT NOCOPY VARCHAR2
4447: PROCEDURE CREATE_ORPHAN_HEADER_INTF
4448: ( p_api_version IN NUMBER
4449: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
4450: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
4451: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
4452: , x_return_status OUT NOCOPY VARCHAR2
4453: , x_msg_count OUT NOCOPY NUMBER
4454: , x_msg_data OUT NOCOPY VARCHAR2
4455: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE
4451: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
4452: , x_return_status OUT NOCOPY VARCHAR2
4453: , x_msg_count OUT NOCOPY NUMBER
4454: , x_msg_data OUT NOCOPY VARCHAR2
4455: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE
4456: , p_output_dir IN VARCHAR2 := NULL
4457: , p_debug_filename IN VARCHAR2 := NULL
4458: , p_organization_id IN NUMBER
4459: , p_assembly_item_id IN NUMBER
4478: -- Standard Start of API savepoint
4479: SAVEPOINT CREATE_ORPHAN_HEADER_INTF;
4480:
4481: -- Standard call to check for call compatibility.
4482: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
4483: p_api_version ,
4484: l_api_name ,
4485: G_PKG_NAME )
4486: THEN
4483: p_api_version ,
4484: l_api_name ,
4485: G_PKG_NAME )
4486: THEN
4487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4488: END IF;
4489:
4490: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
4491: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
4486: THEN
4487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4488: END IF;
4489:
4490: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
4491: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
4492: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
4493:
4494:
4487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4488: END IF;
4489:
4490: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
4491: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
4492: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
4493:
4494:
4495:
4488: END IF;
4489:
4490: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
4491: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
4492: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
4493:
4494:
4495:
4496: -- Initialize message list if p_init_msg_list is set to TRUE.
4493:
4494:
4495:
4496: -- Initialize message list if p_init_msg_list is set to TRUE.
4497: IF FND_API.to_Boolean( l_init_msg_list ) THEN
4498: FND_MSG_PUB.initialize;
4499: END IF;
4500:
4501: -- Open Debug Session by a give param or profile option.
4577: Write_Debug('Done Inserting data into interface tables:');
4578: -- End of API body.
4579:
4580: -- Standard check of p_commit.
4581: IF FND_API.To_Boolean( p_commit ) THEN
4582: COMMIT WORK;
4583: END IF;
4584:
4585: -- Standard call to get message count and if count is 1, get message info.
4594: -----------------------------------------------------
4595: Close_Debug_Session;
4596:
4597: EXCEPTION
4598: WHEN FND_API.G_EXC_ERROR THEN
4599: ROLLBACK TO CREATE_ORPHAN_HEADER_INTF;
4600: x_return_status := G_RET_STS_ERROR ;
4601: FND_MSG_PUB.Count_And_Get
4602: ( p_count => x_msg_count ,
4607: -- Close Error Handler Debug Session.
4608: -----------------------------------------------------
4609: Close_Debug_Session;
4610:
4611: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4612: ROLLBACK TO CREATE_ORPHAN_HEADER_INTF;
4613: x_return_status := G_RET_STS_UNEXP_ERROR ;
4614: FND_MSG_PUB.Count_And_Get
4615: ( p_count => x_msg_count ,
4656: -- Procedure to create structure header interface rows given the component details
4657: --
4658: PROCEDURE PREPROCESS_COMP_CHILD_ROWS
4659: ( p_api_version IN NUMBER
4660: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
4661: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
4662: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
4663: , x_return_status OUT NOCOPY VARCHAR2
4664: , x_msg_count OUT NOCOPY NUMBER
4657: --
4658: PROCEDURE PREPROCESS_COMP_CHILD_ROWS
4659: ( p_api_version IN NUMBER
4660: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
4661: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
4662: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
4663: , x_return_status OUT NOCOPY VARCHAR2
4664: , x_msg_count OUT NOCOPY NUMBER
4665: , x_msg_data OUT NOCOPY VARCHAR2
4658: PROCEDURE PREPROCESS_COMP_CHILD_ROWS
4659: ( p_api_version IN NUMBER
4660: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
4661: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
4662: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
4663: , x_return_status OUT NOCOPY VARCHAR2
4664: , x_msg_count OUT NOCOPY NUMBER
4665: , x_msg_data OUT NOCOPY VARCHAR2
4666: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE
4662: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
4663: , x_return_status OUT NOCOPY VARCHAR2
4664: , x_msg_count OUT NOCOPY NUMBER
4665: , x_msg_data OUT NOCOPY VARCHAR2
4666: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE
4667: , p_output_dir IN VARCHAR2 := NULL
4668: , p_debug_filename IN VARCHAR2 := NULL
4669: , p_organization_id IN NUMBER
4670: , p_assembly_item_id IN NUMBER
4688: -- Standard Start of API savepoint
4689: SAVEPOINT PREPROCESS_COMP_CHILD_ROWS;
4690:
4691: -- Standard call to check for call compatibility.
4692: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
4693: p_api_version ,
4694: l_api_name ,
4695: G_PKG_NAME )
4696: THEN
4693: p_api_version ,
4694: l_api_name ,
4695: G_PKG_NAME )
4696: THEN
4697: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4698: END IF;
4699:
4700: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
4701: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
4696: THEN
4697: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4698: END IF;
4699:
4700: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
4701: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
4702: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
4703:
4704:
4697: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4698: END IF;
4699:
4700: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
4701: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
4702: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
4703:
4704:
4705:
4698: END IF;
4699:
4700: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
4701: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
4702: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
4703:
4704:
4705:
4706: -- Initialize message list if p_init_msg_list is set to TRUE.
4703:
4704:
4705:
4706: -- Initialize message list if p_init_msg_list is set to TRUE.
4707: IF FND_API.to_Boolean( l_init_msg_list ) THEN
4708: FND_MSG_PUB.initialize;
4709: END IF;
4710:
4711: -- Open Debug Session by a give param or profile option.
4785:
4786: -- End of API body.
4787:
4788: -- Standard check of p_commit.
4789: IF FND_API.To_Boolean( p_commit ) THEN
4790: COMMIT WORK;
4791: END IF;
4792:
4793: -- Standard call to get message count and if count is 1, get message info.
4802: -----------------------------------------------------
4803: Close_Debug_Session;
4804:
4805: EXCEPTION
4806: WHEN FND_API.G_EXC_ERROR THEN
4807: ROLLBACK TO PREPROCESS_COMP_CHILD_ROWS;
4808: x_return_status := G_RET_STS_ERROR ;
4809: FND_MSG_PUB.Count_And_Get
4810: ( p_count => x_msg_count ,
4815: -- Close Error Handler Debug Session.
4816: -----------------------------------------------------
4817: Close_Debug_Session;
4818:
4819: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4820: ROLLBACK TO PREPROCESS_COMP_CHILD_ROWS;
4821: x_return_status := G_RET_STS_UNEXP_ERROR ;
4822: FND_MSG_PUB.Count_And_Get
4823: ( p_count => x_msg_count ,
4881: --
4882: --
4883: PROCEDURE PREPROCESS_BOM_INTERFACE_ROWS
4884: ( p_api_version IN NUMBER
4885: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
4886: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
4887: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
4888: , x_return_status OUT NOCOPY VARCHAR2
4889: , x_msg_count OUT NOCOPY NUMBER
4882: --
4883: PROCEDURE PREPROCESS_BOM_INTERFACE_ROWS
4884: ( p_api_version IN NUMBER
4885: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
4886: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
4887: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
4888: , x_return_status OUT NOCOPY VARCHAR2
4889: , x_msg_count OUT NOCOPY NUMBER
4890: , x_msg_data OUT NOCOPY VARCHAR2
4883: PROCEDURE PREPROCESS_BOM_INTERFACE_ROWS
4884: ( p_api_version IN NUMBER
4885: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
4886: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
4887: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
4888: , x_return_status OUT NOCOPY VARCHAR2
4889: , x_msg_count OUT NOCOPY NUMBER
4890: , x_msg_data OUT NOCOPY VARCHAR2
4891: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE
4887: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
4888: , x_return_status OUT NOCOPY VARCHAR2
4889: , x_msg_count OUT NOCOPY NUMBER
4890: , x_msg_data OUT NOCOPY VARCHAR2
4891: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE
4892: , p_output_dir IN VARCHAR2 := NULL
4893: , p_debug_filename IN VARCHAR2 := NULL
4894: , p_change_id IN NUMBER
4895: , p_change_notice IN VARCHAR2
4926: -- Standard Start of API savepoint
4927: SAVEPOINT PREPROCESS_BOM_INTERFACE_ROWS;
4928:
4929: -- Standard call to check for call compatibility.
4930: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
4931: p_api_version ,
4932: l_api_name ,
4933: G_PKG_NAME )
4934: THEN
4931: p_api_version ,
4932: l_api_name ,
4933: G_PKG_NAME )
4934: THEN
4935: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4936: END IF;
4937:
4938: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
4939: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
4934: THEN
4935: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4936: END IF;
4937:
4938: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
4939: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
4940: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
4941:
4942:
4935: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4936: END IF;
4937:
4938: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
4939: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
4940: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
4941:
4942:
4943:
4936: END IF;
4937:
4938: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
4939: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
4940: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
4941:
4942:
4943:
4944: -- Initialize message list if p_init_msg_list is set to TRUE.
4941:
4942:
4943:
4944: -- Initialize message list if p_init_msg_list is set to TRUE.
4945: IF FND_API.to_Boolean( l_init_msg_list ) THEN
4946: FND_MSG_PUB.initialize;
4947: END IF;
4948:
4949: -- Open Debug Session by a give param or profile option.
5019: FROM mtl_item_revisions
5020: WHERE revision_id = parent_revision_id )),
5021: new_effectivity_date) <= p_current_date AND
5022: p_current_date = p_effectivity_date))
5023: AND NVL(new_from_end_item_unit_number, NVL(from_end_item_unit_number, FND_API.G_MISS_CHAR))
5024: = NVL(p_from_end_item_unit_number, FND_API.G_MISS_CHAR)
5025: AND NVL(from_end_item_rev_id, '-1') = NVL(p_from_end_item_rev_id, '-1')
5026: AND change_id = p_change_id
5027: AND batch_id = p_batch_id
5020: WHERE revision_id = parent_revision_id )),
5021: new_effectivity_date) <= p_current_date AND
5022: p_current_date = p_effectivity_date))
5023: AND NVL(new_from_end_item_unit_number, NVL(from_end_item_unit_number, FND_API.G_MISS_CHAR))
5024: = NVL(p_from_end_item_unit_number, FND_API.G_MISS_CHAR)
5025: AND NVL(from_end_item_rev_id, '-1') = NVL(p_from_end_item_rev_id, '-1')
5026: AND change_id = p_change_id
5027: AND batch_id = p_batch_id
5028: AND process_flag = G_CM_TO_BE_PROCESSED
5047: AND assembly_item_id = p_revised_item_id
5048: AND organization_id = p_organization_id
5049: AND (alternate_bom_designator = p_alternate_bom_designator
5050: OR (alternate_bom_designator IS NULL AND p_alternate_bom_designator IS NULL))))
5051: AND NVL(new_from_end_item_unit_number, NVL(from_end_item_unit_number, FND_API.G_MISS_CHAR))
5052: = NVL(p_from_end_item_unit_number, FND_API.G_MISS_CHAR)
5053: AND NVL(from_end_item_rev_id, '-1')
5054: = NVL(p_from_end_item_rev_id, '-1')
5055: AND ((p_effectivity_date IS NULL AND effectivity_date IS NULL)
5048: AND organization_id = p_organization_id
5049: AND (alternate_bom_designator = p_alternate_bom_designator
5050: OR (alternate_bom_designator IS NULL AND p_alternate_bom_designator IS NULL))))
5051: AND NVL(new_from_end_item_unit_number, NVL(from_end_item_unit_number, FND_API.G_MISS_CHAR))
5052: = NVL(p_from_end_item_unit_number, FND_API.G_MISS_CHAR)
5053: AND NVL(from_end_item_rev_id, '-1')
5054: = NVL(p_from_end_item_rev_id, '-1')
5055: AND ((p_effectivity_date IS NULL AND effectivity_date IS NULL)
5056: OR (decode (new_effectivity_date,
5105: AND assembly_item_id = p_revised_item_id
5106: AND organization_id = p_organization_id
5107: AND (alternate_bom_designator = p_alternate_bom_designator
5108: OR (alternate_bom_designator IS NULL AND p_alternate_bom_designator IS NULL))))
5109: AND NVL(new_from_end_item_unit_number, NVL(from_end_item_unit_number, FND_API.G_MISS_CHAR))
5110: = NVL(p_from_end_item_unit_number, FND_API.G_MISS_CHAR)
5111: AND NVL(from_end_item_rev_id, '-1')
5112: = NVL(p_from_end_item_rev_id, '-1')
5113: AND ((p_effectivity_date IS NULL AND effectivity_date IS NULL)
5106: AND organization_id = p_organization_id
5107: AND (alternate_bom_designator = p_alternate_bom_designator
5108: OR (alternate_bom_designator IS NULL AND p_alternate_bom_designator IS NULL))))
5109: AND NVL(new_from_end_item_unit_number, NVL(from_end_item_unit_number, FND_API.G_MISS_CHAR))
5110: = NVL(p_from_end_item_unit_number, FND_API.G_MISS_CHAR)
5111: AND NVL(from_end_item_rev_id, '-1')
5112: = NVL(p_from_end_item_rev_id, '-1')
5113: AND ((p_effectivity_date IS NULL AND effectivity_date IS NULL)
5114: OR (decode (new_effectivity_date,
5214:
5215: -- End of API body.
5216:
5217: -- Standard check of p_commit.
5218: IF FND_API.To_Boolean( p_commit ) THEN
5219: COMMIT WORK;
5220: END IF;
5221:
5222: -- Standard call to get message count and if count is 1, get message info.
5231: -----------------------------------------------------
5232: Close_Debug_Session;
5233:
5234: EXCEPTION
5235: WHEN FND_API.G_EXC_ERROR THEN
5236: ROLLBACK TO PREPROCESS_BOM_INTERFACE_ROWS;
5237: x_return_status := G_RET_STS_ERROR ;
5238: FND_MSG_PUB.Count_And_Get
5239: ( p_count => x_msg_count ,
5244: -- Close Error Handler Debug Session.
5245: -----------------------------------------------------
5246: Close_Debug_Session;
5247:
5248: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5249: ROLLBACK TO PREPROCESS_BOM_INTERFACE_ROWS;
5250: x_return_status := G_RET_STS_UNEXP_ERROR ;
5251: FND_MSG_PUB.Count_And_Get
5252: ( p_count => x_msg_count ,
5296: * Purpose : Perform Import Change Table Handler
5297: *********************************************************************/
5298: PROCEDURE INSERT_IMPORTED_CHANGE_HISTORY
5299: ( p_api_version IN NUMBER
5300: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
5301: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
5302: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
5303: , x_return_status OUT NOCOPY VARCHAR2
5304: , x_msg_count OUT NOCOPY NUMBER
5297: *********************************************************************/
5298: PROCEDURE INSERT_IMPORTED_CHANGE_HISTORY
5299: ( p_api_version IN NUMBER
5300: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
5301: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
5302: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
5303: , x_return_status OUT NOCOPY VARCHAR2
5304: , x_msg_count OUT NOCOPY NUMBER
5305: , x_msg_data OUT NOCOPY VARCHAR2
5298: PROCEDURE INSERT_IMPORTED_CHANGE_HISTORY
5299: ( p_api_version IN NUMBER
5300: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
5301: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
5302: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
5303: , x_return_status OUT NOCOPY VARCHAR2
5304: , x_msg_count OUT NOCOPY NUMBER
5305: , x_msg_data OUT NOCOPY VARCHAR2
5306: , p_write_msg_to_intftbl IN VARCHAR2 := NULL -- FND_API.G_FALSE
5302: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
5303: , x_return_status OUT NOCOPY VARCHAR2
5304: , x_msg_count OUT NOCOPY NUMBER
5305: , x_msg_data OUT NOCOPY VARCHAR2
5306: , p_write_msg_to_intftbl IN VARCHAR2 := NULL -- FND_API.G_FALSE
5307: , p_api_caller IN VARCHAR2 := NULL
5308: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE
5309: , p_output_dir IN VARCHAR2 := NULL
5310: , p_debug_filename IN VARCHAR2 := NULL
5304: , x_msg_count OUT NOCOPY NUMBER
5305: , x_msg_data OUT NOCOPY VARCHAR2
5306: , p_write_msg_to_intftbl IN VARCHAR2 := NULL -- FND_API.G_FALSE
5307: , p_api_caller IN VARCHAR2 := NULL
5308: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE
5309: , p_output_dir IN VARCHAR2 := NULL
5310: , p_debug_filename IN VARCHAR2 := NULL
5311: , p_batch_id IN NUMBER
5312: , p_change_ids IN FND_ARRAY_OF_NUMBER_25
5351: -- Standard Start of API savepoint
5352: SAVEPOINT INSERT_IMPORTED_CHANGE_HISTORY;
5353:
5354: -- Standard call to check for call compatibility.
5355: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
5356: p_api_version ,
5357: l_api_name ,
5358: G_PKG_NAME )
5359: THEN
5356: p_api_version ,
5357: l_api_name ,
5358: G_PKG_NAME )
5359: THEN
5360: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5361: END IF;
5362:
5363: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
5364: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
5359: THEN
5360: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5361: END IF;
5362:
5363: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
5364: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
5365: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
5366: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
5367:
5360: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5361: END IF;
5362:
5363: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
5364: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
5365: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
5366: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
5367:
5368:
5361: END IF;
5362:
5363: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
5364: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
5365: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
5366: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
5367:
5368:
5369: -- Initialize message list if p_init_msg_list is set to TRUE.
5362:
5363: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
5364: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
5365: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
5366: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
5367:
5368:
5369: -- Initialize message list if p_init_msg_list is set to TRUE.
5370: IF FND_API.to_Boolean( l_init_msg_list ) THEN
5366: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
5367:
5368:
5369: -- Initialize message list if p_init_msg_list is set to TRUE.
5370: IF FND_API.to_Boolean( l_init_msg_list ) THEN
5371: FND_MSG_PUB.initialize;
5372: END IF;
5373:
5374: -- Open Debug Session by a give param or profile option.
5429: X_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id
5430: ) ;
5431:
5432:
5433: IF FND_API.to_Boolean(l_write_msg_to_intftbl)
5434: THEN
5435:
5436: Write_Debug('Insert Info Message for the record inserted as history. . .' );
5437: --Begin code change for bug 9398720
5472: -- End of API body.
5473:
5474:
5475: -- Standard check of p_commit.
5476: IF FND_API.To_Boolean( p_commit ) THEN
5477: COMMIT WORK;
5478: END IF;
5479:
5480: -- Standard call to get message count and if count is 1, get message info.
5483: p_data => x_msg_data
5484: );
5485:
5486: EXCEPTION
5487: WHEN FND_API.G_EXC_ERROR THEN
5488: ROLLBACK TO INSERT_IMPORTED_CHANGE_HISTORY;
5489: x_return_status := G_RET_STS_ERROR ;
5490: FND_MSG_PUB.Count_And_Get
5491: ( p_count => x_msg_count ,
5491: ( p_count => x_msg_count ,
5492: p_data => x_msg_data
5493: );
5494:
5495: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5496: ROLLBACK TO INSERT_IMPORTED_CHANGE_HISTORY;
5497: x_return_status := G_RET_STS_UNEXP_ERROR ;
5498: FND_MSG_PUB.Count_And_Get
5499: ( p_count => x_msg_count ,
5717: ,p_object_name IN VARCHAR2
5718: ,p_data_set_id IN NUMBER
5719: ,p_entity_id IN NUMBER DEFAULT NULL
5720: ,p_entity_code IN VARCHAR2 DEFAULT NULL
5721: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
5722: ,x_return_status OUT NOCOPY VARCHAR2
5723: ,x_msg_data OUT NOCOPY VARCHAR2
5724: ) IS
5725: TYPE DYNAMIC_CUR IS REF CURSOR;
5796: and data_level_id = l_item_rev_dl_id
5797: and process_status = 5;
5798: IF l_sync_count = 0 THEN
5799: code_debug (l_api_name ||' returning as there are no records to process ');
5800: x_return_status := FND_API.G_RET_STS_SUCCESS;
5801: RETURN;
5802: END IF;
5803:
5804:
5801: RETURN;
5802: END IF;
5803:
5804:
5805: IF FND_API.To_Boolean(p_commit) THEN
5806: SAVEPOINT Update_Rev_Level_User_Attrs;
5807: END IF;
5808:
5809: G_ENTITY_ID := p_entity_id;
6035: --NVL (uai2.data_level_id,9.97e125) = l_item_rev_dl_id
6036: EXCEPTION
6037: WHEN OTHERS THEN
6038: code_debug('######## Oops ... came into the when others block-'||SQLERRM ,2);
6039: IF FND_API.To_Boolean(p_commit) THEN
6040: ROLLBACK TO Update_Rev_Level_User_Attrs;
6041: END IF;
6042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6043: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' '||SQLERRM;
6038: code_debug('######## Oops ... came into the when others block-'||SQLERRM ,2);
6039: IF FND_API.To_Boolean(p_commit) THEN
6040: ROLLBACK TO Update_Rev_Level_User_Attrs;
6041: END IF;
6042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6043: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' '||SQLERRM;
6044:
6045: -----------------------------------------------------------------
6046: -- Get a default row identifier to use in logging this message --
6056: ERROR_HANDLER.Add_Error_Message(
6057: p_message_text => x_msg_data
6058: ,p_row_identifier => l_dummy
6059: ,p_application_id => 'EGO'
6060: ,p_message_type => FND_API.G_RET_STS_ERROR
6061: ,p_entity_id => G_ENTITY_ID
6062: ,p_table_name => 'ego_itm_usr_attr_intrfc'
6063: ,p_entity_code => G_ENTITY_CODE
6064: );