2296: Pkg_End('QP_BUILD_SOURCING_PVT_TMP', 'BODY');
2297:
2298: --dbms_output.put_line('............5............');
2299: retcode := 0;
2300: Fnd_Message.SET_NAME('QP','QP_ATTRIBUTE_SOURCING_SUCCESS');
2301: err_buff := Fnd_Message.GET;
2302:
2303: IF l_debug = Fnd_Api.G_TRUE THEN
2304: Oe_Debug_Pub.ADD('##### End Build Sourcing #####');
2297:
2298: --dbms_output.put_line('............5............');
2299: retcode := 0;
2300: Fnd_Message.SET_NAME('QP','QP_ATTRIBUTE_SOURCING_SUCCESS');
2301: err_buff := Fnd_Message.GET;
2302:
2303: IF l_debug = Fnd_Api.G_TRUE THEN
2304: Oe_Debug_Pub.ADD('##### End Build Sourcing #####');
2305:
2306: END IF;
2307: EXCEPTION
2308:
2309: WHEN Fnd_Api.G_EXC_ERROR THEN
2310: Fnd_Message.SET_NAME('QP','QP_ATTRIBUTE_SOURCING_ERROR');
2311: Fnd_Message.SET_TOKEN('PACKAGE_TYPE','BODY');
2312: Fnd_Message.SET_TOKEN('PACKAGE_NAME','QP_BUILD_SOURCING_PVT');
2313: Fnd_Message.SET_TOKEN('ERRMSG',SUBSTR(SQLERRM,1,150));
2314: err_buff := Fnd_Message.GET;
2307: EXCEPTION
2308:
2309: WHEN Fnd_Api.G_EXC_ERROR THEN
2310: Fnd_Message.SET_NAME('QP','QP_ATTRIBUTE_SOURCING_ERROR');
2311: Fnd_Message.SET_TOKEN('PACKAGE_TYPE','BODY');
2312: Fnd_Message.SET_TOKEN('PACKAGE_NAME','QP_BUILD_SOURCING_PVT');
2313: Fnd_Message.SET_TOKEN('ERRMSG',SUBSTR(SQLERRM,1,150));
2314: err_buff := Fnd_Message.GET;
2315: retcode := 2;
2308:
2309: WHEN Fnd_Api.G_EXC_ERROR THEN
2310: Fnd_Message.SET_NAME('QP','QP_ATTRIBUTE_SOURCING_ERROR');
2311: Fnd_Message.SET_TOKEN('PACKAGE_TYPE','BODY');
2312: Fnd_Message.SET_TOKEN('PACKAGE_NAME','QP_BUILD_SOURCING_PVT');
2313: Fnd_Message.SET_TOKEN('ERRMSG',SUBSTR(SQLERRM,1,150));
2314: err_buff := Fnd_Message.GET;
2315: retcode := 2;
2316:
2309: WHEN Fnd_Api.G_EXC_ERROR THEN
2310: Fnd_Message.SET_NAME('QP','QP_ATTRIBUTE_SOURCING_ERROR');
2311: Fnd_Message.SET_TOKEN('PACKAGE_TYPE','BODY');
2312: Fnd_Message.SET_TOKEN('PACKAGE_NAME','QP_BUILD_SOURCING_PVT');
2313: Fnd_Message.SET_TOKEN('ERRMSG',SUBSTR(SQLERRM,1,150));
2314: err_buff := Fnd_Message.GET;
2315: retcode := 2;
2316:
2317: -- err_buff := 'Please check the log file for error messages';
2310: Fnd_Message.SET_NAME('QP','QP_ATTRIBUTE_SOURCING_ERROR');
2311: Fnd_Message.SET_TOKEN('PACKAGE_TYPE','BODY');
2312: Fnd_Message.SET_TOKEN('PACKAGE_NAME','QP_BUILD_SOURCING_PVT');
2313: Fnd_Message.SET_TOKEN('ERRMSG',SUBSTR(SQLERRM,1,150));
2314: err_buff := Fnd_Message.GET;
2315: retcode := 2;
2316:
2317: -- err_buff := 'Please check the log file for error messages';
2318:
2316:
2317: -- err_buff := 'Please check the log file for error messages';
2318:
2319: WHEN OTHERS THEN
2320: Fnd_Message.SET_NAME('QP','QP_ATTRIBUTE_SOURCING_ERROR');
2321: Fnd_Message.SET_TOKEN('PACKAGE_TYPE','BODY');
2322: Fnd_Message.SET_TOKEN('PACKAGE_NAME','QP_BUILD_SOURCING_PVT');
2323: Fnd_Message.SET_TOKEN('ERRMSG',SUBSTR(SQLERRM,1,150));
2324: err_buff := Fnd_Message.GET;
2317: -- err_buff := 'Please check the log file for error messages';
2318:
2319: WHEN OTHERS THEN
2320: Fnd_Message.SET_NAME('QP','QP_ATTRIBUTE_SOURCING_ERROR');
2321: Fnd_Message.SET_TOKEN('PACKAGE_TYPE','BODY');
2322: Fnd_Message.SET_TOKEN('PACKAGE_NAME','QP_BUILD_SOURCING_PVT');
2323: Fnd_Message.SET_TOKEN('ERRMSG',SUBSTR(SQLERRM,1,150));
2324: err_buff := Fnd_Message.GET;
2325: PUT_LINE( 'Error in creating QP_BUILD_SOURCING_PVT '||SQLERRM);
2318:
2319: WHEN OTHERS THEN
2320: Fnd_Message.SET_NAME('QP','QP_ATTRIBUTE_SOURCING_ERROR');
2321: Fnd_Message.SET_TOKEN('PACKAGE_TYPE','BODY');
2322: Fnd_Message.SET_TOKEN('PACKAGE_NAME','QP_BUILD_SOURCING_PVT');
2323: Fnd_Message.SET_TOKEN('ERRMSG',SUBSTR(SQLERRM,1,150));
2324: err_buff := Fnd_Message.GET;
2325: PUT_LINE( 'Error in creating QP_BUILD_SOURCING_PVT '||SQLERRM);
2326: retcode := 2;
2319: WHEN OTHERS THEN
2320: Fnd_Message.SET_NAME('QP','QP_ATTRIBUTE_SOURCING_ERROR');
2321: Fnd_Message.SET_TOKEN('PACKAGE_TYPE','BODY');
2322: Fnd_Message.SET_TOKEN('PACKAGE_NAME','QP_BUILD_SOURCING_PVT');
2323: Fnd_Message.SET_TOKEN('ERRMSG',SUBSTR(SQLERRM,1,150));
2324: err_buff := Fnd_Message.GET;
2325: PUT_LINE( 'Error in creating QP_BUILD_SOURCING_PVT '||SQLERRM);
2326: retcode := 2;
2327: -- err_buff := sqlerrm;
2320: Fnd_Message.SET_NAME('QP','QP_ATTRIBUTE_SOURCING_ERROR');
2321: Fnd_Message.SET_TOKEN('PACKAGE_TYPE','BODY');
2322: Fnd_Message.SET_TOKEN('PACKAGE_NAME','QP_BUILD_SOURCING_PVT');
2323: Fnd_Message.SET_TOKEN('ERRMSG',SUBSTR(SQLERRM,1,150));
2324: err_buff := Fnd_Message.GET;
2325: PUT_LINE( 'Error in creating QP_BUILD_SOURCING_PVT '||SQLERRM);
2326: retcode := 2;
2327: -- err_buff := sqlerrm;
2328: