APPS.QP_VALIDATE_CURR_LISTS dependencies on OE_DEBUG_PUB

Line 21: -- oe_debug_pub.add('VALIDATIONS: Inside Header L Package');

17: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
18: l_dummy_c VARCHAR2(1);
19: BEGIN
20:
21: -- oe_debug_pub.add('VALIDATIONS: Inside Header L Package');
22:
23: -- Check required attributes.
24:
25: IF p_CURR_LISTS_rec.currency_header_id IS NULL

Line 47: -- oe_debug_pub.add('VALIDATE Header records base_currency_code');

43: --
44: -- Below validations Added by Sunil Pandey
45: -- Validate Header records' base_currency_code
46: BEGIN
47: -- oe_debug_pub.add('VALIDATE Header records base_currency_code');
48:
49: SELECT 'X'
50: INTO l_dummy_c
51: FROM fnd_currencies_vl

Line 71: -- oe_debug_pub.add('VALIDATE Headers base_markup_operator');

67: IF (p_CURR_LISTS_rec.base_markup_operator IS NOT NULL and
68: p_CURR_LISTS_rec.base_markup_operator <> FND_API.G_MISS_CHAR)
69: THEN
70: BEGIN
71: -- oe_debug_pub.add('VALIDATE Headers base_markup_operator');
72:
73: SELECT 'X'
74: INTO l_dummy_c
75: FROM qp_lookups

Line 84: -- oe_debug_pub.add('ERROR: Base Markup_Operator is Invalid');

80: nvl(start_date_active, trunc(sysdate)) and nvl(end_date_active, trunc(sysdate));
81:
82: EXCEPTION
83: WHEN NO_DATA_FOUND THEN
84: -- oe_debug_pub.add('ERROR: Base Markup_Operator is Invalid');
85: l_return_status := FND_API.G_RET_STS_ERROR;
86: FND_MESSAGE.SET_NAME('QP','QP_INVALID_MARKUP_OPRTR'); -- CHANGE MESG_CODE
87: FND_MESSAGE.SET_TOKEN('MARKUP_OPERATOR',p_CURR_LISTS_rec.base_markup_operator);
88: OE_MSG_PUB.Add;

Line 98: -- oe_debug_pub.add('VALIDATE Headers base_markup_formula');

94: IF (p_CURR_LISTS_rec.base_markup_formula_id IS NOT NULL and
95: p_CURR_LISTS_rec.base_markup_formula_id <> FND_API.G_MISS_NUM)
96: THEN
97: BEGIN
98: -- oe_debug_pub.add('VALIDATE Headers base_markup_formula');
99:
100: /*
101: SELECT 'X'
102: INTO l_dummy_c

Line 141: -- oe_debug_pub.add('ERROR: Markup Formula or Value should be provided if Markup Operator is present');

137: (p_CURR_LISTS_rec.base_markup_formula_id IS NULL AND
138: p_CURR_LISTS_rec.base_markup_value IS NULL)
139: )
140: THEN
141: -- oe_debug_pub.add('ERROR: Markup Formula or Value should be provided if Markup Operator is present');
142: l_return_status := FND_API.G_RET_STS_ERROR;
143: FND_MESSAGE.SET_NAME('QP','QP_FRML_OR_VAL_REQD'); -- CHANGE MESG_CODE
144: OE_MSG_PUB.Add;
145: END IF;

Line 153: -- oe_debug_pub.add('ERROR: Markup Formula or Value can be provided only if Markup Operator is present');

149: (p_CURR_LISTS_rec.base_markup_formula_id IS NOT NULL OR
150: p_CURR_LISTS_rec.base_markup_value IS NOT NULL)
151: )
152: THEN
153: -- oe_debug_pub.add('ERROR: Markup Formula or Value can be provided only if Markup Operator is present');
154: l_return_status := FND_API.G_RET_STS_ERROR;
155: FND_MESSAGE.SET_NAME('QP','QP_MARKUP_OPRTR_REQD'); -- CHANGE MESG_CODE
156: OE_MSG_PUB.Add;
157: END IF;

Line 164: oe_debug_pub.add('QPXLCURB.ENTITY base rounding_factor error occured');

160: IF p_CURR_LISTS_rec.base_rounding_factor IS NOT NULL AND
161: p_CURR_LISTS_rec.base_currency_code IS NOT NULL THEN
162: IF NOT QP_Validate.Rounding_Factor(p_CURR_LISTS_rec.base_rounding_factor,
163: p_CURR_LISTS_rec.base_currency_code) THEN
164: oe_debug_pub.add('QPXLCURB.ENTITY base rounding_factor error occured');
165: l_return_status := FND_API.G_RET_STS_ERROR;
166: END IF;
167: END IF;
168: -- Bug 2293974 - rounding factor is mandatory

Line 384: -- oe_debug_pub.add('ERROR: in Attributes procedure of L package for base_markup_operator');

380: ( p_CURR_LISTS_rec.base_markup_operator <>
381: p_old_CURR_LISTS_rec.base_markup_operator OR
382: p_old_CURR_LISTS_rec.base_markup_operator IS NULL )
383: THEN
384: -- oe_debug_pub.add('ERROR: in Attributes procedure of L package for base_markup_operator');
385: IF NOT QP_Validate.base_markup_operator(p_CURR_LISTS_rec.base_markup_operator) THEN
386: x_return_status := FND_API.G_RET_STS_ERROR;
387: END IF;
388: END IF;