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.

[Home] [Help]

APPS.ENG_CHANGE_IMPORT_UTIL dependencies on FND_API

Line 35: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

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:

Line 37: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

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. --

Line 38: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

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: ---------------------------------------------------------------

Line 254: IF (G_DEBUG = 1 OR FND_API.to_Boolean(p_debug_flag)) THEN

250: BEGIN
251: ----------------------------------------------------------------
252: -- Open the Debug Log Session, only if Profile is set to TRUE --
253: ----------------------------------------------------------------
254: IF (G_DEBUG = 1 OR FND_API.to_Boolean(p_debug_flag)) THEN
255:
256:
257: G_OUTPUT_DIR := p_output_dir ;
258: G_ERROR_FILE_NAME := p_file_name ;

Line 856: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE

852:
853:
854: PROCEDURE WRITE_MSG_TO_INTF_TBL
855: ( p_api_version IN NUMBER
856: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
857: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
858: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
859: , x_return_status OUT NOCOPY VARCHAR2
860: , x_msg_count OUT NOCOPY NUMBER

Line 857: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE

853:
854: PROCEDURE WRITE_MSG_TO_INTF_TBL
855: ( p_api_version IN NUMBER
856: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
857: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
858: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
859: , x_return_status OUT NOCOPY VARCHAR2
860: , x_msg_count OUT NOCOPY NUMBER
861: , x_msg_data OUT NOCOPY VARCHAR2

Line 858: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL

854: PROCEDURE WRITE_MSG_TO_INTF_TBL
855: ( p_api_version IN NUMBER
856: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
857: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
858: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
859: , x_return_status OUT NOCOPY VARCHAR2
860: , x_msg_count OUT NOCOPY NUMBER
861: , x_msg_data OUT NOCOPY VARCHAR2
862: , p_api_caller IN VARCHAR2 := NULL

Line 863: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE

859: , x_return_status OUT NOCOPY VARCHAR2
860: , x_msg_count OUT NOCOPY NUMBER
861: , x_msg_data OUT NOCOPY VARCHAR2
862: , p_api_caller IN VARCHAR2 := NULL
863: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE
864: , p_output_dir IN VARCHAR2 := NULL
865: , p_debug_filename IN VARCHAR2 := NULL
866: , p_batch_id IN NUMBER
867: , p_transaction_id IN NUMBER

Line 892: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

888: -- Standard Start of API savepoint
889: SAVEPOINT WRITE_MSG_TO_INTF_TBL;
890:
891: -- Standard call to check for call compatibility.
892: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
893: p_api_version ,
894: l_api_name ,
895: G_PKG_NAME )
896: THEN

Line 897: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

893: p_api_version ,
894: l_api_name ,
895: G_PKG_NAME )
896: THEN
897: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
898: END IF;
899:
900: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
901: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;

Line 900: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;

896: THEN
897: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
898: END IF;
899:
900: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
901: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
902: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
903:
904:

Line 901: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;

897: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
898: END IF;
899:
900: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
901: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
902: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
903:
904:
905:

Line 902: l_commit := NVL(p_commit,FND_API.G_FALSE) ;

898: END IF;
899:
900: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
901: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
902: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
903:
904:
905:
906: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 907: IF FND_API.to_Boolean( l_init_msg_list ) THEN

903:
904:
905:
906: -- Initialize message list if p_init_msg_list is set to TRUE.
907: IF FND_API.to_Boolean( l_init_msg_list ) THEN
908: FND_MSG_PUB.initialize;
909: END IF;
910:
911: Open_Debug_Session(p_debug, p_output_dir, p_debug_filename) ;

Line 956: IF FND_API.To_Boolean( p_commit ) THEN

952: -- End of API body.
953:
954:
955: -- Standard check of p_commit.
956: IF FND_API.To_Boolean( p_commit ) THEN
957: COMMIT WORK;
958: END IF;
959:
960: -- Standard call to get message count and if count is 1, get message info.

Line 975: WHEN FND_API.G_EXC_ERROR THEN

971: Close_Debug_Session;
972:
973:
974: EXCEPTION
975: WHEN FND_API.G_EXC_ERROR THEN
976: ROLLBACK TO WRITE_MSG_TO_INTF_TBL;
977: x_return_status := G_RET_STS_ERROR ;
978: FND_MSG_PUB.Count_And_Get
979: ( p_count => x_msg_count ,

Line 985: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

981: );
982:
983: Close_Debug_Session;
984:
985: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
986: ROLLBACK TO WRITE_MSG_TO_INTF_TBL;
987: x_return_status := G_RET_STS_UNEXP_ERROR ;
988: FND_MSG_PUB.Count_And_Get
989: ( p_count => x_msg_count ,

Line 1027: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE

1023: * Purpose : Perform Validation for Change Import
1024: *********************************************************************/
1025: PROCEDURE VALIDATE_RECORDS
1026: ( p_api_version IN NUMBER
1027: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
1028: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
1029: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
1030: , x_return_status OUT NOCOPY VARCHAR2
1031: , x_msg_count OUT NOCOPY NUMBER

Line 1028: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE

1024: *********************************************************************/
1025: PROCEDURE VALIDATE_RECORDS
1026: ( p_api_version IN NUMBER
1027: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
1028: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
1029: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
1030: , x_return_status OUT NOCOPY VARCHAR2
1031: , x_msg_count OUT NOCOPY NUMBER
1032: , x_msg_data OUT NOCOPY VARCHAR2

Line 1029: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL

1025: PROCEDURE VALIDATE_RECORDS
1026: ( p_api_version IN NUMBER
1027: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
1028: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
1029: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
1030: , x_return_status OUT NOCOPY VARCHAR2
1031: , x_msg_count OUT NOCOPY NUMBER
1032: , x_msg_data OUT NOCOPY VARCHAR2
1033: , p_write_msg_to_intftbl IN VARCHAR2 := NULL -- FND_API.G_FALSE

Line 1033: , p_write_msg_to_intftbl IN VARCHAR2 := NULL -- FND_API.G_FALSE

1029: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
1030: , x_return_status OUT NOCOPY VARCHAR2
1031: , x_msg_count OUT NOCOPY NUMBER
1032: , x_msg_data OUT NOCOPY VARCHAR2
1033: , p_write_msg_to_intftbl IN VARCHAR2 := NULL -- FND_API.G_FALSE
1034: , p_api_caller IN VARCHAR2 := NULL
1035: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE
1036: , p_output_dir IN VARCHAR2 := NULL
1037: , p_debug_filename IN VARCHAR2 := NULL

Line 1035: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE

1031: , x_msg_count OUT NOCOPY NUMBER
1032: , x_msg_data OUT NOCOPY VARCHAR2
1033: , p_write_msg_to_intftbl IN VARCHAR2 := NULL -- FND_API.G_FALSE
1034: , p_api_caller IN VARCHAR2 := NULL
1035: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE
1036: , p_output_dir IN VARCHAR2 := NULL
1037: , p_debug_filename IN VARCHAR2 := NULL
1038: , p_batch_id IN NUMBER
1039: , p_batch_type IN VARCHAR2 := NULL

Line 1079: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

1075: -- Standard Start of API savepoint
1076: SAVEPOINT VALIDATE_RECORDS;
1077:
1078: -- Standard call to check for call compatibility.
1079: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1080: p_api_version ,
1081: l_api_name ,
1082: G_PKG_NAME )
1083: THEN

Line 1084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1080: p_api_version ,
1081: l_api_name ,
1082: G_PKG_NAME )
1083: THEN
1084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1085: END IF;
1086:
1087:
1088: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;

Line 1088: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;

1084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1085: END IF;
1086:
1087:
1088: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
1089: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
1090: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
1091: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
1092: l_msg_process_flag := FALSE ;

Line 1089: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;

1085: END IF;
1086:
1087:
1088: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
1089: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
1090: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
1091: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
1092: l_msg_process_flag := FALSE ;
1093:

Line 1090: l_commit := NVL(p_commit,FND_API.G_FALSE) ;

1086:
1087:
1088: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
1089: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
1090: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
1091: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
1092: l_msg_process_flag := FALSE ;
1093:
1094:

Line 1091: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;

1087:
1088: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
1089: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
1090: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
1091: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
1092: l_msg_process_flag := FALSE ;
1093:
1094:
1095: -- Initialize message list if l_init_msg_list is set to TRUE.

Line 1096: IF FND_API.to_Boolean( l_init_msg_list ) THEN

1092: l_msg_process_flag := FALSE ;
1093:
1094:
1095: -- Initialize message list if l_init_msg_list is set to TRUE.
1096: IF FND_API.to_Boolean( l_init_msg_list ) THEN
1097: FND_MSG_PUB.initialize;
1098: END IF;
1099:
1100: -- Open Debug Session by a give param or profile option.

Line 1176: IF l_validation_level > FND_API.G_VALID_LEVEL_NONE AND

1172:
1173: END IF ;
1174:
1175:
1176: IF l_validation_level > FND_API.G_VALID_LEVEL_NONE AND
1177: FND_API.to_Boolean(l_write_msg_to_intftbl) AND
1178: l_msg_process_flag
1179: THEN
1180:

Line 1177: FND_API.to_Boolean(l_write_msg_to_intftbl) AND

1173: END IF ;
1174:
1175:
1176: IF l_validation_level > FND_API.G_VALID_LEVEL_NONE AND
1177: FND_API.to_Boolean(l_write_msg_to_intftbl) AND
1178: l_msg_process_flag
1179: THEN
1180:
1181: Write_Debug('Insert Error Message for the records which is set to CM Process per Change ID value set above validation. . .' );

Line 1278: IF l_validation_level > FND_API.G_VALID_LEVEL_NONE

1274: l_dyn_sql := l_dyn_sql || ' SET INTF.change_id = null ' ;
1275:
1276: -- If validation level is more than None
1277: -- set the process flag to ERROR:3
1278: IF l_validation_level > FND_API.G_VALID_LEVEL_NONE
1279: THEN
1280: l_dyn_sql := l_dyn_sql || ' , INTF.' || l_intf_proc_flag_col(i) || ' = ' || G_PS_ERROR ;
1281: END IF ;
1282:

Line 1305: IF FND_API.To_Boolean( l_commit ) THEN

1301: -- End of API body.
1302:
1303:
1304: -- Standard check of l_commit.
1305: IF FND_API.To_Boolean( l_commit ) THEN
1306: COMMIT WORK;
1307: END IF;
1308:
1309: -- Standard call to get message count and if count is 1, get message info.

Line 1323: WHEN FND_API.G_EXC_ERROR THEN

1319: Close_Debug_Session;
1320:
1321:
1322: EXCEPTION
1323: WHEN FND_API.G_EXC_ERROR THEN
1324: ROLLBACK TO VALIDATE_RECORDS;
1325: x_return_status := G_RET_STS_ERROR ;
1326: FND_MSG_PUB.Count_And_Get
1327: ( p_count => x_msg_count ,

Line 1334: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1330:
1331: Close_Debug_Session;
1332:
1333:
1334: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1335: ROLLBACK TO VALIDATE_RECORDS;
1336: x_return_status := G_RET_STS_UNEXP_ERROR ;
1337: FND_MSG_PUB.Count_And_Get
1338: ( p_count => x_msg_count ,

Line 1855: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE

1851:
1852:
1853: PROCEDURE VALIDATE_GDSN_ATTR_CHGS
1854: ( p_api_version IN NUMBER
1855: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
1856: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
1857: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
1858: , x_return_status OUT NOCOPY VARCHAR2
1859: , x_msg_count OUT NOCOPY NUMBER

Line 1856: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE

1852:
1853: PROCEDURE VALIDATE_GDSN_ATTR_CHGS
1854: ( p_api_version IN NUMBER
1855: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
1856: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
1857: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
1858: , x_return_status OUT NOCOPY VARCHAR2
1859: , x_msg_count OUT NOCOPY NUMBER
1860: , x_msg_data OUT NOCOPY VARCHAR2

Line 1857: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL

1853: PROCEDURE VALIDATE_GDSN_ATTR_CHGS
1854: ( p_api_version IN NUMBER
1855: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
1856: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
1857: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
1858: , x_return_status OUT NOCOPY VARCHAR2
1859: , x_msg_count OUT NOCOPY NUMBER
1860: , x_msg_data OUT NOCOPY VARCHAR2
1861: , p_write_msg_to_intftbl IN VARCHAR2 := NULL -- FND_API.G_FALSE

Line 1861: , p_write_msg_to_intftbl IN VARCHAR2 := NULL -- FND_API.G_FALSE

1857: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
1858: , x_return_status OUT NOCOPY VARCHAR2
1859: , x_msg_count OUT NOCOPY NUMBER
1860: , x_msg_data OUT NOCOPY VARCHAR2
1861: , p_write_msg_to_intftbl IN VARCHAR2 := NULL -- FND_API.G_FALSE
1862: , p_api_caller IN VARCHAR2 := NULL
1863: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE
1864: , p_output_dir IN VARCHAR2 := NULL
1865: , p_debug_filename IN VARCHAR2 := NULL

Line 1863: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE

1859: , x_msg_count OUT NOCOPY NUMBER
1860: , x_msg_data OUT NOCOPY VARCHAR2
1861: , p_write_msg_to_intftbl IN VARCHAR2 := NULL -- FND_API.G_FALSE
1862: , p_api_caller IN VARCHAR2 := NULL
1863: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE
1864: , p_output_dir IN VARCHAR2 := NULL
1865: , p_debug_filename IN VARCHAR2 := NULL
1866: , p_batch_id IN NUMBER
1867: , p_cm_process_type IN VARCHAR2 := NULL

Line 1912: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

1908: -- Standard Start of API savepoint
1909: SAVEPOINT VALIDATE_GDSN_ATTR_CHGS;
1910:
1911: -- Standard call to check for call compatibility.
1912: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1913: p_api_version ,
1914: l_api_name ,
1915: G_PKG_NAME )
1916: THEN

Line 1917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1913: p_api_version ,
1914: l_api_name ,
1915: G_PKG_NAME )
1916: THEN
1917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1918: END IF;
1919:
1920:
1921: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;

Line 1921: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;

1917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1918: END IF;
1919:
1920:
1921: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
1922: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
1923: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
1924: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
1925:

Line 1922: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;

1918: END IF;
1919:
1920:
1921: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
1922: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
1923: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
1924: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
1925:
1926:

Line 1923: l_commit := NVL(p_commit,FND_API.G_FALSE) ;

1919:
1920:
1921: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
1922: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
1923: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
1924: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
1925:
1926:
1927: -- Initialize message list if l_init_msg_list is set to TRUE.

Line 1924: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;

1920:
1921: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
1922: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
1923: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
1924: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
1925:
1926:
1927: -- Initialize message list if l_init_msg_list is set to TRUE.
1928: IF FND_API.to_Boolean( l_init_msg_list ) THEN

Line 1928: IF FND_API.to_Boolean( l_init_msg_list ) THEN

1924: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
1925:
1926:
1927: -- Initialize message list if l_init_msg_list is set to TRUE.
1928: IF FND_API.to_Boolean( l_init_msg_list ) THEN
1929: FND_MSG_PUB.initialize;
1930: END IF;
1931:
1932: -- Open Debug Session by a give param or profile option.

Line 1992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1988: ( 'EGO_GTIN_ATTRS_PVT',
1989: 'Get_Gdsn_Intf_Rows' ,
1990: SQLERRM ) ;
1991:
1992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1993:
1994:
1995: END ;
1996:

Line 2019: IF FND_API.to_Boolean(l_write_msg_to_intftbl)

2015: FOR cnt IN 1..l_msg_count LOOP
2016: Write_Debug('Error msg - '||cnt ||': '|| FND_MSG_PUB.Get(p_msg_index => cnt, p_encoded => 'F'));
2017:
2018: l_msg_text := FND_MSG_PUB.Get(p_msg_index => cnt, p_encoded => 'F');
2019: IF FND_API.to_Boolean(l_write_msg_to_intftbl)
2020: THEN
2021:
2022: Insert_Mtl_Intf_Err
2023: ( p_transaction_id => i.TRANSACTION_ID

Line 2042: IF FND_API.to_Boolean(l_write_msg_to_intftbl)

2038:
2039: Write_Debug('Unexpected Error msg - '|| l_msg_data);
2040:
2041: l_msg_text := l_msg_data;
2042: IF FND_API.to_Boolean(l_write_msg_to_intftbl)
2043: THEN
2044:
2045: Insert_Mtl_Intf_Err
2046: ( p_transaction_id => i.TRANSACTION_ID

Line 2058: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2054: ) ;
2055:
2056: END IF ;
2057:
2058: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2059:
2060:
2061: END IF; -- IF l_msg_count
2062:

Line 2109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2105: ( 'EGO_GTIN_ATTRS_PVT',
2106: 'Validate_Attributes' ,
2107: SQLERRM ) ;
2108:
2109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2110:
2111:
2112: END ;
2113:

Line 2137: IF FND_API.to_Boolean(l_write_msg_to_intftbl)

2133: Write_Debug('Error msg - '||cnt ||': '|| FND_MSG_PUB.Get(p_msg_index => cnt, p_encoded => 'F'));
2134:
2135: l_msg_text := FND_MSG_PUB.Get(p_msg_index => cnt, p_encoded => 'F');
2136:
2137: IF FND_API.to_Boolean(l_write_msg_to_intftbl)
2138: THEN
2139:
2140: Insert_Mtl_Intf_Err
2141: ( p_transaction_id => i.TRANSACTION_ID

Line 2160: IF FND_API.to_Boolean(l_write_msg_to_intftbl)

2156:
2157: Write_Debug('Unexpected Error msg - '|| l_msg_data);
2158:
2159: l_msg_text := l_msg_data;
2160: IF FND_API.to_Boolean(l_write_msg_to_intftbl)
2161: THEN
2162:
2163: Insert_Mtl_Intf_Err
2164: ( p_transaction_id => i.TRANSACTION_ID

Line 2176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2172: ) ;
2173:
2174: END IF ;
2175:
2176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2177:
2178:
2179: END IF; -- IF l_msg_count
2180:

Line 2189: IF FND_API.To_Boolean( l_commit ) THEN

2185: -- End of API body.
2186:
2187:
2188: -- Standard check of l_commit.
2189: IF FND_API.To_Boolean( l_commit ) THEN
2190: COMMIT WORK;
2191: END IF;
2192:
2193: -- Standard call to get message count and if count is 1, get message info.

Line 2208: WHEN FND_API.G_EXC_ERROR THEN

2204: Close_Debug_Session;
2205:
2206:
2207: EXCEPTION
2208: WHEN FND_API.G_EXC_ERROR THEN
2209: ROLLBACK TO VALIDATE_GDSN_ATTR_CHGS;
2210: x_return_status := G_RET_STS_ERROR ;
2211: FND_MSG_PUB.Count_And_Get
2212: ( p_count => x_msg_count ,

Line 2219: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2215:
2216:
2217: Close_Debug_Session;
2218:
2219: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2220: ROLLBACK TO VALIDATE_GDSN_ATTR_CHGS;
2221: x_return_status := G_RET_STS_UNEXP_ERROR ;
2222: FND_MSG_PUB.Count_And_Get
2223: ( p_count => x_msg_count ,

Line 2267: -- FND_API.G_FALSE

2263: -- Parameters :
2264: -- IN : p_api_version IN NUMBER Required
2265: -- p_init_msg_list IN VARCHAR2 Optional
2266: -- Default = NULL
2267: -- FND_API.G_FALSE
2268: -- FND_API.G_TRUE
2269: -- p_commit IN VARCHAR2 Optional
2270: -- Default = NULL
2271: -- FND_API.G_FALSE

Line 2268: -- FND_API.G_TRUE

2264: -- IN : p_api_version IN NUMBER Required
2265: -- p_init_msg_list IN VARCHAR2 Optional
2266: -- Default = NULL
2267: -- FND_API.G_FALSE
2268: -- FND_API.G_TRUE
2269: -- p_commit IN VARCHAR2 Optional
2270: -- Default = NULL
2271: -- FND_API.G_FALSE
2272: -- FND_API.G_TRUE

Line 2271: -- FND_API.G_FALSE

2267: -- FND_API.G_FALSE
2268: -- FND_API.G_TRUE
2269: -- p_commit IN VARCHAR2 Optional
2270: -- Default = NULL
2271: -- FND_API.G_FALSE
2272: -- FND_API.G_TRUE
2273: -- p_validation_level IN NUMBER Optional
2274: -- Default = NULL
2275: -- Values:

Line 2272: -- FND_API.G_TRUE

2268: -- FND_API.G_TRUE
2269: -- p_commit IN VARCHAR2 Optional
2270: -- Default = NULL
2271: -- FND_API.G_FALSE
2272: -- FND_API.G_TRUE
2273: -- p_validation_level IN NUMBER Optional
2274: -- Default = NULL
2275: -- Values:
2276: -- FND_API.G_VALID_LEVEL_NONE 0

Line 2276: -- FND_API.G_VALID_LEVEL_NONE 0

2272: -- FND_API.G_TRUE
2273: -- p_validation_level IN NUMBER Optional
2274: -- Default = NULL
2275: -- Values:
2276: -- FND_API.G_VALID_LEVEL_NONE 0
2277: -- FND_API.G_VALID_LEVEL_FULL 100
2278: -- p_write_msg_to_intftbl IN VARCHAR2 Optional
2279: -- Default = NULL
2280: -- FND_API.G_FALSE

Line 2277: -- FND_API.G_VALID_LEVEL_FULL 100

2273: -- p_validation_level IN NUMBER Optional
2274: -- Default = NULL
2275: -- Values:
2276: -- FND_API.G_VALID_LEVEL_NONE 0
2277: -- FND_API.G_VALID_LEVEL_FULL 100
2278: -- p_write_msg_to_intftbl IN VARCHAR2 Optional
2279: -- Default = NULL
2280: -- FND_API.G_FALSE
2281: -- FND_API.G_TRUE

Line 2280: -- FND_API.G_FALSE

2276: -- FND_API.G_VALID_LEVEL_NONE 0
2277: -- FND_API.G_VALID_LEVEL_FULL 100
2278: -- p_write_msg_to_intftbl IN VARCHAR2 Optional
2279: -- Default = NULL
2280: -- FND_API.G_FALSE
2281: -- FND_API.G_TRUE
2282: -- p_api_caller IN VARCHAR2 Optional
2283: --
2284: -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)

Line 2281: -- FND_API.G_TRUE

2277: -- FND_API.G_VALID_LEVEL_FULL 100
2278: -- p_write_msg_to_intftbl IN VARCHAR2 Optional
2279: -- Default = NULL
2280: -- FND_API.G_FALSE
2281: -- FND_API.G_TRUE
2282: -- p_api_caller IN VARCHAR2 Optional
2283: --
2284: -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
2285: -- x_msg_count OUT NOCOPY NUMBER

Line 2293: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE

2289: --
2290: -- Notes : Note text-- API name : POPULATE_MFGPARTNUM_INTF
2291: PROCEDURE POPULATE_MFGPARTNUM_INTF
2292: ( p_api_version IN NUMBER
2293: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
2294: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
2295: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
2296: , x_return_status OUT NOCOPY VARCHAR2
2297: , x_msg_count OUT NOCOPY NUMBER

Line 2294: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE

2290: -- Notes : Note text-- API name : POPULATE_MFGPARTNUM_INTF
2291: PROCEDURE POPULATE_MFGPARTNUM_INTF
2292: ( p_api_version IN NUMBER
2293: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
2294: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
2295: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
2296: , x_return_status OUT NOCOPY VARCHAR2
2297: , x_msg_count OUT NOCOPY NUMBER
2298: , x_msg_data OUT NOCOPY VARCHAR2

Line 2295: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL

2291: PROCEDURE POPULATE_MFGPARTNUM_INTF
2292: ( p_api_version IN NUMBER
2293: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
2294: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
2295: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
2296: , x_return_status OUT NOCOPY VARCHAR2
2297: , x_msg_count OUT NOCOPY NUMBER
2298: , x_msg_data OUT NOCOPY VARCHAR2
2299: , p_write_msg_to_intftbl IN VARCHAR2 := NULL -- FND_API.G_FALSE

Line 2299: , p_write_msg_to_intftbl IN VARCHAR2 := NULL -- FND_API.G_FALSE

2295: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
2296: , x_return_status OUT NOCOPY VARCHAR2
2297: , x_msg_count OUT NOCOPY NUMBER
2298: , x_msg_data OUT NOCOPY VARCHAR2
2299: , p_write_msg_to_intftbl IN VARCHAR2 := NULL -- FND_API.G_FALSE
2300: , p_api_caller IN VARCHAR2 := NULL
2301: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE
2302: , p_output_dir IN VARCHAR2 := NULL
2303: , p_debug_filename IN VARCHAR2 := NULL

Line 2301: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE

2297: , x_msg_count OUT NOCOPY NUMBER
2298: , x_msg_data OUT NOCOPY VARCHAR2
2299: , p_write_msg_to_intftbl IN VARCHAR2 := NULL -- FND_API.G_FALSE
2300: , p_api_caller IN VARCHAR2 := NULL
2301: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE
2302: , p_output_dir IN VARCHAR2 := NULL
2303: , p_debug_filename IN VARCHAR2 := NULL
2304: , p_batch_id IN NUMBER
2305: )

Line 2330: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

2326: -- Standard Start of API savepoint
2327: SAVEPOINT POPULATE_MFGPARTNUM_INTF;
2328:
2329: -- Standard call to check for call compatibility.
2330: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
2331: p_api_version ,
2332: l_api_name ,
2333: G_PKG_NAME )
2334: THEN

Line 2335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2331: p_api_version ,
2332: l_api_name ,
2333: G_PKG_NAME )
2334: THEN
2335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2336: END IF;
2337:
2338: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
2339: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;

Line 2338: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;

2334: THEN
2335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2336: END IF;
2337:
2338: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
2339: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
2340: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
2341: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
2342:

Line 2339: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;

2335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2336: END IF;
2337:
2338: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
2339: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
2340: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
2341: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
2342:
2343:

Line 2340: l_commit := NVL(p_commit,FND_API.G_FALSE) ;

2336: END IF;
2337:
2338: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
2339: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
2340: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
2341: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
2342:
2343:
2344: -- Initialize message list if l_init_msg_list is set to TRUE.

Line 2341: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;

2337:
2338: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
2339: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
2340: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
2341: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
2342:
2343:
2344: -- Initialize message list if l_init_msg_list is set to TRUE.
2345: IF FND_API.to_Boolean( l_init_msg_list ) THEN

Line 2345: IF FND_API.to_Boolean( l_init_msg_list ) THEN

2341: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
2342:
2343:
2344: -- Initialize message list if l_init_msg_list is set to TRUE.
2345: IF FND_API.to_Boolean( l_init_msg_list ) THEN
2346: FND_MSG_PUB.initialize;
2347: END IF;
2348:
2349: -- Open Debug Session by a give param or profile option.

Line 2427: ,p_commit => FND_API.G_FALSE

2423:
2424:
2425: EGO_ITEM_AML_GRP.Populate_Intf_With_Proddata (
2426: p_api_version => 1.0
2427: ,p_commit => FND_API.G_FALSE
2428: ,p_data_set_id => p_batch_id
2429: ,p_pf_to_process => G_CM_TO_BE_PROCESSED -- p_pf_to_process
2430: ,p_pf_after_population => G_CM_TO_BE_PROCESSED -- p_pf_after_population
2431: ,x_return_status => l_return_status

Line 2446: RAISE FND_API.G_EXC_ERROR ;

2442: x_return_status := l_return_status ;
2443: x_msg_count := l_msg_count ;
2444: x_msg_data := l_msg_data ;
2445:
2446: RAISE FND_API.G_EXC_ERROR ;
2447: END IF ;
2448:
2449:
2450:

Line 2647: IF FND_API.To_Boolean( p_commit ) THEN

2643: -- End of API body.
2644:
2645:
2646: -- Standard check of p_commit.
2647: IF FND_API.To_Boolean( p_commit ) THEN
2648: COMMIT WORK;
2649: END IF;
2650:
2651: -- Standard call to get message count and if count is 1, get message info.

Line 2668: WHEN FND_API.G_EXC_ERROR THEN

2664: EXCEPTION
2665: WHEN NO_ROWS_IN_INTF_TABLE THEN
2666: NULL;
2667:
2668: WHEN FND_API.G_EXC_ERROR THEN
2669: ROLLBACK TO POPULATE_MFGPARTNUM_INTF;
2670: x_return_status := G_RET_STS_ERROR ;
2671: FND_MSG_PUB.Count_And_Get
2672: ( p_count => x_msg_count ,

Line 2681: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2677: -- Close Error Handler Debug Session.
2678: -----------------------------------------------------
2679: Close_Debug_Session;
2680:
2681: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2682: ROLLBACK TO POPULATE_MFGPARTNUM_INTF;
2683: x_return_status := G_RET_STS_UNEXP_ERROR ;
2684: FND_MSG_PUB.Count_And_Get
2685: ( p_count => x_msg_count ,

Line 2732: -- FND_API.G_FALSE

2728: -- Parameters :
2729: -- IN : p_api_version IN NUMBER Required
2730: -- p_init_msg_list IN VARCHAR2 Optional
2731: -- Default = NULL
2732: -- FND_API.G_FALSE
2733: -- FND_API.G_TRUE
2734: -- p_commit IN VARCHAR2 Optional
2735: -- Default = NULL
2736: -- FND_API.G_FALSE

Line 2733: -- FND_API.G_TRUE

2729: -- IN : p_api_version IN NUMBER Required
2730: -- p_init_msg_list IN VARCHAR2 Optional
2731: -- Default = NULL
2732: -- FND_API.G_FALSE
2733: -- FND_API.G_TRUE
2734: -- p_commit IN VARCHAR2 Optional
2735: -- Default = NULL
2736: -- FND_API.G_FALSE
2737: -- FND_API.G_TRUE

Line 2736: -- FND_API.G_FALSE

2732: -- FND_API.G_FALSE
2733: -- FND_API.G_TRUE
2734: -- p_commit IN VARCHAR2 Optional
2735: -- Default = NULL
2736: -- FND_API.G_FALSE
2737: -- FND_API.G_TRUE
2738: -- p_validation_level IN NUMBER Optional
2739: -- Default = NULL
2740: -- Values:

Line 2737: -- FND_API.G_TRUE

2733: -- FND_API.G_TRUE
2734: -- p_commit IN VARCHAR2 Optional
2735: -- Default = NULL
2736: -- FND_API.G_FALSE
2737: -- FND_API.G_TRUE
2738: -- p_validation_level IN NUMBER Optional
2739: -- Default = NULL
2740: -- Values:
2741: -- FND_API.G_VALID_LEVEL_NONE 0

Line 2741: -- FND_API.G_VALID_LEVEL_NONE 0

2737: -- FND_API.G_TRUE
2738: -- p_validation_level IN NUMBER Optional
2739: -- Default = NULL
2740: -- Values:
2741: -- FND_API.G_VALID_LEVEL_NONE 0
2742: -- FND_API.G_VALID_LEVEL_FULL 100
2743: -- p_write_msg_to_intftbl IN VARCHAR2 Optional
2744: -- Default = NULL
2745: -- FND_API.G_FALSE

Line 2742: -- FND_API.G_VALID_LEVEL_FULL 100

2738: -- p_validation_level IN NUMBER Optional
2739: -- Default = NULL
2740: -- Values:
2741: -- FND_API.G_VALID_LEVEL_NONE 0
2742: -- FND_API.G_VALID_LEVEL_FULL 100
2743: -- p_write_msg_to_intftbl IN VARCHAR2 Optional
2744: -- Default = NULL
2745: -- FND_API.G_FALSE
2746: -- FND_API.G_TRUE

Line 2745: -- FND_API.G_FALSE

2741: -- FND_API.G_VALID_LEVEL_NONE 0
2742: -- FND_API.G_VALID_LEVEL_FULL 100
2743: -- p_write_msg_to_intftbl IN VARCHAR2 Optional
2744: -- Default = NULL
2745: -- FND_API.G_FALSE
2746: -- FND_API.G_TRUE
2747: -- p_api_caller IN VARCHAR2 Optional
2748: --
2749: -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)

Line 2746: -- FND_API.G_TRUE

2742: -- FND_API.G_VALID_LEVEL_FULL 100
2743: -- p_write_msg_to_intftbl IN VARCHAR2 Optional
2744: -- Default = NULL
2745: -- FND_API.G_FALSE
2746: -- FND_API.G_TRUE
2747: -- p_api_caller IN VARCHAR2 Optional
2748: --
2749: -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
2750: -- x_msg_count OUT NOCOPY NUMBER

Line 2760: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE

2756: -- Initial version 1.0
2757: --
2758: PROCEDURE POPULATE_EXISTING_CHANGE
2759: ( p_api_version IN NUMBER
2760: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
2761: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
2762: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
2763: , x_return_status OUT NOCOPY VARCHAR2
2764: , x_msg_count OUT NOCOPY NUMBER

Line 2761: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE

2757: --
2758: PROCEDURE POPULATE_EXISTING_CHANGE
2759: ( p_api_version IN NUMBER
2760: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
2761: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
2762: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
2763: , x_return_status OUT NOCOPY VARCHAR2
2764: , x_msg_count OUT NOCOPY NUMBER
2765: , x_msg_data OUT NOCOPY VARCHAR2

Line 2762: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL

2758: PROCEDURE POPULATE_EXISTING_CHANGE
2759: ( p_api_version IN NUMBER
2760: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
2761: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
2762: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
2763: , x_return_status OUT NOCOPY VARCHAR2
2764: , x_msg_count OUT NOCOPY NUMBER
2765: , x_msg_data OUT NOCOPY VARCHAR2
2766: , p_write_msg_to_intftbl IN VARCHAR2 := NULL -- FND_API.G_FALSE

Line 2766: , p_write_msg_to_intftbl IN VARCHAR2 := NULL -- FND_API.G_FALSE

2762: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
2763: , x_return_status OUT NOCOPY VARCHAR2
2764: , x_msg_count OUT NOCOPY NUMBER
2765: , x_msg_data OUT NOCOPY VARCHAR2
2766: , p_write_msg_to_intftbl IN VARCHAR2 := NULL -- FND_API.G_FALSE
2767: , p_api_caller IN VARCHAR2 := NULL
2768: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE
2769: , p_output_dir IN VARCHAR2 := NULL
2770: , p_debug_filename IN VARCHAR2 := NULL

Line 2768: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE

2764: , x_msg_count OUT NOCOPY NUMBER
2765: , x_msg_data OUT NOCOPY VARCHAR2
2766: , p_write_msg_to_intftbl IN VARCHAR2 := NULL -- FND_API.G_FALSE
2767: , p_api_caller IN VARCHAR2 := NULL
2768: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE
2769: , p_output_dir IN VARCHAR2 := NULL
2770: , p_debug_filename IN VARCHAR2 := NULL
2771: , p_batch_id IN NUMBER
2772: , p_change_number IN VARCHAR2 := NULL

Line 2809: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

2805: -- Standard Start of API savepoint
2806: SAVEPOINT POPULATE_EXISTING_CHANGE;
2807:
2808: -- Standard call to check for call compatibility.
2809: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
2810: p_api_version ,
2811: l_api_name ,
2812: G_PKG_NAME )
2813: THEN

Line 2814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2810: p_api_version ,
2811: l_api_name ,
2812: G_PKG_NAME )
2813: THEN
2814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2815: END IF;
2816:
2817: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
2818: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;

Line 2817: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;

2813: THEN
2814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2815: END IF;
2816:
2817: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
2818: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
2819: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
2820: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
2821:

Line 2818: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;

2814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2815: END IF;
2816:
2817: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
2818: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
2819: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
2820: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
2821:
2822:

Line 2819: l_commit := NVL(p_commit,FND_API.G_FALSE) ;

2815: END IF;
2816:
2817: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
2818: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
2819: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
2820: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
2821:
2822:
2823: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2820: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;

2816:
2817: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
2818: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
2819: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
2820: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
2821:
2822:
2823: -- Initialize message list if p_init_msg_list is set to TRUE.
2824: IF FND_API.to_Boolean( l_init_msg_list ) THEN

Line 2824: IF FND_API.to_Boolean( l_init_msg_list ) THEN

2820: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
2821:
2822:
2823: -- Initialize message list if p_init_msg_list is set to TRUE.
2824: IF FND_API.to_Boolean( l_init_msg_list ) THEN
2825: FND_MSG_PUB.initialize;
2826: END IF;
2827:
2828: -- Open Debug Session by a give param or profile option.

Line 2906: IF l_validation_level > FND_API.G_VALID_LEVEL_NONE AND

2902: Write_Debug(l_dyn_sql);
2903:
2904: EXECUTE IMMEDIATE l_dyn_sql USING p_batch_id ;
2905:
2906: IF l_validation_level > FND_API.G_VALID_LEVEL_NONE AND
2907: FND_API.to_Boolean(l_write_msg_to_intftbl)
2908: THEN
2909:
2910: Write_Debug('Insert Error Message for the records which can not find CO for the Org. . .' );

Line 2907: FND_API.to_Boolean(l_write_msg_to_intftbl)

2903:
2904: EXECUTE IMMEDIATE l_dyn_sql USING p_batch_id ;
2905:
2906: IF l_validation_level > FND_API.G_VALID_LEVEL_NONE AND
2907: FND_API.to_Boolean(l_write_msg_to_intftbl)
2908: THEN
2909:
2910: Write_Debug('Insert Error Message for the records which can not find CO for the Org. . .' );
2911:

Line 2986: IF l_validation_level > FND_API.G_VALID_LEVEL_NONE

2982: l_dyn_sql := l_dyn_sql || ' SET INTF.change_id = null ' ;
2983:
2984: -- If validation level is more than None
2985: -- set the process flag to ERROR:3
2986: IF l_validation_level > FND_API.G_VALID_LEVEL_NONE
2987: THEN
2988: l_dyn_sql := l_dyn_sql || ' , INTF.' || l_intf_proc_flag_col(i) || ' = ' || G_PS_ERROR ;
2989: END IF ;
2990:

Line 3028: IF FND_API.To_Boolean( p_commit ) THEN

3024: -- End of API body.
3025:
3026:
3027: -- Standard check of p_commit.
3028: IF FND_API.To_Boolean( p_commit ) THEN
3029: COMMIT WORK;
3030: END IF;
3031:
3032: -- Standard call to get message count and if count is 1, get message info.

Line 3045: WHEN FND_API.G_EXC_ERROR THEN

3041: Close_Debug_Session;
3042:
3043:
3044: EXCEPTION
3045: WHEN FND_API.G_EXC_ERROR THEN
3046: ROLLBACK TO POPULATE_EXISTING_CHANGE;
3047: x_return_status := G_RET_STS_ERROR ;
3048: FND_MSG_PUB.Count_And_Get
3049: ( p_count => x_msg_count ,

Line 3058: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3054: -- Close Error Handler Debug Session.
3055: -----------------------------------------------------
3056: Close_Debug_Session;
3057:
3058: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3059: ROLLBACK TO POPULATE_EXISTING_CHANGE;
3060: x_return_status := G_RET_STS_UNEXP_ERROR ;
3061: FND_MSG_PUB.Count_And_Get
3062: ( p_count => x_msg_count ,

Line 3107: -- FND_API.G_FALSE

3103: -- Parameters :
3104: -- IN : p_api_version IN NUMBER Required
3105: -- p_init_msg_list IN VARCHAR2 Optional
3106: -- Default = NULL
3107: -- FND_API.G_FALSE
3108: -- FND_API.G_TRUE
3109: -- p_commit IN VARCHAR2 Optional
3110: -- Default = NULL
3111: -- FND_API.G_FALSE

Line 3108: -- FND_API.G_TRUE

3104: -- IN : p_api_version IN NUMBER Required
3105: -- p_init_msg_list IN VARCHAR2 Optional
3106: -- Default = NULL
3107: -- FND_API.G_FALSE
3108: -- FND_API.G_TRUE
3109: -- p_commit IN VARCHAR2 Optional
3110: -- Default = NULL
3111: -- FND_API.G_FALSE
3112: -- FND_API.G_TRUE

Line 3111: -- FND_API.G_FALSE

3107: -- FND_API.G_FALSE
3108: -- FND_API.G_TRUE
3109: -- p_commit IN VARCHAR2 Optional
3110: -- Default = NULL
3111: -- FND_API.G_FALSE
3112: -- FND_API.G_TRUE
3113: -- p_validation_level IN NUMBER Optional
3114: -- Default = NULL
3115: -- Values:

Line 3112: -- FND_API.G_TRUE

3108: -- FND_API.G_TRUE
3109: -- p_commit IN VARCHAR2 Optional
3110: -- Default = NULL
3111: -- FND_API.G_FALSE
3112: -- FND_API.G_TRUE
3113: -- p_validation_level IN NUMBER Optional
3114: -- Default = NULL
3115: -- Values:
3116: -- FND_API.G_VALID_LEVEL_NONE 0

Line 3116: -- FND_API.G_VALID_LEVEL_NONE 0

3112: -- FND_API.G_TRUE
3113: -- p_validation_level IN NUMBER Optional
3114: -- Default = NULL
3115: -- Values:
3116: -- FND_API.G_VALID_LEVEL_NONE 0
3117: -- FND_API.G_VALID_LEVEL_FULL 100
3118: -- p_write_msg_to_intftbl IN VARCHAR2 Optional
3119: -- Default = NULL
3120: -- FND_API.G_FALSE

Line 3117: -- FND_API.G_VALID_LEVEL_FULL 100

3113: -- p_validation_level IN NUMBER Optional
3114: -- Default = NULL
3115: -- Values:
3116: -- FND_API.G_VALID_LEVEL_NONE 0
3117: -- FND_API.G_VALID_LEVEL_FULL 100
3118: -- p_write_msg_to_intftbl IN VARCHAR2 Optional
3119: -- Default = NULL
3120: -- FND_API.G_FALSE
3121: -- FND_API.G_TRUE

Line 3120: -- FND_API.G_FALSE

3116: -- FND_API.G_VALID_LEVEL_NONE 0
3117: -- FND_API.G_VALID_LEVEL_FULL 100
3118: -- p_write_msg_to_intftbl IN VARCHAR2 Optional
3119: -- Default = NULL
3120: -- FND_API.G_FALSE
3121: -- FND_API.G_TRUE
3122: -- p_api_caller IN VARCHAR2 Optional
3123: --
3124: -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)

Line 3121: -- FND_API.G_TRUE

3117: -- FND_API.G_VALID_LEVEL_FULL 100
3118: -- p_write_msg_to_intftbl IN VARCHAR2 Optional
3119: -- Default = NULL
3120: -- FND_API.G_FALSE
3121: -- FND_API.G_TRUE
3122: -- p_api_caller IN VARCHAR2 Optional
3123: --
3124: -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
3125: -- x_msg_count OUT NOCOPY NUMBER

Line 3135: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE

3131: -- Initial version 1.0
3132: --
3133: PROCEDURE POPULATE_EXISTING_REV_ITEMS
3134: ( p_api_version IN NUMBER
3135: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
3136: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
3137: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
3138: , x_return_status OUT NOCOPY VARCHAR2
3139: , x_msg_count OUT NOCOPY NUMBER

Line 3136: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE

3132: --
3133: PROCEDURE POPULATE_EXISTING_REV_ITEMS
3134: ( p_api_version IN NUMBER
3135: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
3136: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
3137: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
3138: , x_return_status OUT NOCOPY VARCHAR2
3139: , x_msg_count OUT NOCOPY NUMBER
3140: , x_msg_data OUT NOCOPY VARCHAR2

Line 3137: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL

3133: PROCEDURE POPULATE_EXISTING_REV_ITEMS
3134: ( p_api_version IN NUMBER
3135: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
3136: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
3137: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
3138: , x_return_status OUT NOCOPY VARCHAR2
3139: , x_msg_count OUT NOCOPY NUMBER
3140: , x_msg_data OUT NOCOPY VARCHAR2
3141: , p_write_msg_to_intftbl IN VARCHAR2 := NULL -- FND_API.G_FALSE

Line 3141: , p_write_msg_to_intftbl IN VARCHAR2 := NULL -- FND_API.G_FALSE

3137: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
3138: , x_return_status OUT NOCOPY VARCHAR2
3139: , x_msg_count OUT NOCOPY NUMBER
3140: , x_msg_data OUT NOCOPY VARCHAR2
3141: , p_write_msg_to_intftbl IN VARCHAR2 := NULL -- FND_API.G_FALSE
3142: , p_api_caller IN VARCHAR2 := NULL
3143: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE
3144: , p_output_dir IN VARCHAR2 := NULL
3145: , p_debug_filename IN VARCHAR2 := NULL

Line 3143: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE

3139: , x_msg_count OUT NOCOPY NUMBER
3140: , x_msg_data OUT NOCOPY VARCHAR2
3141: , p_write_msg_to_intftbl IN VARCHAR2 := NULL -- FND_API.G_FALSE
3142: , p_api_caller IN VARCHAR2 := NULL
3143: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE
3144: , p_output_dir IN VARCHAR2 := NULL
3145: , p_debug_filename IN VARCHAR2 := NULL
3146: , p_batch_id IN NUMBER
3147: , p_process_entity IN VARCHAR2 := NULL

Line 3188: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

3184: -- Standard Start of API savepoint
3185: SAVEPOINT POPULATE_EXISTING_REV_ITEMS;
3186:
3187: -- Standard call to check for call compatibility.
3188: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
3189: p_api_version ,
3190: l_api_name ,
3191: G_PKG_NAME )
3192: THEN

Line 3193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3189: p_api_version ,
3190: l_api_name ,
3191: G_PKG_NAME )
3192: THEN
3193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3194: END IF;
3195:
3196: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
3197: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;

Line 3196: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;

3192: THEN
3193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3194: END IF;
3195:
3196: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
3197: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
3198: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
3199: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
3200:

Line 3197: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;

3193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3194: END IF;
3195:
3196: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
3197: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
3198: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
3199: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
3200:
3201:

Line 3198: l_commit := NVL(p_commit,FND_API.G_FALSE) ;

3194: END IF;
3195:
3196: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
3197: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
3198: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
3199: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
3200:
3201:
3202: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 3199: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;

3195:
3196: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
3197: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
3198: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
3199: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
3200:
3201:
3202: -- Initialize message list if p_init_msg_list is set to TRUE.
3203: IF FND_API.to_Boolean( l_init_msg_list ) THEN

Line 3203: IF FND_API.to_Boolean( l_init_msg_list ) THEN

3199: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
3200:
3201:
3202: -- Initialize message list if p_init_msg_list is set to TRUE.
3203: IF FND_API.to_Boolean( l_init_msg_list ) THEN
3204: FND_MSG_PUB.initialize;
3205: END IF;
3206:
3207: -- Open Debug Session by a give param or profile option.

Line 3283: IF l_validation_level > FND_API.G_VALID_LEVEL_NONE

3279: END IF ;
3280:
3281:
3282: -- param: p_default_seq_id
3283: IF l_validation_level > FND_API.G_VALID_LEVEL_NONE
3284: THEN
3285: l_dyn_sql := l_dyn_sql || ', -100';
3286: ELSE
3287: l_dyn_sql := l_dyn_sql || ', TO_NUMBER(null)';

Line 3309: IF l_validation_level > FND_API.G_VALID_LEVEL_NONE

3305:
3306: EXECUTE IMMEDIATE l_dyn_sql USING p_batch_id ;
3307:
3308:
3309: IF l_validation_level > FND_API.G_VALID_LEVEL_NONE
3310: THEN
3311: -- Initialize message list if p_init_msg_list is set to TRUE.
3312: IF FND_API.to_Boolean(l_write_msg_to_intftbl) THEN
3313:

Line 3312: IF FND_API.to_Boolean(l_write_msg_to_intftbl) THEN

3308:
3309: IF l_validation_level > FND_API.G_VALID_LEVEL_NONE
3310: THEN
3311: -- Initialize message list if p_init_msg_list is set to TRUE.
3312: IF FND_API.to_Boolean(l_write_msg_to_intftbl) THEN
3313:
3314: Write_Debug('Insert Error Message for the records which can not find CO for the Org. . .' );
3315:
3316: FND_MESSAGE.SET_NAME('ENG','ENG_IMPT_RI_NOT_FOUND');

Line 3412: , p_init_msg_list => FND_API.G_FALSE

3408: Write_Debug('Calling POPULATE_MFGPARTNUM_INTF. . . ' );
3409:
3410: POPULATE_MFGPARTNUM_INTF
3411: ( p_api_version => 1.0
3412: , p_init_msg_list => FND_API.G_FALSE
3413: , p_commit => FND_API.G_FALSE
3414: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
3415: , x_return_status => l_return_status
3416: , x_msg_count => l_msg_count

Line 3413: , p_commit => FND_API.G_FALSE

3409:
3410: POPULATE_MFGPARTNUM_INTF
3411: ( p_api_version => 1.0
3412: , p_init_msg_list => FND_API.G_FALSE
3413: , p_commit => FND_API.G_FALSE
3414: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
3415: , x_return_status => l_return_status
3416: , x_msg_count => l_msg_count
3417: , x_msg_data => l_msg_data

Line 3414: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

3410: POPULATE_MFGPARTNUM_INTF
3411: ( p_api_version => 1.0
3412: , p_init_msg_list => FND_API.G_FALSE
3413: , p_commit => FND_API.G_FALSE
3414: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
3415: , x_return_status => l_return_status
3416: , x_msg_count => l_msg_count
3417: , x_msg_data => l_msg_data
3418: , p_write_msg_to_intftbl => FND_API.G_TRUE

Line 3418: , p_write_msg_to_intftbl => FND_API.G_TRUE

3414: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
3415: , x_return_status => l_return_status
3416: , x_msg_count => l_msg_count
3417: , x_msg_data => l_msg_data
3418: , p_write_msg_to_intftbl => FND_API.G_TRUE
3419: , p_api_caller => NULL
3420: , p_debug => p_debug
3421: , p_output_dir => p_output_dir
3422: , p_debug_filename => p_debug_filename

Line 3437: RAISE FND_API.G_EXC_ERROR ;

3433: x_return_status := l_return_status ;
3434: x_msg_count := l_msg_count ;
3435: x_msg_data := l_msg_data ;
3436:
3437: RAISE FND_API.G_EXC_ERROR ;
3438: END IF ;
3439:
3440: END IF ;
3441:

Line 3451: IF FND_API.To_Boolean( p_commit ) THEN

3447: -- End of API body.
3448:
3449:
3450: -- Standard check of p_commit.
3451: IF FND_API.To_Boolean( p_commit ) THEN
3452: COMMIT WORK;
3453: END IF;
3454:
3455: -- Standard call to get message count and if count is 1, get message info.

Line 3469: WHEN FND_API.G_EXC_ERROR THEN

3465: Close_Debug_Session;
3466:
3467:
3468: EXCEPTION
3469: WHEN FND_API.G_EXC_ERROR THEN
3470: ROLLBACK TO POPULATE_EXISTING_REV_ITEMS;
3471: x_return_status := G_RET_STS_ERROR ;
3472: FND_MSG_PUB.Count_And_Get
3473: ( p_count => x_msg_count ,

Line 3482: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3478: -- Close Error Handler Debug Session.
3479: -----------------------------------------------------
3480: Close_Debug_Session;
3481:
3482: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3483:
3484: ROLLBACK TO POPULATE_EXISTING_REV_ITEMS;
3485: x_return_status := G_RET_STS_UNEXP_ERROR ;
3486: FND_MSG_PUB.Count_And_Get

Line 3533: -- FND_API.G_FALSE

3529: -- Parameters :
3530: -- IN : p_api_version IN NUMBER Required
3531: -- p_init_msg_list IN VARCHAR2 Optional
3532: -- Default = NULL
3533: -- FND_API.G_FALSE
3534: -- FND_API.G_TRUE
3535: -- p_commit IN VARCHAR2 Optional
3536: -- Default = NULL
3537: -- FND_API.G_FALSE

Line 3534: -- FND_API.G_TRUE

3530: -- IN : p_api_version IN NUMBER Required
3531: -- p_init_msg_list IN VARCHAR2 Optional
3532: -- Default = NULL
3533: -- FND_API.G_FALSE
3534: -- FND_API.G_TRUE
3535: -- p_commit IN VARCHAR2 Optional
3536: -- Default = NULL
3537: -- FND_API.G_FALSE
3538: -- FND_API.G_TRUE

Line 3537: -- FND_API.G_FALSE

3533: -- FND_API.G_FALSE
3534: -- FND_API.G_TRUE
3535: -- p_commit IN VARCHAR2 Optional
3536: -- Default = NULL
3537: -- FND_API.G_FALSE
3538: -- FND_API.G_TRUE
3539: -- p_validation_level IN NUMBER Optional
3540: -- Default = NULL
3541: -- Values:

Line 3538: -- FND_API.G_TRUE

3534: -- FND_API.G_TRUE
3535: -- p_commit IN VARCHAR2 Optional
3536: -- Default = NULL
3537: -- FND_API.G_FALSE
3538: -- FND_API.G_TRUE
3539: -- p_validation_level IN NUMBER Optional
3540: -- Default = NULL
3541: -- Values:
3542: -- FND_API.G_VALID_LEVEL_NONE 0

Line 3542: -- FND_API.G_VALID_LEVEL_NONE 0

3538: -- FND_API.G_TRUE
3539: -- p_validation_level IN NUMBER Optional
3540: -- Default = NULL
3541: -- Values:
3542: -- FND_API.G_VALID_LEVEL_NONE 0
3543: -- FND_API.G_VALID_LEVEL_FULL 100
3544: -- p_write_msg_to_intftbl IN VARCHAR2 Optional
3545: -- Default = NULL
3546: -- FND_API.G_FALSE

Line 3543: -- FND_API.G_VALID_LEVEL_FULL 100

3539: -- p_validation_level IN NUMBER Optional
3540: -- Default = NULL
3541: -- Values:
3542: -- FND_API.G_VALID_LEVEL_NONE 0
3543: -- FND_API.G_VALID_LEVEL_FULL 100
3544: -- p_write_msg_to_intftbl IN VARCHAR2 Optional
3545: -- Default = NULL
3546: -- FND_API.G_FALSE
3547: -- FND_API.G_TRUE

Line 3546: -- FND_API.G_FALSE

3542: -- FND_API.G_VALID_LEVEL_NONE 0
3543: -- FND_API.G_VALID_LEVEL_FULL 100
3544: -- p_write_msg_to_intftbl IN VARCHAR2 Optional
3545: -- Default = NULL
3546: -- FND_API.G_FALSE
3547: -- FND_API.G_TRUE
3548: -- p_api_caller IN VARCHAR2 Optional
3549: --
3550: -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)

Line 3547: -- FND_API.G_TRUE

3543: -- FND_API.G_VALID_LEVEL_FULL 100
3544: -- p_write_msg_to_intftbl IN VARCHAR2 Optional
3545: -- Default = NULL
3546: -- FND_API.G_FALSE
3547: -- FND_API.G_TRUE
3548: -- p_api_caller IN VARCHAR2 Optional
3549: --
3550: -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
3551: -- x_msg_count OUT NOCOPY NUMBER

Line 3561: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE

3557: -- Initial version 1.0
3558: --
3559: PROCEDURE UPDATE_PROCESS_STATUS
3560: ( p_api_version IN NUMBER
3561: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
3562: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
3563: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
3564: , x_return_status OUT NOCOPY VARCHAR2
3565: , x_msg_count OUT NOCOPY NUMBER

Line 3562: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE

3558: --
3559: PROCEDURE UPDATE_PROCESS_STATUS
3560: ( p_api_version IN NUMBER
3561: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
3562: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
3563: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
3564: , x_return_status OUT NOCOPY VARCHAR2
3565: , x_msg_count OUT NOCOPY NUMBER
3566: , x_msg_data OUT NOCOPY VARCHAR2

Line 3563: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL

3559: PROCEDURE UPDATE_PROCESS_STATUS
3560: ( p_api_version IN NUMBER
3561: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
3562: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
3563: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
3564: , x_return_status OUT NOCOPY VARCHAR2
3565: , x_msg_count OUT NOCOPY NUMBER
3566: , x_msg_data OUT NOCOPY VARCHAR2
3567: , p_write_msg_to_intftbl IN VARCHAR2 := NULL -- FND_API.G_FALSE

Line 3567: , p_write_msg_to_intftbl IN VARCHAR2 := NULL -- FND_API.G_FALSE

3563: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
3564: , x_return_status OUT NOCOPY VARCHAR2
3565: , x_msg_count OUT NOCOPY NUMBER
3566: , x_msg_data OUT NOCOPY VARCHAR2
3567: , p_write_msg_to_intftbl IN VARCHAR2 := NULL -- FND_API.G_FALSE
3568: , p_api_caller IN VARCHAR2 := NULL
3569: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE
3570: , p_output_dir IN VARCHAR2 := NULL
3571: , p_debug_filename IN VARCHAR2 := NULL

Line 3569: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE

3565: , x_msg_count OUT NOCOPY NUMBER
3566: , x_msg_data OUT NOCOPY VARCHAR2
3567: , p_write_msg_to_intftbl IN VARCHAR2 := NULL -- FND_API.G_FALSE
3568: , p_api_caller IN VARCHAR2 := NULL
3569: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE
3570: , p_output_dir IN VARCHAR2 := NULL
3571: , p_debug_filename IN VARCHAR2 := NULL
3572: , p_batch_id IN NUMBER
3573: , p_from_status IN NUMBER

Line 3615: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

3611: -- Standard Start of API savepoint
3612: SAVEPOINT UPDATE_PROCESS_STATUS;
3613:
3614: -- Standard call to check for call compatibility.
3615: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
3616: p_api_version ,
3617: l_api_name ,
3618: G_PKG_NAME )
3619: THEN

Line 3620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3616: p_api_version ,
3617: l_api_name ,
3618: G_PKG_NAME )
3619: THEN
3620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3621: END IF;
3622:
3623: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
3624: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;

Line 3623: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;

3619: THEN
3620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3621: END IF;
3622:
3623: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
3624: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
3625: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
3626: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
3627:

Line 3624: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;

3620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3621: END IF;
3622:
3623: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
3624: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
3625: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
3626: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
3627:
3628:

Line 3625: l_commit := NVL(p_commit,FND_API.G_FALSE) ;

3621: END IF;
3622:
3623: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
3624: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
3625: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
3626: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
3627:
3628:
3629: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 3626: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;

3622:
3623: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
3624: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
3625: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
3626: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
3627:
3628:
3629: -- Initialize message list if p_init_msg_list is set to TRUE.
3630: IF FND_API.to_Boolean( l_init_msg_list ) THEN

Line 3630: IF FND_API.to_Boolean( l_init_msg_list ) THEN

3626: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
3627:
3628:
3629: -- Initialize message list if p_init_msg_list is set to TRUE.
3630: IF FND_API.to_Boolean( l_init_msg_list ) THEN
3631: FND_MSG_PUB.initialize;
3632: END IF;
3633:
3634: -- Open Debug Session by a give param or profile option.

Line 3725: IF FND_API.To_Boolean( p_commit ) THEN

3721: -- End of API body.
3722:
3723:
3724: -- Standard check of p_commit.
3725: IF FND_API.To_Boolean( p_commit ) THEN
3726: COMMIT WORK;
3727: END IF;
3728:
3729: -- Standard call to get message count and if count is 1, get message info.

Line 3743: WHEN FND_API.G_EXC_ERROR THEN

3739: Close_Debug_Session;
3740:
3741:
3742: EXCEPTION
3743: WHEN FND_API.G_EXC_ERROR THEN
3744: ROLLBACK TO UPDATE_PROCESS_STATUS;
3745: x_return_status := G_RET_STS_ERROR ;
3746: FND_MSG_PUB.Count_And_Get
3747: ( p_count => x_msg_count ,

Line 3756: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3752: -- Close Error Handler Debug Session.
3753: -----------------------------------------------------
3754: Close_Debug_Session;
3755:
3756: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3757: ROLLBACK TO UPDATE_PROCESS_STATUS;
3758: x_return_status := G_RET_STS_UNEXP_ERROR ;
3759: FND_MSG_PUB.Count_And_Get
3760: ( p_count => x_msg_count ,

Line 4000: , p_init_msg_list => FND_API.G_FALSE

3996: Write_Debug('Before calling Eng_Revised_Item_Pkg.Query_Target_Revised_Item') ;
3997:
3998: Eng_Revised_Items_Pkg.Query_Target_Revised_Item (
3999: p_api_version => 1.0
4000: , p_init_msg_list => FND_API.G_FALSE
4001: , x_return_status => l_return_status
4002: , x_msg_count => l_msg_count
4003: , x_msg_data => l_msg_data
4004: , p_change_id => p_change_id

Line 4019: RAISE FND_API.G_EXC_ERROR ;

4015:
4016: IF l_return_status <> G_RET_STS_SUCCESS
4017: THEN
4018: Write_Debug('After calling Eng_Revised_Item_Pkg.Query_Target_Revised_Item: Return Msg: ' || l_msg_data );
4019: RAISE FND_API.G_EXC_ERROR ;
4020: END IF ;
4021:
4022: IF l_rev_item_seq_id IS NULL OR l_rev_item_seq_id <= 0
4023: THEN

Line 4041: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE

4037: -- Procedure to create component interface rows given the component details
4038: --
4039: PROCEDURE CREATE_ORPHAN_COMPONENT_INTF
4040: ( p_api_version IN NUMBER
4041: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
4042: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
4043: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
4044: , x_return_status OUT NOCOPY VARCHAR2
4045: , x_msg_count OUT NOCOPY NUMBER

Line 4042: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE

4038: --
4039: PROCEDURE CREATE_ORPHAN_COMPONENT_INTF
4040: ( p_api_version IN NUMBER
4041: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
4042: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
4043: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
4044: , x_return_status OUT NOCOPY VARCHAR2
4045: , x_msg_count OUT NOCOPY NUMBER
4046: , x_msg_data OUT NOCOPY VARCHAR2

Line 4043: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL

4039: PROCEDURE CREATE_ORPHAN_COMPONENT_INTF
4040: ( p_api_version IN NUMBER
4041: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
4042: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
4043: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
4044: , x_return_status OUT NOCOPY VARCHAR2
4045: , x_msg_count OUT NOCOPY NUMBER
4046: , x_msg_data OUT NOCOPY VARCHAR2
4047: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE

Line 4047: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE

4043: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
4044: , x_return_status OUT NOCOPY VARCHAR2
4045: , x_msg_count OUT NOCOPY NUMBER
4046: , x_msg_data OUT NOCOPY VARCHAR2
4047: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE
4048: , p_output_dir IN VARCHAR2 := NULL
4049: , p_debug_filename IN VARCHAR2 := NULL
4050: , p_organization_id IN NUMBER
4051: , p_assembly_item_id IN NUMBER

Line 4087: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

4083: -- Standard Start of API savepoint
4084: SAVEPOINT CREATE_ORPHAN_COMPONENT_INTF;
4085:
4086: -- Standard call to check for call compatibility.
4087: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
4088: p_api_version ,
4089: l_api_name ,
4090: G_PKG_NAME )
4091: THEN

Line 4092: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4088: p_api_version ,
4089: l_api_name ,
4090: G_PKG_NAME )
4091: THEN
4092: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4093: END IF;
4094:
4095: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
4096: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;

Line 4095: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;

4091: THEN
4092: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4093: END IF;
4094:
4095: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
4096: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
4097: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
4098:
4099:

Line 4096: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;

4092: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4093: END IF;
4094:
4095: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
4096: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
4097: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
4098:
4099:
4100:

Line 4097: l_commit := NVL(p_commit,FND_API.G_FALSE) ;

4093: END IF;
4094:
4095: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
4096: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
4097: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
4098:
4099:
4100:
4101: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 4102: IF FND_API.to_Boolean( l_init_msg_list ) THEN

4098:
4099:
4100:
4101: -- Initialize message list if p_init_msg_list is set to TRUE.
4102: IF FND_API.to_Boolean( l_init_msg_list ) THEN
4103: FND_MSG_PUB.initialize;
4104: END IF;
4105:
4106: -- Open Debug Session by a give param or profile option.

Line 4264: IF FND_API.To_Boolean( p_commit ) THEN

4260: Write_Debug('Done Inserting data into interface tables:');
4261: -- End of API body.
4262:
4263: -- Standard check of p_commit.
4264: IF FND_API.To_Boolean( p_commit ) THEN
4265: COMMIT WORK;
4266: END IF;
4267:
4268: -- Standard call to get message count and if count is 1, get message info.

Line 4281: WHEN FND_API.G_EXC_ERROR THEN

4277: -----------------------------------------------------
4278: Close_Debug_Session;
4279:
4280: EXCEPTION
4281: WHEN FND_API.G_EXC_ERROR THEN
4282: ROLLBACK TO CREATE_ORPHAN_COMPONENT_INTF;
4283: x_return_status := G_RET_STS_ERROR ;
4284: FND_MSG_PUB.Count_And_Get
4285: ( p_count => x_msg_count ,

Line 4294: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4290: -- Close Error Handler Debug Session.
4291: -----------------------------------------------------
4292: Close_Debug_Session;
4293:
4294: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4295: ROLLBACK TO CREATE_ORPHAN_COMPONENT_INTF;
4296: x_return_status := G_RET_STS_UNEXP_ERROR ;
4297: FND_MSG_PUB.Count_And_Get
4298: ( p_count => x_msg_count ,

Line 4343: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE

4339: -- Procedure to create structure header interface rows given the component details
4340: --
4341: PROCEDURE CREATE_ORPHAN_HEADER_INTF
4342: ( p_api_version IN NUMBER
4343: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
4344: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
4345: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
4346: , x_return_status OUT NOCOPY VARCHAR2
4347: , x_msg_count OUT NOCOPY NUMBER

Line 4344: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE

4340: --
4341: PROCEDURE CREATE_ORPHAN_HEADER_INTF
4342: ( p_api_version IN NUMBER
4343: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
4344: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
4345: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
4346: , x_return_status OUT NOCOPY VARCHAR2
4347: , x_msg_count OUT NOCOPY NUMBER
4348: , x_msg_data OUT NOCOPY VARCHAR2

Line 4345: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL

4341: PROCEDURE CREATE_ORPHAN_HEADER_INTF
4342: ( p_api_version IN NUMBER
4343: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
4344: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
4345: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
4346: , x_return_status OUT NOCOPY VARCHAR2
4347: , x_msg_count OUT NOCOPY NUMBER
4348: , x_msg_data OUT NOCOPY VARCHAR2
4349: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE

Line 4349: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE

4345: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
4346: , x_return_status OUT NOCOPY VARCHAR2
4347: , x_msg_count OUT NOCOPY NUMBER
4348: , x_msg_data OUT NOCOPY VARCHAR2
4349: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE
4350: , p_output_dir IN VARCHAR2 := NULL
4351: , p_debug_filename IN VARCHAR2 := NULL
4352: , p_organization_id IN NUMBER
4353: , p_assembly_item_id IN NUMBER

Line 4376: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

4372: -- Standard Start of API savepoint
4373: SAVEPOINT CREATE_ORPHAN_HEADER_INTF;
4374:
4375: -- Standard call to check for call compatibility.
4376: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
4377: p_api_version ,
4378: l_api_name ,
4379: G_PKG_NAME )
4380: THEN

Line 4381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4377: p_api_version ,
4378: l_api_name ,
4379: G_PKG_NAME )
4380: THEN
4381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4382: END IF;
4383:
4384: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
4385: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;

Line 4384: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;

4380: THEN
4381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4382: END IF;
4383:
4384: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
4385: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
4386: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
4387:
4388:

Line 4385: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;

4381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4382: END IF;
4383:
4384: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
4385: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
4386: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
4387:
4388:
4389:

Line 4386: l_commit := NVL(p_commit,FND_API.G_FALSE) ;

4382: END IF;
4383:
4384: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
4385: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
4386: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
4387:
4388:
4389:
4390: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 4391: IF FND_API.to_Boolean( l_init_msg_list ) THEN

4387:
4388:
4389:
4390: -- Initialize message list if p_init_msg_list is set to TRUE.
4391: IF FND_API.to_Boolean( l_init_msg_list ) THEN
4392: FND_MSG_PUB.initialize;
4393: END IF;
4394:
4395: -- Open Debug Session by a give param or profile option.

Line 4475: IF FND_API.To_Boolean( p_commit ) THEN

4471: Write_Debug('Done Inserting data into interface tables:');
4472: -- End of API body.
4473:
4474: -- Standard check of p_commit.
4475: IF FND_API.To_Boolean( p_commit ) THEN
4476: COMMIT WORK;
4477: END IF;
4478:
4479: -- Standard call to get message count and if count is 1, get message info.

Line 4492: WHEN FND_API.G_EXC_ERROR THEN

4488: -----------------------------------------------------
4489: Close_Debug_Session;
4490:
4491: EXCEPTION
4492: WHEN FND_API.G_EXC_ERROR THEN
4493: ROLLBACK TO CREATE_ORPHAN_HEADER_INTF;
4494: x_return_status := G_RET_STS_ERROR ;
4495: FND_MSG_PUB.Count_And_Get
4496: ( p_count => x_msg_count ,

Line 4505: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4501: -- Close Error Handler Debug Session.
4502: -----------------------------------------------------
4503: Close_Debug_Session;
4504:
4505: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4506: ROLLBACK TO CREATE_ORPHAN_HEADER_INTF;
4507: x_return_status := G_RET_STS_UNEXP_ERROR ;
4508: FND_MSG_PUB.Count_And_Get
4509: ( p_count => x_msg_count ,

Line 4554: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE

4550: -- Procedure to create structure header interface rows given the component details
4551: --
4552: PROCEDURE PREPROCESS_COMP_CHILD_ROWS
4553: ( p_api_version IN NUMBER
4554: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
4555: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
4556: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
4557: , x_return_status OUT NOCOPY VARCHAR2
4558: , x_msg_count OUT NOCOPY NUMBER

Line 4555: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE

4551: --
4552: PROCEDURE PREPROCESS_COMP_CHILD_ROWS
4553: ( p_api_version IN NUMBER
4554: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
4555: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
4556: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
4557: , x_return_status OUT NOCOPY VARCHAR2
4558: , x_msg_count OUT NOCOPY NUMBER
4559: , x_msg_data OUT NOCOPY VARCHAR2

Line 4556: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL

4552: PROCEDURE PREPROCESS_COMP_CHILD_ROWS
4553: ( p_api_version IN NUMBER
4554: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
4555: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
4556: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
4557: , x_return_status OUT NOCOPY VARCHAR2
4558: , x_msg_count OUT NOCOPY NUMBER
4559: , x_msg_data OUT NOCOPY VARCHAR2
4560: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE

Line 4560: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE

4556: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
4557: , x_return_status OUT NOCOPY VARCHAR2
4558: , x_msg_count OUT NOCOPY NUMBER
4559: , x_msg_data OUT NOCOPY VARCHAR2
4560: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE
4561: , p_output_dir IN VARCHAR2 := NULL
4562: , p_debug_filename IN VARCHAR2 := NULL
4563: , p_organization_id IN NUMBER
4564: , p_assembly_item_id IN NUMBER

Line 4586: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

4582: -- Standard Start of API savepoint
4583: SAVEPOINT PREPROCESS_COMP_CHILD_ROWS;
4584:
4585: -- Standard call to check for call compatibility.
4586: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
4587: p_api_version ,
4588: l_api_name ,
4589: G_PKG_NAME )
4590: THEN

Line 4591: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4587: p_api_version ,
4588: l_api_name ,
4589: G_PKG_NAME )
4590: THEN
4591: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4592: END IF;
4593:
4594: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
4595: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;

Line 4594: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;

4590: THEN
4591: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4592: END IF;
4593:
4594: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
4595: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
4596: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
4597:
4598:

Line 4595: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;

4591: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4592: END IF;
4593:
4594: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
4595: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
4596: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
4597:
4598:
4599:

Line 4596: l_commit := NVL(p_commit,FND_API.G_FALSE) ;

4592: END IF;
4593:
4594: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
4595: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
4596: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
4597:
4598:
4599:
4600: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 4601: IF FND_API.to_Boolean( l_init_msg_list ) THEN

4597:
4598:
4599:
4600: -- Initialize message list if p_init_msg_list is set to TRUE.
4601: IF FND_API.to_Boolean( l_init_msg_list ) THEN
4602: FND_MSG_PUB.initialize;
4603: END IF;
4604:
4605: -- Open Debug Session by a give param or profile option.

Line 4683: IF FND_API.To_Boolean( p_commit ) THEN

4679:
4680: -- End of API body.
4681:
4682: -- Standard check of p_commit.
4683: IF FND_API.To_Boolean( p_commit ) THEN
4684: COMMIT WORK;
4685: END IF;
4686:
4687: -- Standard call to get message count and if count is 1, get message info.

Line 4700: WHEN FND_API.G_EXC_ERROR THEN

4696: -----------------------------------------------------
4697: Close_Debug_Session;
4698:
4699: EXCEPTION
4700: WHEN FND_API.G_EXC_ERROR THEN
4701: ROLLBACK TO PREPROCESS_COMP_CHILD_ROWS;
4702: x_return_status := G_RET_STS_ERROR ;
4703: FND_MSG_PUB.Count_And_Get
4704: ( p_count => x_msg_count ,

Line 4713: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4709: -- Close Error Handler Debug Session.
4710: -----------------------------------------------------
4711: Close_Debug_Session;
4712:
4713: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4714: ROLLBACK TO PREPROCESS_COMP_CHILD_ROWS;
4715: x_return_status := G_RET_STS_UNEXP_ERROR ;
4716: FND_MSG_PUB.Count_And_Get
4717: ( p_count => x_msg_count ,

Line 4779: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE

4775: --
4776: --
4777: PROCEDURE PREPROCESS_BOM_INTERFACE_ROWS
4778: ( p_api_version IN NUMBER
4779: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
4780: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
4781: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
4782: , x_return_status OUT NOCOPY VARCHAR2
4783: , x_msg_count OUT NOCOPY NUMBER

Line 4780: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE

4776: --
4777: PROCEDURE PREPROCESS_BOM_INTERFACE_ROWS
4778: ( p_api_version IN NUMBER
4779: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
4780: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
4781: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
4782: , x_return_status OUT NOCOPY VARCHAR2
4783: , x_msg_count OUT NOCOPY NUMBER
4784: , x_msg_data OUT NOCOPY VARCHAR2

Line 4781: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL

4777: PROCEDURE PREPROCESS_BOM_INTERFACE_ROWS
4778: ( p_api_version IN NUMBER
4779: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
4780: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
4781: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
4782: , x_return_status OUT NOCOPY VARCHAR2
4783: , x_msg_count OUT NOCOPY NUMBER
4784: , x_msg_data OUT NOCOPY VARCHAR2
4785: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE

Line 4785: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE

4781: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
4782: , x_return_status OUT NOCOPY VARCHAR2
4783: , x_msg_count OUT NOCOPY NUMBER
4784: , x_msg_data OUT NOCOPY VARCHAR2
4785: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE
4786: , p_output_dir IN VARCHAR2 := NULL
4787: , p_debug_filename IN VARCHAR2 := NULL
4788: , p_change_id IN NUMBER
4789: , p_change_notice IN VARCHAR2

Line 4824: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

4820: -- Standard Start of API savepoint
4821: SAVEPOINT PREPROCESS_BOM_INTERFACE_ROWS;
4822:
4823: -- Standard call to check for call compatibility.
4824: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
4825: p_api_version ,
4826: l_api_name ,
4827: G_PKG_NAME )
4828: THEN

Line 4829: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4825: p_api_version ,
4826: l_api_name ,
4827: G_PKG_NAME )
4828: THEN
4829: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4830: END IF;
4831:
4832: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
4833: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;

Line 4832: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;

4828: THEN
4829: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4830: END IF;
4831:
4832: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
4833: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
4834: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
4835:
4836:

Line 4833: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;

4829: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4830: END IF;
4831:
4832: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
4833: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
4834: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
4835:
4836:
4837:

Line 4834: l_commit := NVL(p_commit,FND_API.G_FALSE) ;

4830: END IF;
4831:
4832: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
4833: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
4834: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
4835:
4836:
4837:
4838: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 4839: IF FND_API.to_Boolean( l_init_msg_list ) THEN

4835:
4836:
4837:
4838: -- Initialize message list if p_init_msg_list is set to TRUE.
4839: IF FND_API.to_Boolean( l_init_msg_list ) THEN
4840: FND_MSG_PUB.initialize;
4841: END IF;
4842:
4843: -- Open Debug Session by a give param or profile option.

Line 4917: AND NVL(new_from_end_item_unit_number, NVL(from_end_item_unit_number, FND_API.G_MISS_CHAR))

4913: FROM mtl_item_revisions
4914: WHERE revision_id = parent_revision_id )),
4915: new_effectivity_date) <= p_current_date AND
4916: p_current_date = p_effectivity_date))
4917: AND NVL(new_from_end_item_unit_number, NVL(from_end_item_unit_number, FND_API.G_MISS_CHAR))
4918: = NVL(p_from_end_item_unit_number, FND_API.G_MISS_CHAR)
4919: AND NVL(from_end_item_rev_id, '-1') = NVL(p_from_end_item_rev_id, '-1')
4920: AND change_id = p_change_id
4921: AND batch_id = p_batch_id

Line 4918: = NVL(p_from_end_item_unit_number, FND_API.G_MISS_CHAR)

4914: WHERE revision_id = parent_revision_id )),
4915: new_effectivity_date) <= p_current_date AND
4916: p_current_date = p_effectivity_date))
4917: AND NVL(new_from_end_item_unit_number, NVL(from_end_item_unit_number, FND_API.G_MISS_CHAR))
4918: = NVL(p_from_end_item_unit_number, FND_API.G_MISS_CHAR)
4919: AND NVL(from_end_item_rev_id, '-1') = NVL(p_from_end_item_rev_id, '-1')
4920: AND change_id = p_change_id
4921: AND batch_id = p_batch_id
4922: AND process_flag = G_CM_TO_BE_PROCESSED

Line 4945: AND NVL(new_from_end_item_unit_number, NVL(from_end_item_unit_number, FND_API.G_MISS_CHAR))

4941: AND assembly_item_id = p_revised_item_id
4942: AND organization_id = p_organization_id
4943: AND (alternate_bom_designator = p_alternate_bom_designator
4944: OR (alternate_bom_designator IS NULL AND p_alternate_bom_designator IS NULL))))
4945: AND NVL(new_from_end_item_unit_number, NVL(from_end_item_unit_number, FND_API.G_MISS_CHAR))
4946: = NVL(p_from_end_item_unit_number, FND_API.G_MISS_CHAR)
4947: AND NVL(from_end_item_rev_id, '-1')
4948: = NVL(p_from_end_item_rev_id, '-1')
4949: AND ((p_effectivity_date IS NULL AND effectivity_date IS NULL)

Line 4946: = NVL(p_from_end_item_unit_number, FND_API.G_MISS_CHAR)

4942: AND organization_id = p_organization_id
4943: AND (alternate_bom_designator = p_alternate_bom_designator
4944: OR (alternate_bom_designator IS NULL AND p_alternate_bom_designator IS NULL))))
4945: AND NVL(new_from_end_item_unit_number, NVL(from_end_item_unit_number, FND_API.G_MISS_CHAR))
4946: = NVL(p_from_end_item_unit_number, FND_API.G_MISS_CHAR)
4947: AND NVL(from_end_item_rev_id, '-1')
4948: = NVL(p_from_end_item_rev_id, '-1')
4949: AND ((p_effectivity_date IS NULL AND effectivity_date IS NULL)
4950: OR (decode (new_effectivity_date,

Line 5003: AND NVL(new_from_end_item_unit_number, NVL(from_end_item_unit_number, FND_API.G_MISS_CHAR))

4999: AND assembly_item_id = p_revised_item_id
5000: AND organization_id = p_organization_id
5001: AND (alternate_bom_designator = p_alternate_bom_designator
5002: OR (alternate_bom_designator IS NULL AND p_alternate_bom_designator IS NULL))))
5003: AND NVL(new_from_end_item_unit_number, NVL(from_end_item_unit_number, FND_API.G_MISS_CHAR))
5004: = NVL(p_from_end_item_unit_number, FND_API.G_MISS_CHAR)
5005: AND NVL(from_end_item_rev_id, '-1')
5006: = NVL(p_from_end_item_rev_id, '-1')
5007: AND ((p_effectivity_date IS NULL AND effectivity_date IS NULL)

Line 5004: = NVL(p_from_end_item_unit_number, FND_API.G_MISS_CHAR)

5000: AND organization_id = p_organization_id
5001: AND (alternate_bom_designator = p_alternate_bom_designator
5002: OR (alternate_bom_designator IS NULL AND p_alternate_bom_designator IS NULL))))
5003: AND NVL(new_from_end_item_unit_number, NVL(from_end_item_unit_number, FND_API.G_MISS_CHAR))
5004: = NVL(p_from_end_item_unit_number, FND_API.G_MISS_CHAR)
5005: AND NVL(from_end_item_rev_id, '-1')
5006: = NVL(p_from_end_item_rev_id, '-1')
5007: AND ((p_effectivity_date IS NULL AND effectivity_date IS NULL)
5008: OR (decode (new_effectivity_date,

Line 5112: IF FND_API.To_Boolean( p_commit ) THEN

5108:
5109: -- End of API body.
5110:
5111: -- Standard check of p_commit.
5112: IF FND_API.To_Boolean( p_commit ) THEN
5113: COMMIT WORK;
5114: END IF;
5115:
5116: -- Standard call to get message count and if count is 1, get message info.

Line 5129: WHEN FND_API.G_EXC_ERROR THEN

5125: -----------------------------------------------------
5126: Close_Debug_Session;
5127:
5128: EXCEPTION
5129: WHEN FND_API.G_EXC_ERROR THEN
5130: ROLLBACK TO PREPROCESS_BOM_INTERFACE_ROWS;
5131: x_return_status := G_RET_STS_ERROR ;
5132: FND_MSG_PUB.Count_And_Get
5133: ( p_count => x_msg_count ,

Line 5142: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5138: -- Close Error Handler Debug Session.
5139: -----------------------------------------------------
5140: Close_Debug_Session;
5141:
5142: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5143: ROLLBACK TO PREPROCESS_BOM_INTERFACE_ROWS;
5144: x_return_status := G_RET_STS_UNEXP_ERROR ;
5145: FND_MSG_PUB.Count_And_Get
5146: ( p_count => x_msg_count ,

Line 5194: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE

5190: * Purpose : Perform Import Change Table Handler
5191: *********************************************************************/
5192: PROCEDURE INSERT_IMPORTED_CHANGE_HISTORY
5193: ( p_api_version IN NUMBER
5194: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
5195: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
5196: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
5197: , x_return_status OUT NOCOPY VARCHAR2
5198: , x_msg_count OUT NOCOPY NUMBER

Line 5195: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE

5191: *********************************************************************/
5192: PROCEDURE INSERT_IMPORTED_CHANGE_HISTORY
5193: ( p_api_version IN NUMBER
5194: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
5195: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
5196: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
5197: , x_return_status OUT NOCOPY VARCHAR2
5198: , x_msg_count OUT NOCOPY NUMBER
5199: , x_msg_data OUT NOCOPY VARCHAR2

Line 5196: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL

5192: PROCEDURE INSERT_IMPORTED_CHANGE_HISTORY
5193: ( p_api_version IN NUMBER
5194: , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
5195: , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
5196: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
5197: , x_return_status OUT NOCOPY VARCHAR2
5198: , x_msg_count OUT NOCOPY NUMBER
5199: , x_msg_data OUT NOCOPY VARCHAR2
5200: , p_write_msg_to_intftbl IN VARCHAR2 := NULL -- FND_API.G_FALSE

Line 5200: , p_write_msg_to_intftbl IN VARCHAR2 := NULL -- FND_API.G_FALSE

5196: , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
5197: , x_return_status OUT NOCOPY VARCHAR2
5198: , x_msg_count OUT NOCOPY NUMBER
5199: , x_msg_data OUT NOCOPY VARCHAR2
5200: , p_write_msg_to_intftbl IN VARCHAR2 := NULL -- FND_API.G_FALSE
5201: , p_api_caller IN VARCHAR2 := NULL
5202: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE
5203: , p_output_dir IN VARCHAR2 := NULL
5204: , p_debug_filename IN VARCHAR2 := NULL

Line 5202: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE

5198: , x_msg_count OUT NOCOPY NUMBER
5199: , x_msg_data OUT NOCOPY VARCHAR2
5200: , p_write_msg_to_intftbl IN VARCHAR2 := NULL -- FND_API.G_FALSE
5201: , p_api_caller IN VARCHAR2 := NULL
5202: , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE
5203: , p_output_dir IN VARCHAR2 := NULL
5204: , p_debug_filename IN VARCHAR2 := NULL
5205: , p_batch_id IN NUMBER
5206: , p_change_ids IN FND_ARRAY_OF_NUMBER_25

Line 5240: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

5236: -- Standard Start of API savepoint
5237: SAVEPOINT INSERT_IMPORTED_CHANGE_HISTORY;
5238:
5239: -- Standard call to check for call compatibility.
5240: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
5241: p_api_version ,
5242: l_api_name ,
5243: G_PKG_NAME )
5244: THEN

Line 5245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5241: p_api_version ,
5242: l_api_name ,
5243: G_PKG_NAME )
5244: THEN
5245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5246: END IF;
5247:
5248: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
5249: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;

Line 5248: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;

5244: THEN
5245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5246: END IF;
5247:
5248: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
5249: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
5250: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
5251: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
5252:

Line 5249: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;

5245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5246: END IF;
5247:
5248: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
5249: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
5250: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
5251: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
5252:
5253:

Line 5250: l_commit := NVL(p_commit,FND_API.G_FALSE) ;

5246: END IF;
5247:
5248: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
5249: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
5250: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
5251: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
5252:
5253:
5254: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 5251: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;

5247:
5248: l_init_msg_list := NVL(p_init_msg_list,FND_API.G_FALSE) ;
5249: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
5250: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
5251: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
5252:
5253:
5254: -- Initialize message list if p_init_msg_list is set to TRUE.
5255: IF FND_API.to_Boolean( l_init_msg_list ) THEN

Line 5255: IF FND_API.to_Boolean( l_init_msg_list ) THEN

5251: l_write_msg_to_intftbl := NVL(p_write_msg_to_intftbl,FND_API.G_FALSE) ;
5252:
5253:
5254: -- Initialize message list if p_init_msg_list is set to TRUE.
5255: IF FND_API.to_Boolean( l_init_msg_list ) THEN
5256: FND_MSG_PUB.initialize;
5257: END IF;
5258:
5259: -- Open Debug Session by a give param or profile option.

Line 5318: IF FND_API.to_Boolean(l_write_msg_to_intftbl)

5314: X_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id
5315: ) ;
5316:
5317:
5318: IF FND_API.to_Boolean(l_write_msg_to_intftbl)
5319: THEN
5320:
5321: Write_Debug('Insert Info Message for the record inserted as history. . .' );
5322: FND_MESSAGE.SET_NAME('ENG','ENG_IMPT_INS_HIST');

Line 5345: IF FND_API.To_Boolean( p_commit ) THEN

5341: -- End of API body.
5342:
5343:
5344: -- Standard check of p_commit.
5345: IF FND_API.To_Boolean( p_commit ) THEN
5346: COMMIT WORK;
5347: END IF;
5348:
5349: -- Standard call to get message count and if count is 1, get message info.

Line 5356: WHEN FND_API.G_EXC_ERROR THEN

5352: p_data => x_msg_data
5353: );
5354:
5355: EXCEPTION
5356: WHEN FND_API.G_EXC_ERROR THEN
5357: ROLLBACK TO INSERT_IMPORTED_CHANGE_HISTORY;
5358: x_return_status := G_RET_STS_ERROR ;
5359: FND_MSG_PUB.Count_And_Get
5360: ( p_count => x_msg_count ,

Line 5364: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5360: ( p_count => x_msg_count ,
5361: p_data => x_msg_data
5362: );
5363:
5364: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5365: ROLLBACK TO INSERT_IMPORTED_CHANGE_HISTORY;
5366: x_return_status := G_RET_STS_UNEXP_ERROR ;
5367: FND_MSG_PUB.Count_And_Get
5368: ( p_count => x_msg_count ,