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.

APPS.QP_VALIDATE_CURR_DETAILS dependencies on OE_DEBUG_PUB

Line 80: -- oe_debug_pub.add('Inside Details Entity L package');

76: nvl(precedence, -1) = in_precedence;
77:
78: BEGIN
79:
80: -- oe_debug_pub.add('Inside Details Entity L package');
81: -- Check required attributes.
82:
83: IF p_CURR_DETAILS_rec.currency_detail_id IS NULL
84: THEN

Line 87: -- oe_debug_pub.add('ERROR: currency_detail_id is NULL');

83: IF p_CURR_DETAILS_rec.currency_detail_id IS NULL
84: THEN
85:
86: l_return_status := FND_API.G_RET_STS_ERROR;
87: -- oe_debug_pub.add('ERROR: currency_detail_id is NULL');
88:
89: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
90: THEN
91:

Line 107: -- oe_debug_pub.add('VALIDATING start date after end date');

103: -- Below validations Added by Sunil Pandey
104:
105: -- End Date must be after the Start Date
106:
107: -- oe_debug_pub.add('VALIDATING start date after end date');
108: IF nvl( p_CURR_DETAILS_rec.start_date_active,l_default_start_date_d) >
109: nvl( p_CURR_DETAILS_rec.end_date_active,l_default_end_date_d)
110: THEN
111:

Line 116: -- oe_debug_pub.add(' Start_date End_Date Check; G_MSG_CONTEXT_COUNT: '||OE_MSG_PUB.G_MSG_CONTEXT_COUNT);

112: l_return_status := FND_API.G_RET_STS_ERROR;
113:
114: FND_MESSAGE.SET_NAME('QP','QP_STRT_DATE_BFR_END_DATE');
115: OE_MSG_PUB.Add;
116: -- oe_debug_pub.add(' Start_date End_Date Check; G_MSG_CONTEXT_COUNT: '||OE_MSG_PUB.G_MSG_CONTEXT_COUNT);
117: -- oe_debug_pub.add(' Start_date End_Date Check; G_MSG_COUNT: '||OE_MSG_PUB.G_MSG_COUNT);
118: -- oe_debug_pub.add('ERROR: start_date is after end_date');
119: -- oe_debug_pub.add('. start_date: '||NVL(p_CURR_DETAILS_rec.start_date_active, sysdate));
120: -- oe_debug_pub.add('. end_date: '||NVL(p_CURR_DETAILS_rec.end_date_active, sysdate));

Line 117: -- oe_debug_pub.add(' Start_date End_Date Check; G_MSG_COUNT: '||OE_MSG_PUB.G_MSG_COUNT);

113:
114: FND_MESSAGE.SET_NAME('QP','QP_STRT_DATE_BFR_END_DATE');
115: OE_MSG_PUB.Add;
116: -- oe_debug_pub.add(' Start_date End_Date Check; G_MSG_CONTEXT_COUNT: '||OE_MSG_PUB.G_MSG_CONTEXT_COUNT);
117: -- oe_debug_pub.add(' Start_date End_Date Check; G_MSG_COUNT: '||OE_MSG_PUB.G_MSG_COUNT);
118: -- oe_debug_pub.add('ERROR: start_date is after end_date');
119: -- oe_debug_pub.add('. start_date: '||NVL(p_CURR_DETAILS_rec.start_date_active, sysdate));
120: -- oe_debug_pub.add('. end_date: '||NVL(p_CURR_DETAILS_rec.end_date_active, sysdate));
121: -- raise FND_API.G_EXC_ERROR;

Line 118: -- oe_debug_pub.add('ERROR: start_date is after end_date');

114: FND_MESSAGE.SET_NAME('QP','QP_STRT_DATE_BFR_END_DATE');
115: OE_MSG_PUB.Add;
116: -- oe_debug_pub.add(' Start_date End_Date Check; G_MSG_CONTEXT_COUNT: '||OE_MSG_PUB.G_MSG_CONTEXT_COUNT);
117: -- oe_debug_pub.add(' Start_date End_Date Check; G_MSG_COUNT: '||OE_MSG_PUB.G_MSG_COUNT);
118: -- oe_debug_pub.add('ERROR: start_date is after end_date');
119: -- oe_debug_pub.add('. start_date: '||NVL(p_CURR_DETAILS_rec.start_date_active, sysdate));
120: -- oe_debug_pub.add('. end_date: '||NVL(p_CURR_DETAILS_rec.end_date_active, sysdate));
121: -- raise FND_API.G_EXC_ERROR;
122:

Line 119: -- oe_debug_pub.add('. start_date: '||NVL(p_CURR_DETAILS_rec.start_date_active, sysdate));

115: OE_MSG_PUB.Add;
116: -- oe_debug_pub.add(' Start_date End_Date Check; G_MSG_CONTEXT_COUNT: '||OE_MSG_PUB.G_MSG_CONTEXT_COUNT);
117: -- oe_debug_pub.add(' Start_date End_Date Check; G_MSG_COUNT: '||OE_MSG_PUB.G_MSG_COUNT);
118: -- oe_debug_pub.add('ERROR: start_date is after end_date');
119: -- oe_debug_pub.add('. start_date: '||NVL(p_CURR_DETAILS_rec.start_date_active, sysdate));
120: -- oe_debug_pub.add('. end_date: '||NVL(p_CURR_DETAILS_rec.end_date_active, sysdate));
121: -- raise FND_API.G_EXC_ERROR;
122:
123: ELSE

Line 120: -- oe_debug_pub.add('. end_date: '||NVL(p_CURR_DETAILS_rec.end_date_active, sysdate));

116: -- oe_debug_pub.add(' Start_date End_Date Check; G_MSG_CONTEXT_COUNT: '||OE_MSG_PUB.G_MSG_CONTEXT_COUNT);
117: -- oe_debug_pub.add(' Start_date End_Date Check; G_MSG_COUNT: '||OE_MSG_PUB.G_MSG_COUNT);
118: -- oe_debug_pub.add('ERROR: start_date is after end_date');
119: -- oe_debug_pub.add('. start_date: '||NVL(p_CURR_DETAILS_rec.start_date_active, sysdate));
120: -- oe_debug_pub.add('. end_date: '||NVL(p_CURR_DETAILS_rec.end_date_active, sysdate));
121: -- raise FND_API.G_EXC_ERROR;
122:
123: ELSE
124: -- Validate that only one active detail record exist at any point of time

Line 126: -- oe_debug_pub.add('VALIDATE Uniqueness of to_currency_code');

122:
123: ELSE
124: -- Validate that only one active detail record exist at any point of time
125: BEGIN
126: -- oe_debug_pub.add('VALIDATE Uniqueness of to_currency_code');
127: For detail_rec in CURSOR_OVERLAP_CHECK
128: (p_CURR_DETAILS_rec.to_currency_code,
129: p_CURR_DETAILS_rec.currency_header_id,
130: p_CURR_DETAILS_rec.currency_detail_id,

Line 156: -- oe_debug_pub.add('ERROR: Multiple record(s) are active for the to_currency_code: '||p_CURR_DETAILS_rec.to_currency_code);

152: l_return_status := FND_API.G_RET_STS_ERROR;
153: FND_MESSAGE.SET_NAME('QP','QP_OVERLAP_NOT_ALLWD'); -- CHANGE MESG_CODE
154: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',p_CURR_DETAILS_rec.to_currency_code);
155: OE_MSG_PUB.Add;
156: -- oe_debug_pub.add('ERROR: Multiple record(s) are active for the to_currency_code: '||p_CURR_DETAILS_rec.to_currency_code);
157: -- oe_debug_pub.add('. Form record start_date: '||NVL(p_CURR_DETAILS_rec.start_date_active, l_default_start_date_d));
158: -- oe_debug_pub.add('. Form record end_date: '||NVL(p_CURR_DETAILS_rec.end_date_active, l_default_end_date_d));
159: -- oe_debug_pub.add('. Existing record start_date: '||NVL(detail_rec.start_date_active, l_default_start_date_d));
160: -- oe_debug_pub.add('. Existing record end_date: '||NVL(detail_rec.end_date_active, l_default_end_date_d));

Line 157: -- oe_debug_pub.add('. Form record start_date: '||NVL(p_CURR_DETAILS_rec.start_date_active, l_default_start_date_d));

153: FND_MESSAGE.SET_NAME('QP','QP_OVERLAP_NOT_ALLWD'); -- CHANGE MESG_CODE
154: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',p_CURR_DETAILS_rec.to_currency_code);
155: OE_MSG_PUB.Add;
156: -- oe_debug_pub.add('ERROR: Multiple record(s) are active for the to_currency_code: '||p_CURR_DETAILS_rec.to_currency_code);
157: -- oe_debug_pub.add('. Form record start_date: '||NVL(p_CURR_DETAILS_rec.start_date_active, l_default_start_date_d));
158: -- oe_debug_pub.add('. Form record end_date: '||NVL(p_CURR_DETAILS_rec.end_date_active, l_default_end_date_d));
159: -- oe_debug_pub.add('. Existing record start_date: '||NVL(detail_rec.start_date_active, l_default_start_date_d));
160: -- oe_debug_pub.add('. Existing record end_date: '||NVL(detail_rec.end_date_active, l_default_end_date_d));
161: exit; -- Exit the loop

Line 158: -- oe_debug_pub.add('. Form record end_date: '||NVL(p_CURR_DETAILS_rec.end_date_active, l_default_end_date_d));

154: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',p_CURR_DETAILS_rec.to_currency_code);
155: OE_MSG_PUB.Add;
156: -- oe_debug_pub.add('ERROR: Multiple record(s) are active for the to_currency_code: '||p_CURR_DETAILS_rec.to_currency_code);
157: -- oe_debug_pub.add('. Form record start_date: '||NVL(p_CURR_DETAILS_rec.start_date_active, l_default_start_date_d));
158: -- oe_debug_pub.add('. Form record end_date: '||NVL(p_CURR_DETAILS_rec.end_date_active, l_default_end_date_d));
159: -- oe_debug_pub.add('. Existing record start_date: '||NVL(detail_rec.start_date_active, l_default_start_date_d));
160: -- oe_debug_pub.add('. Existing record end_date: '||NVL(detail_rec.end_date_active, l_default_end_date_d));
161: exit; -- Exit the loop
162:

Line 159: -- oe_debug_pub.add('. Existing record start_date: '||NVL(detail_rec.start_date_active, l_default_start_date_d));

155: OE_MSG_PUB.Add;
156: -- oe_debug_pub.add('ERROR: Multiple record(s) are active for the to_currency_code: '||p_CURR_DETAILS_rec.to_currency_code);
157: -- oe_debug_pub.add('. Form record start_date: '||NVL(p_CURR_DETAILS_rec.start_date_active, l_default_start_date_d));
158: -- oe_debug_pub.add('. Form record end_date: '||NVL(p_CURR_DETAILS_rec.end_date_active, l_default_end_date_d));
159: -- oe_debug_pub.add('. Existing record start_date: '||NVL(detail_rec.start_date_active, l_default_start_date_d));
160: -- oe_debug_pub.add('. Existing record end_date: '||NVL(detail_rec.end_date_active, l_default_end_date_d));
161: exit; -- Exit the loop
162:
163: End if;

Line 160: -- oe_debug_pub.add('. Existing record end_date: '||NVL(detail_rec.end_date_active, l_default_end_date_d));

156: -- oe_debug_pub.add('ERROR: Multiple record(s) are active for the to_currency_code: '||p_CURR_DETAILS_rec.to_currency_code);
157: -- oe_debug_pub.add('. Form record start_date: '||NVL(p_CURR_DETAILS_rec.start_date_active, l_default_start_date_d));
158: -- oe_debug_pub.add('. Form record end_date: '||NVL(p_CURR_DETAILS_rec.end_date_active, l_default_end_date_d));
159: -- oe_debug_pub.add('. Existing record start_date: '||NVL(detail_rec.start_date_active, l_default_start_date_d));
160: -- oe_debug_pub.add('. Existing record end_date: '||NVL(detail_rec.end_date_active, l_default_end_date_d));
161: exit; -- Exit the loop
162:
163: End if;
164: END LOOP;

Line 171: -- oe_debug_pub.add('VALIDATE Details to_currency_code');

167: END IF;
168:
169: -- Validate detail records' to_currency_code
170: BEGIN
171: -- oe_debug_pub.add('VALIDATE Details to_currency_code');
172:
173: SELECT 'X'
174: INTO l_dummy_c
175: FROM fnd_currencies_vl

Line 187: -- oe_debug_pub.add('ERROR: Invalid To_Currency_Code');

183: WHEN NO_DATA_FOUND THEN
184: l_return_status := FND_API.G_RET_STS_ERROR;
185: FND_MESSAGE.SET_NAME('QP','QP_INVALID_CURRENCY');
186: OE_MSG_PUB.Add;
187: -- oe_debug_pub.add('ERROR: Invalid To_Currency_Code');
188:
189: END;
190:
191: -- Validate detail records' price_formula

Line 196: oe_debug_pub.add('VALIDATE Details price_formula');

192: IF (p_CURR_DETAILS_rec.price_formula_id IS NOT NULL and
193: p_CURR_DETAILS_rec.price_formula_id <> FND_API.G_MISS_NUM)
194: THEN
195: BEGIN
196: oe_debug_pub.add('VALIDATE Details price_formula');
197:
198: SELECT 'X'
199: INTO l_dummy_c
200: FROM qp_price_formulas_vl fh

Line 216: oe_debug_pub.add('ERROR: Invalid price_formula_id');

212: WHEN NO_DATA_FOUND THEN
213: l_return_status := FND_API.G_RET_STS_ERROR;
214: FND_MESSAGE.SET_NAME('QP','QP_FORMULA_NOT_FOUND');
215: OE_MSG_PUB.Add;
216: oe_debug_pub.add('ERROR: Invalid price_formula_id');
217:
218: END;
219:
220: BEGIN

Line 221: oe_debug_pub.add('VALIDATE - Details price_formula does not have line of type MV');

217:
218: END;
219:
220: BEGIN
221: oe_debug_pub.add('VALIDATE - Details price_formula does not have line of type MV');
222:
223: SELECT 'X'
224: INTO l_dummy_c
225: FROM qp_price_formulas_vl fh

Line 241: oe_debug_pub.add('ERROR: price_formula_id has MV as line type');

237: WHEN NO_DATA_FOUND THEN
238: l_return_status := FND_API.G_RET_STS_ERROR;
239: FND_MESSAGE.SET_NAME('QP','QP_INVALID_FORMULA_FOR_PL');
240: OE_MSG_PUB.Add;
241: oe_debug_pub.add('ERROR: price_formula_id has MV as line type');
242:
243: END;
244: END IF;
245:

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

251: (p_CURR_DETAILS_rec.markup_formula_id IS NULL AND
252: p_CURR_DETAILS_rec.markup_value IS NULL)
253: )
254: THEN
255: -- oe_debug_pub.add('ERROR: Markup Formula or Value should be provided if Markup Operator is present');
256: l_return_status := FND_API.G_RET_STS_ERROR;
257: FND_MESSAGE.SET_NAME('QP','Enter_Markup_FML_OR_Value'); -- CHANGE MESG_CODE
258: OE_MSG_PUB.Add;
259: END IF;

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

263: (p_CURR_DETAILS_rec.markup_formula_id IS NOT NULL OR
264: p_CURR_DETAILS_rec.markup_value IS NOT NULL)
265: )
266: THEN
267: -- oe_debug_pub.add('ERROR: Markup Formula or Value can be provided only if Markup Operator is present');
268: l_return_status := FND_API.G_RET_STS_ERROR;
269: FND_MESSAGE.SET_NAME('QP','First_Enter_Markup_OPRTR'); -- CHANGE MESG_CODE
270: OE_MSG_PUB.Add;
271: END IF;

Line 277: -- oe_debug_pub.add('VALIDATE Details markup_formula');

273:
274: -- Validate detail records' markup_formula
275: IF p_CURR_DETAILS_rec.markup_formula_id IS NOT NULL THEN
276: BEGIN
277: -- oe_debug_pub.add('VALIDATE Details markup_formula');
278:
279: /*
280: SELECT 'X'
281: INTO l_dummy_c

Line 308: -- oe_debug_pub.add('ERROR: Invalid markup_formula_id');

304: WHEN NO_DATA_FOUND THEN
305: l_return_status := FND_API.G_RET_STS_ERROR;
306: FND_MESSAGE.SET_NAME('QP','QP_FORMULA_NOT_FOUND');
307: OE_MSG_PUB.Add;
308: -- oe_debug_pub.add('ERROR: Invalid markup_formula_id');
309:
310: END;
311: END IF;
312:

Line 317: -- oe_debug_pub.add('VALIDATE Details conversion_method');

313: /*
314: -- Validate detail records' conversion_method
315: IF p_CURR_DETAILS_rec.conversion_method IS NOT NULL THEN
316: BEGIN
317: -- oe_debug_pub.add('VALIDATE Details conversion_method');
318:
319: SELECT 'X'
320: INTO l_dummy_c
321: FROM qp_lookups

Line 338: -- oe_debug_pub.add('VALIDATE Details conversion_type');

334:
335: -- Validate detail records' conversion_type
336: IF p_CURR_DETAILS_rec.conversion_type IS NOT NULL THEN
337: BEGIN
338: -- oe_debug_pub.add('VALIDATE Details conversion_type');
339:
340: -- Check if the conversion_type exists in GL
341: SELECT 'X'
342: INTO l_dummy_c

Line 368: -- oe_debug_pub.add('ERROR: Invalid Conversion_Type passed');

364: l_return_status := FND_API.G_RET_STS_ERROR;
365: FND_MESSAGE.SET_NAME('QP','QP_INVALID_CONV_TYPE'); -- CHANGE MESG_CODE
366: FND_MESSAGE.SET_TOKEN('CONVERSION_TYPE',p_CURR_DETAILS_rec.conversion_type);
367: OE_MSG_PUB.Add;
368: -- oe_debug_pub.add('ERROR: Invalid Conversion_Type passed');
369: End;
370: END;
371: END IF;
372:

Line 376: -- oe_debug_pub.add('VALIDATE Details conversion_date_type');

372:
373: -- Validate detail records' conversion_date_type
374: IF p_CURR_DETAILS_rec.conversion_date_type IS NOT NULL THEN
375: BEGIN
376: -- oe_debug_pub.add('VALIDATE Details conversion_date_type');
377:
378: SELECT 'X'
379: INTO l_dummy_c
380: FROM qp_lookups

Line 393: -- oe_debug_pub.add('ERROR: Invalid conversion_date_type');

389: l_return_status := FND_API.G_RET_STS_ERROR;
390: FND_MESSAGE.SET_NAME('QP','QP_INVALID_CONV_DT_TYPE'); -- CHANGE MESG_CODE
391: FND_MESSAGE.SET_TOKEN('CONVERSION_DATE_TYPE',p_CURR_DETAILS_rec.conversion_date_type);
392: OE_MSG_PUB.Add;
393: -- oe_debug_pub.add('ERROR: Invalid conversion_date_type');
394:
395: END;
396: END IF;
397:

Line 401: -- oe_debug_pub.add('VALIDATE Details markup_operator');

397:
398: -- Validate detail records' markup_operator
399: IF p_CURR_DETAILS_rec.markup_operator IS NOT NULL THEN
400: BEGIN
401: -- oe_debug_pub.add('VALIDATE Details markup_operator');
402:
403: SELECT 'X'
404: INTO l_dummy_c
405: FROM qp_lookups

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

414: IF ((p_CURR_DETAILS_rec.markup_formula_id IS NULL AND
415: p_CURR_DETAILS_rec.markup_value IS NULL)
416: )
417: THEN
418: -- oe_debug_pub.add('ERROR: Markup Formula or Value should be provided if Markup Operator is present');
419: l_return_status := FND_API.G_RET_STS_ERROR;
420: FND_MESSAGE.SET_NAME('QP','QP_FRML_OR_VAL_REQD'); -- CHANGE MESG_CODE
421: OE_MSG_PUB.Add;
422: END IF;

Line 430: -- oe_debug_pub.add('ERROR: Invalid markup_operator');

426: l_return_status := FND_API.G_RET_STS_ERROR;
427: FND_MESSAGE.SET_NAME('QP','QP_INVALID_MARKUP_OPRTR');
428: FND_MESSAGE.SET_TOKEN('MARKUP_OPERATOR',p_CURR_DETAILS_rec.markup_operator);
429: OE_MSG_PUB.Add;
430: -- oe_debug_pub.add('ERROR: Invalid markup_operator');
431:
432: END;
433: ELSE
434:

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

436: IF ((p_CURR_DETAILS_rec.markup_formula_id IS NOT NULL OR
437: p_CURR_DETAILS_rec.markup_value IS NOT NULL)
438: )
439: THEN
440: -- oe_debug_pub.add('ERROR: Markup Formula or Value can be provided only if Markup Operator is present');
441: l_return_status := FND_API.G_RET_STS_ERROR;
442: FND_MESSAGE.SET_NAME('QP','QP_MARKUP_OPRTR_REQD'); -- CHANGE MESG_CODE
443: OE_MSG_PUB.Add;
444: END IF;

Line 449: -- oe_debug_pub.add('Validate Detail Record''s conditional columns for to_currency_code: '||p_CURR_DETAILS_rec.to_currency_code);

445: END IF;
446:
447: -- Below statements Validate detail records' conditionally required columns
448: BEGIN
449: -- oe_debug_pub.add('Validate Detail Record''s conditional columns for to_currency_code: '||p_CURR_DETAILS_rec.to_currency_code);
450: -- oe_debug_pub.add('Detail record''s hdr_id: '||p_CURR_DETAILS_rec.currency_header_id);
451: -- Get the header's base currency code
452: Begin
453: SELECT base_currency_code

Line 450: -- oe_debug_pub.add('Detail record''s hdr_id: '||p_CURR_DETAILS_rec.currency_header_id);

446:
447: -- Below statements Validate detail records' conditionally required columns
448: BEGIN
449: -- oe_debug_pub.add('Validate Detail Record''s conditional columns for to_currency_code: '||p_CURR_DETAILS_rec.to_currency_code);
450: -- oe_debug_pub.add('Detail record''s hdr_id: '||p_CURR_DETAILS_rec.currency_header_id);
451: -- Get the header's base currency code
452: Begin
453: SELECT base_currency_code
454: INTO l_base_currency_code_s

Line 465: -- oe_debug_pub.add('Header Currency Code: '||l_base_currency_code_s);

461: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','currency_header_id');
462: OE_MSG_PUB.Add;
463: END;
464:
465: -- oe_debug_pub.add('Header Currency Code: '||l_base_currency_code_s);
466: -- --oe_debug_pub.add('Conversion Method: '||p_CURR_DETAILS_rec.CONVERSION_METHOD);
467:
468: IF (p_CURR_DETAILS_rec.to_currency_code = l_base_currency_code_s)
469: then

Line 466: -- --oe_debug_pub.add('Conversion Method: '||p_CURR_DETAILS_rec.CONVERSION_METHOD);

462: OE_MSG_PUB.Add;
463: END;
464:
465: -- oe_debug_pub.add('Header Currency Code: '||l_base_currency_code_s);
466: -- --oe_debug_pub.add('Conversion Method: '||p_CURR_DETAILS_rec.CONVERSION_METHOD);
467:
468: IF (p_CURR_DETAILS_rec.to_currency_code = l_base_currency_code_s)
469: then
470:

Line 471: -- oe_debug_pub.add('ERROR: To_Currency_Code can not be same as Base_Currency_Code');

467:
468: IF (p_CURR_DETAILS_rec.to_currency_code = l_base_currency_code_s)
469: then
470:
471: -- oe_debug_pub.add('ERROR: To_Currency_Code can not be same as Base_Currency_Code');
472: l_return_status := FND_API.G_RET_STS_ERROR;
473: FND_MESSAGE.SET_NAME('QP','QP_TO_DIFFERENT_FROM_BASE'); -- CHANGE MESG_CODE
474: OE_MSG_PUB.Add;
475:

Line 487: -- oe_debug_pub.add('ERROR: Value is not allowed in the following fields when to_currency is same as base_currency: FIXED_VALUE, PRICE_FORMULA_id, CONVERSION_TYPE, CONVERSION_DATE_TYPE, CONVERSION_DATE, START_DATE_ACTIVE, END_DATE_ACTIVE');

483: p_CURR_DETAILS_rec.START_DATE_ACTIVE is NOT NULL OR
484: p_CURR_DETAILS_rec.END_DATE_ACTIVE is NOT NULL )
485: then
486:
487: -- oe_debug_pub.add('ERROR: Value is not allowed in the following fields when to_currency is same as base_currency: FIXED_VALUE, PRICE_FORMULA_id, CONVERSION_TYPE, CONVERSION_DATE_TYPE, CONVERSION_DATE, START_DATE_ACTIVE, END_DATE_ACTIVE');
488: l_return_status := FND_API.G_RET_STS_ERROR;
489: FND_MESSAGE.SET_NAME('QP','QP_VALUE_NOT_ALLWD_CURR'); -- CHANGE MESG_CODE
490: OE_MSG_PUB.Add;
491: End if;

Line 500: -- oe_debug_pub.add('ERROR: CONVERSION_TYPE is required when to_currency_code is different from base_currency_code');

496: --IF (p_CURR_DETAILS_rec.CONVERSION_METHOD is NULL)
497: IF (p_CURR_DETAILS_rec.CONVERSION_TYPE is NULL)
498: THEN
499:
500: -- oe_debug_pub.add('ERROR: CONVERSION_TYPE is required when to_currency_code is different from base_currency_code');
501: l_return_status := FND_API.G_RET_STS_ERROR;
502: FND_MESSAGE.SET_NAME('QP','QP_CONV_TYPE_REQD'); -- CHANGE MESG_CODE
503: OE_MSG_PUB.Add;
504:

Line 512: -- oe_debug_pub.add('ERROR: Value is not allowed in the following fields when Conversion_Type = ''TRANSACTION'': FIXED_VALUE, PRICE_FORMULA_id, CONVERSION_DATE_TYPE, CONVERSION_DATE');

508: p_CURR_DETAILS_rec.PRICE_FORMULA_id is not NULL OR
509: p_CURR_DETAILS_rec.CONVERSION_DATE_TYPE is not NULL OR
510: p_CURR_DETAILS_rec.CONVERSION_DATE is not NULL)
511: then
512: -- oe_debug_pub.add('ERROR: Value is not allowed in the following fields when Conversion_Type = ''TRANSACTION'': FIXED_VALUE, PRICE_FORMULA_id, CONVERSION_DATE_TYPE, CONVERSION_DATE');
513: l_return_status := FND_API.G_RET_STS_ERROR;
514: FND_MESSAGE.SET_NAME('QP','QP_VALUE_NOT_ALLWD_TXN'); -- CHANGE MESG_CODE
515: OE_MSG_PUB.Add;
516: End If;

Line 522: -- oe_debug_pub.add('ERROR: FIXED_VALUE is required ehen Conversion_Type is ''FIXED''');

518: ELSIF (p_CURR_DETAILS_rec.CONVERSION_TYPE = 'FIXED')
519: THEN
520: If (p_CURR_DETAILS_rec.FIXED_VALUE is NULL)
521: then
522: -- oe_debug_pub.add('ERROR: FIXED_VALUE is required ehen Conversion_Type is ''FIXED''');
523: l_return_status := FND_API.G_RET_STS_ERROR;
524: FND_MESSAGE.SET_NAME('QP','QP_FIXED_VALUE_REQD'); -- CHANGE MESG_CODE
525: OE_MSG_PUB.Add;
526: End If;

Line 533: -- oe_debug_pub.add('ERROR: Value is not allowed in the following fields when Conversion_Type = ''FIXED'': PRICE_FORMULA_id, CONVERSION_DATE_TYPE, CONVERSION_DATE');

529: -- p_CURR_DETAILS_rec.CONVERSION_TYPE is not NULL OR
530: p_CURR_DETAILS_rec.CONVERSION_DATE_TYPE is not NULL OR
531: p_CURR_DETAILS_rec.CONVERSION_DATE is not NULL)
532: then
533: -- oe_debug_pub.add('ERROR: Value is not allowed in the following fields when Conversion_Type = ''FIXED'': PRICE_FORMULA_id, CONVERSION_DATE_TYPE, CONVERSION_DATE');
534: l_return_status := FND_API.G_RET_STS_ERROR;
535: FND_MESSAGE.SET_NAME('QP','QP_VALUE_NOT_ALLWD_FIXED'); -- CHANGE MESG_CODE
536: OE_MSG_PUB.Add;
537: End If;

Line 544: -- oe_debug_pub.add('ERROR: CONVERSION_DATE_TYPE is required when Conversion_Type is Not ''FIXED'' or ''FORMULA'' or ''TRANSACTION''');

540: THEN
541: --If (p_CURR_DETAILS_rec.CONVERSION_TYPE is NULL OR
542: If (p_CURR_DETAILS_rec.CONVERSION_DATE_TYPE is NULL)
543: then
544: -- oe_debug_pub.add('ERROR: CONVERSION_DATE_TYPE is required when Conversion_Type is Not ''FIXED'' or ''FORMULA'' or ''TRANSACTION''');
545: l_return_status := FND_API.G_RET_STS_ERROR;
546: FND_MESSAGE.SET_NAME('QP','QP_CONV_DT_TYPE_REQD'); -- CHANGE MESG_CODE
547: OE_MSG_PUB.Add;
548: End If;

Line 553: -- oe_debug_pub.add('ERROR: Value is not allowed in the following fields when Conversion_Type is Not ''FIXED'' or ''FORMULA'': PRICE_FORMULA_id, FIXED_VALUE');

549:
550: If (p_CURR_DETAILS_rec.PRICE_FORMULA_id is not NULL OR
551: p_CURR_DETAILS_rec.FIXED_VALUE is not NULL)
552: then
553: -- oe_debug_pub.add('ERROR: Value is not allowed in the following fields when Conversion_Type is Not ''FIXED'' or ''FORMULA'': PRICE_FORMULA_id, FIXED_VALUE');
554: l_return_status := FND_API.G_RET_STS_ERROR;
555: FND_MESSAGE.SET_NAME('QP','QP_VALUE_NOT_ALLWD_GL'); -- CHANGE MESG_CODE
556: OE_MSG_PUB.Add;
557: End If;

Line 562: -- oe_debug_pub.add('ERROR: CONVERSION_DATE is required when CONVERSION_TYPE is Not (''FIXED'' or ''FORMULA'' or ''TRANSACTION'') and CONVERSION_DATE_TYPE = ''FIXED''');

558:
559: if (p_CURR_DETAILS_rec.CONVERSION_DATE_TYPE = 'FIXED')
560: then
561: if (p_CURR_DETAILS_rec.CONVERSION_DATE is NULL) then
562: -- oe_debug_pub.add('ERROR: CONVERSION_DATE is required when CONVERSION_TYPE is Not (''FIXED'' or ''FORMULA'' or ''TRANSACTION'') and CONVERSION_DATE_TYPE = ''FIXED''');
563: l_return_status := FND_API.G_RET_STS_ERROR;
564: FND_MESSAGE.SET_NAME('QP','QP_CONV_DT_REQUIRED'); -- CHANGE MESG_CODE
565: OE_MSG_PUB.Add;
566: End if;

Line 569: -- oe_debug_pub.add('ERROR: CONVERSION_DATE is allowed only when CONVERSION_TYPE is Not (''FIXED'' or ''FORMULA'' or ''TRANSACTION'') and CONVERSION_DATE_TYPE <> ''FIXED''');

565: OE_MSG_PUB.Add;
566: End if;
567: Else
568: if (p_CURR_DETAILS_rec.CONVERSION_DATE is NOT NULL) then
569: -- oe_debug_pub.add('ERROR: CONVERSION_DATE is allowed only when CONVERSION_TYPE is Not (''FIXED'' or ''FORMULA'' or ''TRANSACTION'') and CONVERSION_DATE_TYPE <> ''FIXED''');
570: l_return_status := FND_API.G_RET_STS_ERROR;
571: FND_MESSAGE.SET_NAME('QP','QP_CONV_DT_NOT_ALLWD'); -- CHANGE MESG_CODE
572: OE_MSG_PUB.Add;
573: End if;

Line 579: -- oe_debug_pub.add('ERROR: PRICE_FORMULA_id is required for Conversion_Type = ''FORMULA''');

575: End if;
576: ELSIF (p_CURR_DETAILS_rec.CONVERSION_TYPE = 'FORMULA')
577: THEN
578: If p_CURR_DETAILS_rec.PRICE_FORMULA_id is NULL then
579: -- oe_debug_pub.add('ERROR: PRICE_FORMULA_id is required for Conversion_Type = ''FORMULA''');
580: l_return_status := FND_API.G_RET_STS_ERROR;
581: FND_MESSAGE.SET_NAME('QP','QP_PRICE_FORMULA_REQD'); -- CHANGE MESG_CODE
582: OE_MSG_PUB.Add;
583: End If;

Line 589: -- oe_debug_pub.add('ERROR: Value is not allowed in the following fields when Conversion_Type = ''FORMULA'': FIXED_VALUE, CONVERSION_DATE_TYPE, CONVERSION_DATE');

585: If (p_CURR_DETAILS_rec.FIXED_VALUE is not NULL OR
586: p_CURR_DETAILS_rec.CONVERSION_DATE_TYPE is not NULL OR
587: p_CURR_DETAILS_rec.CONVERSION_DATE is not NULL)
588: then
589: -- oe_debug_pub.add('ERROR: Value is not allowed in the following fields when Conversion_Type = ''FORMULA'': FIXED_VALUE, CONVERSION_DATE_TYPE, CONVERSION_DATE');
590: -- oe_debug_pub.add('. FIXED VALUE: '||p_CURR_DETAILS_rec.FIXED_VALUE);
591: l_return_status := FND_API.G_RET_STS_ERROR;
592: FND_MESSAGE.SET_NAME('QP','QP_FVAL_OR_CONV_NOT_ALLWD'); -- CHANGE MESG_CODE
593: OE_MSG_PUB.Add;

Line 590: -- oe_debug_pub.add('. FIXED VALUE: '||p_CURR_DETAILS_rec.FIXED_VALUE);

586: p_CURR_DETAILS_rec.CONVERSION_DATE_TYPE is not NULL OR
587: p_CURR_DETAILS_rec.CONVERSION_DATE is not NULL)
588: then
589: -- oe_debug_pub.add('ERROR: Value is not allowed in the following fields when Conversion_Type = ''FORMULA'': FIXED_VALUE, CONVERSION_DATE_TYPE, CONVERSION_DATE');
590: -- oe_debug_pub.add('. FIXED VALUE: '||p_CURR_DETAILS_rec.FIXED_VALUE);
591: l_return_status := FND_API.G_RET_STS_ERROR;
592: FND_MESSAGE.SET_NAME('QP','QP_FVAL_OR_CONV_NOT_ALLWD'); -- CHANGE MESG_CODE
593: OE_MSG_PUB.Add;
594: End If;

Line 602: -- oe_debug_pub.add('VALIDATE Details curr_attribute_type');

598:
599: -- Validate detail records' CURR_ATTRIBUTE_TYPE
600: IF p_CURR_DETAILS_rec.curr_attribute_type IS NOT NULL THEN
601: BEGIN
602: -- oe_debug_pub.add('VALIDATE Details curr_attribute_type');
603:
604: SELECT 'X'
605: INTO l_dummy_c
606: FROM qp_lookups

Line 619: -- oe_debug_pub.add('ERROR: Invalid curr_attribute_type');

615: l_return_status := FND_API.G_RET_STS_ERROR;
616: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
617: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CURRENCY ATTRIBUTE TYPE');
618: OE_MSG_PUB.Add;
619: -- oe_debug_pub.add('ERROR: Invalid curr_attribute_type');
620:
621: END;
622: END IF;
623:

Line 717: -- oe_debug_pub.add('ERROR: Precedence is required when Attribute type is not NULL');

713: then
714: l_return_status := FND_API.G_RET_STS_ERROR;
715: FND_MESSAGE.SET_NAME('QP','QP_PRECEDENCE_REQD'); -- CHANGE MESG_CODE
716: OE_MSG_PUB.Add;
717: -- oe_debug_pub.add('ERROR: Precedence is required when Attribute type is not NULL');
718: End If; -- precedence is null
719:
720: -- Validate the Inventory_item_id/category_id if the type is PRODUCT and attribute
721: -- is PA1/PA2

Line 743: --** oe_debug_pub.add('ERROR: Invalid Inventory_Item_id provided');

739:
740: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ITEM');
741: FND_MESSAGE.SET_TOKEN('ITEM_ID',p_CURR_DETAILS_rec.curr_attribute_value);
742: OE_MSG_PUB.Add;
743: --** oe_debug_pub.add('ERROR: Invalid Inventory_Item_id provided');
744:
745: END;
746:
747: END IF; --Item Number

Line 766: --** oe_debug_pub.add('ERROR: Invalid Category_id provided');

762:
763: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ITEM_CATEGORY');
764: FND_MESSAGE.SET_TOKEN('CATEGORY_ID',p_CURR_DETAILS_rec.curr_attribute_value);
765: OE_MSG_PUB.Add;
766: --** oe_debug_pub.add('ERROR: Invalid Category_id provided');
767:
768: END;*/
769:
770: -- Functional Area validation for Hierarchical Categories (sfiresto)

Line 811: -- oe_debug_pub.add('ERROR: All of the following fields should either be NULL or NOT NULL: CURR_ATTRIBUTE_TYPE, CURR_ATTRIBUTE_CONTEXT, CURR_ATTRIBUTE, CURR_ATTRIBUTE_VALUE');

807: -- so at least one of these attributes is NULL.
808: l_return_status := FND_API.G_RET_STS_ERROR;
809: FND_MESSAGE.SET_NAME('QP','QP_CURR_ATTRS_REQD_OR_NULL'); -- CHANGE MESG_CODE
810: OE_MSG_PUB.Add;
811: -- oe_debug_pub.add('ERROR: All of the following fields should either be NULL or NOT NULL: CURR_ATTRIBUTE_TYPE, CURR_ATTRIBUTE_CONTEXT, CURR_ATTRIBUTE, CURR_ATTRIBUTE_VALUE');
812:
813: END IF;
814:
815: -- Validate correctness and uniqueness of precedence

Line 825: -- oe_debug_pub.add('ERROR: Precedence should be a positive integer value');

821: l_return_status := FND_API.G_RET_STS_ERROR;
822: FND_MESSAGE.SET_NAME('QP','QP_INTEGER_REQUIRED');
823: FND_MESSAGE.SET_TOKEN('ENTITY','PRECEDENCE');
824: OE_MSG_PUB.Add;
825: -- oe_debug_pub.add('ERROR: Precedence should be a positive integer value');
826: Else
827: -- Validate that only one active detail record exist at any point of time
828: BEGIN
829: -- oe_debug_pub.add('VALIDATE Uniqueness of to_currency_code');

Line 829: -- oe_debug_pub.add('VALIDATE Uniqueness of to_currency_code');

825: -- oe_debug_pub.add('ERROR: Precedence should be a positive integer value');
826: Else
827: -- Validate that only one active detail record exist at any point of time
828: BEGIN
829: -- oe_debug_pub.add('VALIDATE Uniqueness of to_currency_code');
830: For detail_rec in CURSOR_PRECEDENCE_UNIQUENESS
831: (p_CURR_DETAILS_rec.to_currency_code,
832: p_CURR_DETAILS_rec.currency_header_id,
833: p_CURR_DETAILS_rec.currency_detail_id,

Line 855: -- oe_debug_pub.add('ERROR: Precedence should be unique for a to_currency_code within a given period');

851:
852: l_return_status := FND_API.G_RET_STS_ERROR;
853: FND_MESSAGE.SET_NAME('QP','QP_UNIQUE_PRECEDENCE'); -- CHANGE MESG_CODE
854: OE_MSG_PUB.Add;
855: -- oe_debug_pub.add('ERROR: Precedence should be unique for a to_currency_code within a given period');
856: exit; -- Exit the loop
857: End if; -- date check
858: END LOOP;
859:

Line 866: oe_debug_pub.add('ENTITY - before rounding_factor');

862: End If; -- precedence is an integer
863:
864: END IF; -- precedence is not NULL
865:
866: oe_debug_pub.add('ENTITY - before rounding_factor');
867: IF p_CURR_DETAILS_rec.rounding_factor IS NOT NULL AND
868: p_CURR_DETAILS_rec.to_currency_code IS NOT NULL THEN
869: IF NOT QP_Validate.Rounding_Factor(p_CURR_DETAILS_rec.rounding_factor,
870: p_CURR_DETAILS_rec.to_currency_code) THEN

Line 871: oe_debug_pub.add('ENTITY rounding_factor error occured');

867: IF p_CURR_DETAILS_rec.rounding_factor IS NOT NULL AND
868: p_CURR_DETAILS_rec.to_currency_code IS NOT NULL THEN
869: IF NOT QP_Validate.Rounding_Factor(p_CURR_DETAILS_rec.rounding_factor,
870: p_CURR_DETAILS_rec.to_currency_code) THEN
871: oe_debug_pub.add('ENTITY rounding_factor error occured');
872: l_return_status := FND_API.G_RET_STS_ERROR;
873: END IF;
874: END IF;
875:

Line 876: oe_debug_pub.add('ENTITY - before selling rounding_factor');

872: l_return_status := FND_API.G_RET_STS_ERROR;
873: END IF;
874: END IF;
875:
876: oe_debug_pub.add('ENTITY - before selling rounding_factor');
877: IF p_CURR_DETAILS_rec.selling_rounding_factor IS NOT NULL AND
878: p_CURR_DETAILS_rec.to_currency_code IS NOT NULL THEN
879: IF NOT QP_Validate.Rounding_Factor(p_CURR_DETAILS_rec.selling_rounding_factor,
880: p_CURR_DETAILS_rec.to_currency_code) THEN

Line 881: oe_debug_pub.add('ENTITY selling_rounding_factor error occured');

877: IF p_CURR_DETAILS_rec.selling_rounding_factor IS NOT NULL AND
878: p_CURR_DETAILS_rec.to_currency_code IS NOT NULL THEN
879: IF NOT QP_Validate.Rounding_Factor(p_CURR_DETAILS_rec.selling_rounding_factor,
880: p_CURR_DETAILS_rec.to_currency_code) THEN
881: oe_debug_pub.add('ENTITY selling_rounding_factor error occured');
882: l_return_status := FND_API.G_RET_STS_ERROR;
883: END IF;
884: END IF;
885:

Line 900: -- oe_debug_pub.add('G_MSG_CONTEXT_COUNT: '||OE_MSG_PUB.G_MSG_CONTEXT_COUNT);

896:
897: END;
898: -- Above statements Validate detail records' conditionally required columns
899:
900: -- oe_debug_pub.add('G_MSG_CONTEXT_COUNT: '||OE_MSG_PUB.G_MSG_CONTEXT_COUNT);
901: -- oe_debug_pub.add('Coming Out of CDT L package');
902: -- Above validations Added by Sunil Pandey
903:
904:

Line 901: -- oe_debug_pub.add('Coming Out of CDT L package');

897: END;
898: -- Above statements Validate detail records' conditionally required columns
899:
900: -- oe_debug_pub.add('G_MSG_CONTEXT_COUNT: '||OE_MSG_PUB.G_MSG_CONTEXT_COUNT);
901: -- oe_debug_pub.add('Coming Out of CDT L package');
902: -- Above validations Added by Sunil Pandey
903:
904:
905: -- Return Error if a required attribute is missing.

Line 926: oe_debug_pub.add('Here 0000');

922: --has a sourcing method of 'ATTRIBUTE MAPPING' but is not sourcing-enabled
923: --or if its sourcing_status is not 'Y', i.e., the build sourcing conc.
924: --program has to be run.
925:
926: oe_debug_pub.add('Here 0000');
927: IF qp_util.attrmgr_installed = 'Y' THEN
928: oe_debug_pub.add('Here 1111');
929: IF p_CURR_DETAILS_rec.curr_attribute_context IS NOT NULL AND
930: p_CURR_DETAILS_rec.curr_attribute IS NOT NULL

Line 928: oe_debug_pub.add('Here 1111');

924: --program has to be run.
925:
926: oe_debug_pub.add('Here 0000');
927: IF qp_util.attrmgr_installed = 'Y' THEN
928: oe_debug_pub.add('Here 1111');
929: IF p_CURR_DETAILS_rec.curr_attribute_context IS NOT NULL AND
930: p_CURR_DETAILS_rec.curr_attribute IS NOT NULL
931: THEN
932: oe_debug_pub.add('Here 2222');

Line 932: oe_debug_pub.add('Here 2222');

928: oe_debug_pub.add('Here 1111');
929: IF p_CURR_DETAILS_rec.curr_attribute_context IS NOT NULL AND
930: p_CURR_DETAILS_rec.curr_attribute IS NOT NULL
931: THEN
932: oe_debug_pub.add('Here 2222');
933: If p_CURR_DETAILS_rec.curr_attribute_type = 'QUALIFIER' then
934: QP_UTIL.Get_Context_Type('QP_ATTR_DEFNS_QUALIFIER',
935: p_CURR_DETAILS_rec.curr_attribute_context,
936: l_context_type,

Line 947: oe_debug_pub.add('Here 3333');

943: End if;
944:
945: IF l_error_code = 0 THEN --successfully returned context_type
946:
947: oe_debug_pub.add('Here 3333');
948: oe_debug_pub.add('l_context_type = ' || l_context_type);
949: oe_debug_pub.add('p_CURR_DETAILS_rec.curr_attribute_context = ' || p_CURR_DETAILS_rec.curr_attribute_context);
950: oe_debug_pub.add('p_CURR_DETAILS_rec.curr_attribute = ' || p_CURR_DETAILS_rec.curr_attribute);
951: QP_UTIL.Get_Sourcing_Info(l_context_type,

Line 948: oe_debug_pub.add('l_context_type = ' || l_context_type);

944:
945: IF l_error_code = 0 THEN --successfully returned context_type
946:
947: oe_debug_pub.add('Here 3333');
948: oe_debug_pub.add('l_context_type = ' || l_context_type);
949: oe_debug_pub.add('p_CURR_DETAILS_rec.curr_attribute_context = ' || p_CURR_DETAILS_rec.curr_attribute_context);
950: oe_debug_pub.add('p_CURR_DETAILS_rec.curr_attribute = ' || p_CURR_DETAILS_rec.curr_attribute);
951: QP_UTIL.Get_Sourcing_Info(l_context_type,
952: p_CURR_DETAILS_rec.curr_attribute_context,

Line 949: oe_debug_pub.add('p_CURR_DETAILS_rec.curr_attribute_context = ' || p_CURR_DETAILS_rec.curr_attribute_context);

945: IF l_error_code = 0 THEN --successfully returned context_type
946:
947: oe_debug_pub.add('Here 3333');
948: oe_debug_pub.add('l_context_type = ' || l_context_type);
949: oe_debug_pub.add('p_CURR_DETAILS_rec.curr_attribute_context = ' || p_CURR_DETAILS_rec.curr_attribute_context);
950: oe_debug_pub.add('p_CURR_DETAILS_rec.curr_attribute = ' || p_CURR_DETAILS_rec.curr_attribute);
951: QP_UTIL.Get_Sourcing_Info(l_context_type,
952: p_CURR_DETAILS_rec.curr_attribute_context,
953: p_CURR_DETAILS_rec.curr_attribute,

Line 950: oe_debug_pub.add('p_CURR_DETAILS_rec.curr_attribute = ' || p_CURR_DETAILS_rec.curr_attribute);

946:
947: oe_debug_pub.add('Here 3333');
948: oe_debug_pub.add('l_context_type = ' || l_context_type);
949: oe_debug_pub.add('p_CURR_DETAILS_rec.curr_attribute_context = ' || p_CURR_DETAILS_rec.curr_attribute_context);
950: oe_debug_pub.add('p_CURR_DETAILS_rec.curr_attribute = ' || p_CURR_DETAILS_rec.curr_attribute);
951: QP_UTIL.Get_Sourcing_Info(l_context_type,
952: p_CURR_DETAILS_rec.curr_attribute_context,
953: p_CURR_DETAILS_rec.curr_attribute,
954: l_sourcing_enabled,

Line 958: oe_debug_pub.add('l_sourcing_method = ' || l_sourcing_method);

954: l_sourcing_enabled,
955: l_sourcing_status,
956: l_sourcing_method);
957:
958: oe_debug_pub.add('l_sourcing_method = ' || l_sourcing_method);
959: IF l_sourcing_method = 'ATTRIBUTE MAPPING' THEN
960:
961: oe_debug_pub.add('Here 4444');
962: IF l_sourcing_enabled <> 'Y' THEN

Line 961: oe_debug_pub.add('Here 4444');

957:
958: oe_debug_pub.add('l_sourcing_method = ' || l_sourcing_method);
959: IF l_sourcing_method = 'ATTRIBUTE MAPPING' THEN
960:
961: oe_debug_pub.add('Here 4444');
962: IF l_sourcing_enabled <> 'Y' THEN
963:
964: oe_debug_pub.add('Here 5555');
965: FND_MESSAGE.SET_NAME('QP','QP_ENABLE_SOURCING');

Line 964: oe_debug_pub.add('Here 5555');

960:
961: oe_debug_pub.add('Here 4444');
962: IF l_sourcing_enabled <> 'Y' THEN
963:
964: oe_debug_pub.add('Here 5555');
965: FND_MESSAGE.SET_NAME('QP','QP_ENABLE_SOURCING');
966: FND_MESSAGE.SET_TOKEN('CONTEXT',
967: p_CURR_DETAILS_rec.curr_attribute_context);
968: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

Line 976: oe_debug_pub.add('Here 6666');

972: END IF;
973:
974: IF l_sourcing_status <> 'Y' THEN
975:
976: oe_debug_pub.add('Here 6666');
977: FND_MESSAGE.SET_NAME('QP','QP_BUILD_SOURCING_RULES');
978: FND_MESSAGE.SET_TOKEN('CONTEXT',
979: p_CURR_DETAILS_rec.curr_attribute_context);
980: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',