728: New_Line;
729:
730: Pkg_End('QP_BUILD_FORMULA_RULES_TMP', 'BODY');
731:
732: FND_MESSAGE.SET_NAME('QP','QP_BUILD_FORMULAS_SUCCESS');
733: err_buff := FND_MESSAGE.GET;
734: PUT_LINE(err_buff);
735: retcode := 0;
736: oe_debug_pub.add('##### ' || err_buff || ' #####');
729:
730: Pkg_End('QP_BUILD_FORMULA_RULES_TMP', 'BODY');
731:
732: FND_MESSAGE.SET_NAME('QP','QP_BUILD_FORMULAS_SUCCESS');
733: err_buff := FND_MESSAGE.GET;
734: PUT_LINE(err_buff);
735: retcode := 0;
736: oe_debug_pub.add('##### ' || err_buff || ' #####');
737: oe_debug_pub.add('##### End Build Formulas #####');
738:
739: EXCEPTION
740:
741: WHEN FND_API.G_EXC_ERROR THEN
742: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_SOURCING_ERROR');
743: FND_MESSAGE.SET_TOKEN('PACKAGE_TYPE','BODY');
744: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','QP_BUILD_FORMULA_RULES');
745: FND_MESSAGE.SET_TOKEN('ERRMSG',substr(SQLERRM,1,150));
746: err_buff := FND_MESSAGE.GET;
739: EXCEPTION
740:
741: WHEN FND_API.G_EXC_ERROR THEN
742: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_SOURCING_ERROR');
743: FND_MESSAGE.SET_TOKEN('PACKAGE_TYPE','BODY');
744: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','QP_BUILD_FORMULA_RULES');
745: FND_MESSAGE.SET_TOKEN('ERRMSG',substr(SQLERRM,1,150));
746: err_buff := FND_MESSAGE.GET;
747: PUT_LINE(err_buff);
740:
741: WHEN FND_API.G_EXC_ERROR THEN
742: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_SOURCING_ERROR');
743: FND_MESSAGE.SET_TOKEN('PACKAGE_TYPE','BODY');
744: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','QP_BUILD_FORMULA_RULES');
745: FND_MESSAGE.SET_TOKEN('ERRMSG',substr(SQLERRM,1,150));
746: err_buff := FND_MESSAGE.GET;
747: PUT_LINE(err_buff);
748: retcode := 2;
741: WHEN FND_API.G_EXC_ERROR THEN
742: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_SOURCING_ERROR');
743: FND_MESSAGE.SET_TOKEN('PACKAGE_TYPE','BODY');
744: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','QP_BUILD_FORMULA_RULES');
745: FND_MESSAGE.SET_TOKEN('ERRMSG',substr(SQLERRM,1,150));
746: err_buff := FND_MESSAGE.GET;
747: PUT_LINE(err_buff);
748: retcode := 2;
749: oe_debug_pub.add('##### ' || err_buff || ' #####');
742: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_SOURCING_ERROR');
743: FND_MESSAGE.SET_TOKEN('PACKAGE_TYPE','BODY');
744: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','QP_BUILD_FORMULA_RULES');
745: FND_MESSAGE.SET_TOKEN('ERRMSG',substr(SQLERRM,1,150));
746: err_buff := FND_MESSAGE.GET;
747: PUT_LINE(err_buff);
748: retcode := 2;
749: oe_debug_pub.add('##### ' || err_buff || ' #####');
750: oe_debug_pub.add('##### End Build Formulas #####');
749: oe_debug_pub.add('##### ' || err_buff || ' #####');
750: oe_debug_pub.add('##### End Build Formulas #####');
751:
752: WHEN OTHERS THEN
753: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_SOURCING_ERROR');
754: FND_MESSAGE.SET_TOKEN('PACKAGE_TYPE','BODY');
755: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','QP_BUILD_FORMULA_RULES');
756: FND_MESSAGE.SET_TOKEN('ERRMSG',substr(SQLERRM,1,150));
757: err_buff := FND_MESSAGE.GET;
750: oe_debug_pub.add('##### End Build Formulas #####');
751:
752: WHEN OTHERS THEN
753: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_SOURCING_ERROR');
754: FND_MESSAGE.SET_TOKEN('PACKAGE_TYPE','BODY');
755: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','QP_BUILD_FORMULA_RULES');
756: FND_MESSAGE.SET_TOKEN('ERRMSG',substr(SQLERRM,1,150));
757: err_buff := FND_MESSAGE.GET;
758: PUT_LINE(err_buff);
751:
752: WHEN OTHERS THEN
753: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_SOURCING_ERROR');
754: FND_MESSAGE.SET_TOKEN('PACKAGE_TYPE','BODY');
755: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','QP_BUILD_FORMULA_RULES');
756: FND_MESSAGE.SET_TOKEN('ERRMSG',substr(SQLERRM,1,150));
757: err_buff := FND_MESSAGE.GET;
758: PUT_LINE(err_buff);
759: retcode := 2;
752: WHEN OTHERS THEN
753: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_SOURCING_ERROR');
754: FND_MESSAGE.SET_TOKEN('PACKAGE_TYPE','BODY');
755: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','QP_BUILD_FORMULA_RULES');
756: FND_MESSAGE.SET_TOKEN('ERRMSG',substr(SQLERRM,1,150));
757: err_buff := FND_MESSAGE.GET;
758: PUT_LINE(err_buff);
759: retcode := 2;
760: oe_debug_pub.add('##### ' || err_buff || ' #####');
753: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_SOURCING_ERROR');
754: FND_MESSAGE.SET_TOKEN('PACKAGE_TYPE','BODY');
755: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','QP_BUILD_FORMULA_RULES');
756: FND_MESSAGE.SET_TOKEN('ERRMSG',substr(SQLERRM,1,150));
757: err_buff := FND_MESSAGE.GET;
758: PUT_LINE(err_buff);
759: retcode := 2;
760: oe_debug_pub.add('##### ' || err_buff || ' #####');
761: oe_debug_pub.add('##### End Build Formulas #####');