APPS.QP_VALIDATE_FORMULA dependencies on OE_DEBUG_PUB

Line 27: oe_debug_pub.add('Entering proc Entity in Formula Validation Pkg');

23: L_MAINT_DYN_SRC_VER VARCHAR2(1) := NVL(Fnd_Profile.value('QP_MAINTAIN_DYNAMIC_SOURCE_VERSIONS'),'N'); -- 13638721
24: l_pkg_ver VARCHAR2(10);
25: BEGIN
26:
27: oe_debug_pub.add('Entering proc Entity in Formula Validation Pkg');
28: -- Check required attributes.
29:
30: IF p_FORMULA_rec.price_formula_id IS NULL
31: THEN

Line 100: oe_debug_pub.add('Maintain Dynamic pkgs profile is 1:'||L_MAINT_DYN_SRC_VER);

96:
97: --sfiresto (Check dynamic formula package for formulas, not database)
98:
99: -- 13638721
100: oe_debug_pub.add('Maintain Dynamic pkgs profile is 1:'||L_MAINT_DYN_SRC_VER);
101: IF (L_MAINT_DYN_SRC_VER='N') THEN
102: QP_BUILD_FORMULA_RULES.Get_Formula_Values(p_FORMULA_rec.formula,
103: l_dummy_operand_tbl,
104: 'S', --sfiresto

Line 110: oe_debug_pub.add('2. found row in qp_params for code BLD_FORMULA_ACTV_VER pkg ver : ' || l_pkg_ver);

106: l_check_formula);
107: ELSE
108: BEGIN
109: SELECT SEEDED_VALUE INTO l_pkg_ver FROM qp_parameters_b WHERE PARAMETER_CODE='BLD_FORMULA_ACTV_VER' AND ROWNUM=1;
110: oe_debug_pub.add('2. found row in qp_params for code BLD_FORMULA_ACTV_VER pkg ver : ' || l_pkg_ver);
111: EXCEPTION
112: WHEN OTHERS THEN
113: l_pkg_ver:='0';
114: oe_debug_pub.add('2. when others row in qp_params for code BLD_FORMULA_ACTV_VER pkg ver: ' || l_pkg_ver);

Line 114: oe_debug_pub.add('2. when others row in qp_params for code BLD_FORMULA_ACTV_VER pkg ver: ' || l_pkg_ver);

110: oe_debug_pub.add('2. found row in qp_params for code BLD_FORMULA_ACTV_VER pkg ver : ' || l_pkg_ver);
111: EXCEPTION
112: WHEN OTHERS THEN
113: l_pkg_ver:='0';
114: oe_debug_pub.add('2. when others row in qp_params for code BLD_FORMULA_ACTV_VER pkg ver: ' || l_pkg_ver);
115: END;
116: IF (l_pkg_ver='5') THEN
117: QP_BUILD_FORMULA_RULES5.Get_Formula_Values(p_FORMULA_rec.formula,
118: l_dummy_operand_tbl,

Line 257: oe_debug_pub.add('Leaving proc Entity in Formula Validation Pkg');

253: -- Done validating entity
254:
255: x_return_status := l_return_status;
256:
257: oe_debug_pub.add('Leaving proc Entity in Formula Validation Pkg');
258: EXCEPTION
259:
260: WHEN FND_API.G_EXC_ERROR THEN
261:

Line 293: oe_debug_pub.add('Entering proc Attributes in Formula Validation Pkg');

289: )
290: IS
291: BEGIN
292:
293: oe_debug_pub.add('Entering proc Attributes in Formula Validation Pkg');
294: x_return_status := FND_API.G_RET_STS_SUCCESS;
295:
296: -- Validate FORMULA attributes
297:

Line 553: oe_debug_pub.add('Leaving proc Attributes in Formula Validation Pkg');

549: END IF;
550:
551: -- Done validating attributes
552:
553: oe_debug_pub.add('Leaving proc Attributes in Formula Validation Pkg');
554: EXCEPTION
555:
556: WHEN FND_API.G_EXC_ERROR THEN
557:

Line 588: oe_debug_pub.add('Entering proc Entity_Delete in Formula Validation Pkg');

584: IS
585: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
586: BEGIN
587:
588: oe_debug_pub.add('Entering proc Entity_Delete in Formula Validation Pkg');
589: -- Validate entity delete.
590:
591: NULL;
592:

Line 597: oe_debug_pub.add('Leaving proc Entity_Delete in Formula Validation Pkg');

593: -- Done.
594:
595: x_return_status := l_return_status;
596:
597: oe_debug_pub.add('Leaving proc Entity_Delete in Formula Validation Pkg');
598: EXCEPTION
599:
600: WHEN FND_API.G_EXC_ERROR THEN
601: