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 FND_API

Line 17: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

13: , p_old_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type :=
14: QP_Currency_PUB.G_MISS_CURR_DETAILS_REC
15: )
16: IS
17: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
18: l_dummy_c VARCHAR2(1);
19: l_base_currency_code_s QP_CURRENCY_LISTS_B.base_currency_code%TYPE;
20: l_default_start_date_d DATE := to_date('01/01/1951','mm/dd/yyyy');
21: l_default_end_date_d DATE := to_date('12/31/9999','mm/dd/yyyy');

Line 86: l_return_status := FND_API.G_RET_STS_ERROR;

82:
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

Line 112: l_return_status := FND_API.G_RET_STS_ERROR;

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:
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);

Line 121: -- raise FND_API.G_EXC_ERROR;

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
125: BEGIN

Line 152: l_return_status := FND_API.G_RET_STS_ERROR;

148: nvl(detail_rec.end_date_active, l_default_end_date_d))
149: )
150: then
151:
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);

Line 184: l_return_status := FND_API.G_RET_STS_ERROR;

180: and nvl(end_date_active,trunc(sysdate));
181:
182: EXCEPTION
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:

Line 193: p_CURR_DETAILS_rec.price_formula_id <> FND_API.G_MISS_NUM)

189: END;
190:
191: -- Validate detail records' 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:

Line 213: l_return_status := FND_API.G_RET_STS_ERROR;

209: and nvl(fl.end_date_active, trunc(sysdate)));
210:
211: EXCEPTION
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:

Line 238: l_return_status := FND_API.G_RET_STS_ERROR;

234: and nvl(fl.end_date_active, trunc(sysdate)));
235:
236: EXCEPTION
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:

Line 250: p_CURR_DETAILS_rec.markup_operator <> FND_API.G_MISS_CHAR) AND

246: /*
247: -- Validate detail records' conditional columns
248: -- Markup value or formula should be present if operator is present
249: IF ((p_CURR_DETAILS_rec.markup_operator IS NOT NULL and
250: p_CURR_DETAILS_rec.markup_operator <> FND_API.G_MISS_CHAR) AND
251: (p_CURR_DETAILS_rec.markup_formula_id IS NULL AND
252: p_CURR_DETAILS_rec.markup_value IS NULL)
253: )
254: THEN

Line 256: l_return_status := FND_API.G_RET_STS_ERROR;

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;
260:

Line 268: l_return_status := FND_API.G_RET_STS_ERROR;

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;
272: */

Line 305: l_return_status := FND_API.G_RET_STS_ERROR;

301: and nvl(fl.end_date_active, trunc(sysdate)));
302:
303: EXCEPTION
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:

Line 327: l_return_status := FND_API.G_RET_STS_ERROR;

323: and lookup_code = p_CURR_DETAILS_rec.conversion_method;
324:
325: EXCEPTION
326: WHEN NO_DATA_FOUND THEN
327: l_return_status := FND_API.G_RET_STS_ERROR;
328: FND_MESSAGE.SET_NAME('QP','Invalid_Conversion_Method'); -- CHANGE MESG_CODE
329: OE_MSG_PUB.Add;
330:
331: END;

Line 364: l_return_status := FND_API.G_RET_STS_ERROR;

360: EXCEPTION
361: WHEN NO_DATA_FOUND THEN
362: -- If not found in either GL or lookup_code then raise error
363:
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');

Line 389: l_return_status := FND_API.G_RET_STS_ERROR;

385: nvl(start_date_active, trunc(sysdate)) and nvl(end_date_active, trunc(sysdate));
386:
387: EXCEPTION
388: WHEN NO_DATA_FOUND THEN
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');

Line 419: l_return_status := FND_API.G_RET_STS_ERROR;

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;
423:

Line 426: l_return_status := FND_API.G_RET_STS_ERROR;

422: END IF;
423:
424: EXCEPTION
425: WHEN NO_DATA_FOUND THEN
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');

Line 441: l_return_status := FND_API.G_RET_STS_ERROR;

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;
445: END IF;

Line 459: l_return_status := FND_API.G_RET_STS_ERROR;

455: FROM QP_CURRENCY_LISTS_B
456: WHERE currency_header_id = p_CURR_DETAILS_rec.currency_header_id;
457: Exception
458: When NO_DATA_FOUND THEN
459: l_return_status := FND_API.G_RET_STS_ERROR;
460: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
461: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','currency_header_id');
462: OE_MSG_PUB.Add;
463: END;

Line 472: l_return_status := FND_API.G_RET_STS_ERROR;

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:
476: /* This validation is obsolete now

Line 488: l_return_status := FND_API.G_RET_STS_ERROR;

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;
492: */

Line 501: l_return_status := FND_API.G_RET_STS_ERROR;

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:
505: ELSIF (p_CURR_DETAILS_rec.CONVERSION_TYPE = 'TRANSACTION')

Line 513: l_return_status := FND_API.G_RET_STS_ERROR;

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;
517:

Line 523: l_return_status := FND_API.G_RET_STS_ERROR;

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;
527:

Line 534: l_return_status := FND_API.G_RET_STS_ERROR;

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;
538: -- ELSIF (p_CURR_DETAILS_rec.CONVERSION_METHOD = 'GL')

Line 545: l_return_status := FND_API.G_RET_STS_ERROR;

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;
549:

Line 554: l_return_status := FND_API.G_RET_STS_ERROR;

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;
558:

Line 563: l_return_status := FND_API.G_RET_STS_ERROR;

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;
567: Else

Line 570: l_return_status := FND_API.G_RET_STS_ERROR;

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;
574:

Line 580: l_return_status := FND_API.G_RET_STS_ERROR;

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;
584:

Line 591: l_return_status := FND_API.G_RET_STS_ERROR;

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;
595: END IF; -- Conversion_Type

Line 615: l_return_status := FND_API.G_RET_STS_ERROR;

611: nvl(start_date_active, trunc(sysdate)) and nvl(end_date_active, trunc(sysdate));
612:
613: EXCEPTION
614: WHEN NO_DATA_FOUND THEN
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');

Line 654: l_return_status := FND_API.G_RET_STS_ERROR;

650: );
651:
652: If (l_context_flag = 'N' AND l_error_code = 7) -- invalid context
653: Then
654: l_return_status := FND_API.G_RET_STS_ERROR;
655:
656: If p_CURR_DETAILS_rec.curr_attribute_type = 'PRODUCT' then
657: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PROD_CONTEXT' );
658: ElsIf p_CURR_DETAILS_rec.curr_attribute_type = 'PRICING' then

Line 673: l_return_status := FND_API.G_RET_STS_ERROR;

669: End If;
670:
671: If (l_attribute_flag = 'N' AND l_error_code = 8) -- invalid attribute
672: Then
673: l_return_status := FND_API.G_RET_STS_ERROR;
674:
675: If p_CURR_DETAILS_rec.curr_attribute_type = 'PRODUCT' then
676: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PROD_ATTR' );
677: ElsIf p_CURR_DETAILS_rec.curr_attribute_type = 'PRICING' then

Line 692: l_return_status := FND_API.G_RET_STS_ERROR;

688: End If;
689:
690: If (l_value_flag = 'N' AND l_error_code = 9) -- invalid value
691: Then
692: l_return_status := FND_API.G_RET_STS_ERROR;
693:
694: If p_CURR_DETAILS_rec.curr_attribute_type = 'PRODUCT' then
695: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PROD_VALUE' );
696: ElsIf p_CURR_DETAILS_rec.curr_attribute_type = 'PRICING' then

Line 714: l_return_status := FND_API.G_RET_STS_ERROR;

710:
711: -- Precedence should be NOT NULL
712: If p_CURR_DETAILS_rec.precedence IS 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

Line 738: l_return_status := FND_API.G_RET_STS_ERROR;

734: organization_id = l_org_id;
735:
736: EXCEPTION
737: WHEN NO_DATA_FOUND THEN
738: l_return_status := FND_API.G_RET_STS_ERROR;
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;

Line 761: l_return_status := FND_API.G_RET_STS_ERROR;

757: ROWNUM = 1;
758:
759: EXCEPTION
760: WHEN NO_DATA_FOUND THEN
761: l_return_status := FND_API.G_RET_STS_ERROR;
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;

Line 786: l_return_status := FND_API.G_RET_STS_ERROR;

782: l_fna_valid);
783:
784: IF NOT l_fna_valid THEN
785:
786: l_return_status := FND_API.G_RET_STS_ERROR;
787:
788: FND_MESSAGE.set_name('QP', 'QP_INVALID_CAT_FUNC_PTE');
789: FND_MESSAGE.set_token('CATID', p_CURR_DETAILS_rec.curr_attribute_value);
790: FND_MESSAGE.set_token('PTE', l_pte_code);

Line 808: l_return_status := FND_API.G_RET_STS_ERROR;

804: p_CURR_DETAILS_rec.curr_attribute_value IS NOT NULL )
805: THEN
806: -- This elsif checks if any of the curr_attribute is not NULL. Since the above test failed
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:

Line 821: l_return_status := FND_API.G_RET_STS_ERROR;

817: -- Validate that the prcedence is an integer
818: If ( (instr(to_char(p_CURR_DETAILS_rec.precedence), '.', 1) <> 0) OR
819: (p_CURR_DETAILS_rec.precedence < 0) )
820: then
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');

Line 852: l_return_status := FND_API.G_RET_STS_ERROR;

848: nvl(detail_rec.end_date_active, l_default_end_date_d))
849: )
850: then
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

Line 872: l_return_status := FND_API.G_RET_STS_ERROR;

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:
876: oe_debug_pub.add('ENTITY - before selling rounding_factor');

Line 882: l_return_status := FND_API.G_RET_STS_ERROR;

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:
886: -- Bug 2293974 - rounding factor is mandatory

Line 888: p_CURR_DETAILS_rec.selling_rounding_factor = FND_API.G_MISS_NUM )

884: END IF;
885:
886: -- Bug 2293974 - rounding factor is mandatory
887: If (p_CURR_DETAILS_rec.selling_rounding_factor is NULL or
888: p_CURR_DETAILS_rec.selling_rounding_factor = FND_API.G_MISS_NUM )
889: then
890: l_return_status := FND_API.G_RET_STS_ERROR;
891:
892: FND_MESSAGE.SET_NAME('QP','QP_RNDG_FACTOR_REQD');

Line 890: l_return_status := FND_API.G_RET_STS_ERROR;

886: -- Bug 2293974 - rounding factor is mandatory
887: If (p_CURR_DETAILS_rec.selling_rounding_factor is NULL or
888: p_CURR_DETAILS_rec.selling_rounding_factor = FND_API.G_MISS_NUM )
889: then
890: l_return_status := FND_API.G_RET_STS_ERROR;
891:
892: FND_MESSAGE.SET_NAME('QP','QP_RNDG_FACTOR_REQD');
893: oe_msg_pub.add;
894:

Line 907: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

903:
904:
905: -- Return Error if a required attribute is missing.
906:
907: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
908:
909: RAISE FND_API.G_EXC_ERROR;
910:
911: END IF;

Line 909: RAISE FND_API.G_EXC_ERROR;

905: -- Return Error if a required attribute is missing.
906:
907: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
908:
909: RAISE FND_API.G_EXC_ERROR;
910:
911: END IF;
912:
913: --

Line 1001: WHEN FND_API.G_EXC_ERROR THEN

997: x_return_status := l_return_status;
998:
999: EXCEPTION
1000:
1001: WHEN FND_API.G_EXC_ERROR THEN
1002:
1003: x_return_status := FND_API.G_RET_STS_ERROR;
1004:
1005: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1003: x_return_status := FND_API.G_RET_STS_ERROR;

999: EXCEPTION
1000:
1001: WHEN FND_API.G_EXC_ERROR THEN
1002:
1003: x_return_status := FND_API.G_RET_STS_ERROR;
1004:
1005: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1006:
1007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1005: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1001: WHEN FND_API.G_EXC_ERROR THEN
1002:
1003: x_return_status := FND_API.G_RET_STS_ERROR;
1004:
1005: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1006:
1007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1008:
1009: WHEN OTHERS THEN

Line 1007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1003: x_return_status := FND_API.G_RET_STS_ERROR;
1004:
1005: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1006:
1007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1008:
1009: WHEN OTHERS THEN
1010:
1011: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1011: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1008:
1009: WHEN OTHERS THEN
1010:
1011: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1012:
1013: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1014: THEN
1015: OE_MSG_PUB.Add_Exc_Msg

Line 1034: x_return_status := FND_API.G_RET_STS_SUCCESS;

1030: )
1031: IS
1032: BEGIN
1033:
1034: x_return_status := FND_API.G_RET_STS_SUCCESS;
1035:
1036: -- Validate CURR_DETAILS attributes
1037:
1038: IF p_CURR_DETAILS_rec.conversion_date IS NOT NULL AND

Line 1044: x_return_status := FND_API.G_RET_STS_ERROR;

1040: p_old_CURR_DETAILS_rec.conversion_date OR
1041: p_old_CURR_DETAILS_rec.conversion_date IS NULL )
1042: THEN
1043: IF NOT QP_Validate.Conversion_Date(p_CURR_DETAILS_rec.conversion_date) THEN
1044: x_return_status := FND_API.G_RET_STS_ERROR;
1045: END IF;
1046: END IF;
1047:
1048: IF p_CURR_DETAILS_rec.conversion_date_type IS NOT NULL AND

Line 1054: x_return_status := FND_API.G_RET_STS_ERROR;

1050: p_old_CURR_DETAILS_rec.conversion_date_type OR
1051: p_old_CURR_DETAILS_rec.conversion_date_type IS NULL )
1052: THEN
1053: IF NOT QP_Validate.Conversion_Date_Type(p_CURR_DETAILS_rec.conversion_date_type) THEN
1054: x_return_status := FND_API.G_RET_STS_ERROR;
1055: END IF;
1056: END IF;
1057:
1058: /*

Line 1065: x_return_status := FND_API.G_RET_STS_ERROR;

1061: p_old_CURR_DETAILS_rec.conversion_method OR
1062: p_old_CURR_DETAILS_rec.conversion_method IS NULL )
1063: THEN
1064: IF NOT QP_Validate.Conversion_Method(p_CURR_DETAILS_rec.conversion_method) THEN
1065: x_return_status := FND_API.G_RET_STS_ERROR;
1066: END IF;
1067: END IF;
1068: */
1069:

Line 1076: x_return_status := FND_API.G_RET_STS_ERROR;

1072: p_old_CURR_DETAILS_rec.conversion_type OR
1073: p_old_CURR_DETAILS_rec.conversion_type IS NULL )
1074: THEN
1075: IF NOT QP_Validate.Conversion_Type(p_CURR_DETAILS_rec.conversion_type) THEN
1076: x_return_status := FND_API.G_RET_STS_ERROR;
1077: END IF;
1078: END IF;
1079:
1080: IF p_CURR_DETAILS_rec.created_by IS NOT NULL AND

Line 1086: x_return_status := FND_API.G_RET_STS_ERROR;

1082: p_old_CURR_DETAILS_rec.created_by OR
1083: p_old_CURR_DETAILS_rec.created_by IS NULL )
1084: THEN
1085: IF NOT QP_Validate.Created_By(p_CURR_DETAILS_rec.created_by) THEN
1086: x_return_status := FND_API.G_RET_STS_ERROR;
1087: END IF;
1088: END IF;
1089:
1090: IF p_CURR_DETAILS_rec.creation_date IS NOT NULL AND

Line 1096: x_return_status := FND_API.G_RET_STS_ERROR;

1092: p_old_CURR_DETAILS_rec.creation_date OR
1093: p_old_CURR_DETAILS_rec.creation_date IS NULL )
1094: THEN
1095: IF NOT QP_Validate.Creation_Date(p_CURR_DETAILS_rec.creation_date) THEN
1096: x_return_status := FND_API.G_RET_STS_ERROR;
1097: END IF;
1098: END IF;
1099:
1100: IF p_CURR_DETAILS_rec.currency_detail_id IS NOT NULL AND

Line 1106: x_return_status := FND_API.G_RET_STS_ERROR;

1102: p_old_CURR_DETAILS_rec.currency_detail_id OR
1103: p_old_CURR_DETAILS_rec.currency_detail_id IS NULL )
1104: THEN
1105: IF NOT QP_Validate.Currency_Detail(p_CURR_DETAILS_rec.currency_detail_id) THEN
1106: x_return_status := FND_API.G_RET_STS_ERROR;
1107: END IF;
1108: END IF;
1109:
1110: IF p_CURR_DETAILS_rec.currency_header_id IS NOT NULL AND

Line 1116: x_return_status := FND_API.G_RET_STS_ERROR;

1112: p_old_CURR_DETAILS_rec.currency_header_id OR
1113: p_old_CURR_DETAILS_rec.currency_header_id IS NULL )
1114: THEN
1115: IF NOT QP_Validate.Currency_Header(p_CURR_DETAILS_rec.currency_header_id) THEN
1116: x_return_status := FND_API.G_RET_STS_ERROR;
1117: END IF;
1118: END IF;
1119:
1120: IF p_CURR_DETAILS_rec.end_date_active IS NOT NULL AND

Line 1126: x_return_status := FND_API.G_RET_STS_ERROR;

1122: p_old_CURR_DETAILS_rec.end_date_active OR
1123: p_old_CURR_DETAILS_rec.end_date_active IS NULL )
1124: THEN
1125: IF NOT QP_Validate.End_Date_Active(p_CURR_DETAILS_rec.end_date_active) THEN
1126: x_return_status := FND_API.G_RET_STS_ERROR;
1127: END IF;
1128: END IF;
1129:
1130: IF p_CURR_DETAILS_rec.fixed_value IS NOT NULL AND

Line 1136: x_return_status := FND_API.G_RET_STS_ERROR;

1132: p_old_CURR_DETAILS_rec.fixed_value OR
1133: p_old_CURR_DETAILS_rec.fixed_value IS NULL )
1134: THEN
1135: IF NOT QP_Validate.Fixed_Value(p_CURR_DETAILS_rec.fixed_value) THEN
1136: x_return_status := FND_API.G_RET_STS_ERROR;
1137: END IF;
1138: END IF;
1139:
1140: IF p_CURR_DETAILS_rec.last_updated_by IS NOT NULL AND

Line 1146: x_return_status := FND_API.G_RET_STS_ERROR;

1142: p_old_CURR_DETAILS_rec.last_updated_by OR
1143: p_old_CURR_DETAILS_rec.last_updated_by IS NULL )
1144: THEN
1145: IF NOT QP_Validate.Last_Updated_By(p_CURR_DETAILS_rec.last_updated_by) THEN
1146: x_return_status := FND_API.G_RET_STS_ERROR;
1147: END IF;
1148: END IF;
1149:
1150: IF p_CURR_DETAILS_rec.last_update_date IS NOT NULL AND

Line 1156: x_return_status := FND_API.G_RET_STS_ERROR;

1152: p_old_CURR_DETAILS_rec.last_update_date OR
1153: p_old_CURR_DETAILS_rec.last_update_date IS NULL )
1154: THEN
1155: IF NOT QP_Validate.Last_Update_Date(p_CURR_DETAILS_rec.last_update_date) THEN
1156: x_return_status := FND_API.G_RET_STS_ERROR;
1157: END IF;
1158: END IF;
1159:
1160: IF p_CURR_DETAILS_rec.last_update_login IS NOT NULL AND

Line 1166: x_return_status := FND_API.G_RET_STS_ERROR;

1162: p_old_CURR_DETAILS_rec.last_update_login OR
1163: p_old_CURR_DETAILS_rec.last_update_login IS NULL )
1164: THEN
1165: IF NOT QP_Validate.Last_Update_Login(p_CURR_DETAILS_rec.last_update_login) THEN
1166: x_return_status := FND_API.G_RET_STS_ERROR;
1167: END IF;
1168: END IF;
1169:
1170: IF p_CURR_DETAILS_rec.markup_formula_id IS NOT NULL AND

Line 1176: x_return_status := FND_API.G_RET_STS_ERROR;

1172: p_old_CURR_DETAILS_rec.markup_formula_id OR
1173: p_old_CURR_DETAILS_rec.markup_formula_id IS NULL )
1174: THEN
1175: IF NOT QP_Validate.Markup_Formula(p_CURR_DETAILS_rec.markup_formula_id) THEN
1176: x_return_status := FND_API.G_RET_STS_ERROR;
1177: END IF;
1178: END IF;
1179:
1180: IF p_CURR_DETAILS_rec.markup_operator IS NOT NULL AND

Line 1186: x_return_status := FND_API.G_RET_STS_ERROR;

1182: p_old_CURR_DETAILS_rec.markup_operator OR
1183: p_old_CURR_DETAILS_rec.markup_operator IS NULL )
1184: THEN
1185: IF NOT QP_Validate.Markup_Operator(p_CURR_DETAILS_rec.markup_operator) THEN
1186: x_return_status := FND_API.G_RET_STS_ERROR;
1187: END IF;
1188: END IF;
1189:
1190: IF p_CURR_DETAILS_rec.markup_value IS NOT NULL AND

Line 1196: x_return_status := FND_API.G_RET_STS_ERROR;

1192: p_old_CURR_DETAILS_rec.markup_value OR
1193: p_old_CURR_DETAILS_rec.markup_value IS NULL )
1194: THEN
1195: IF NOT QP_Validate.Markup_Value(p_CURR_DETAILS_rec.markup_value) THEN
1196: x_return_status := FND_API.G_RET_STS_ERROR;
1197: END IF;
1198: END IF;
1199:
1200: IF p_CURR_DETAILS_rec.price_formula_id IS NOT NULL AND

Line 1206: x_return_status := FND_API.G_RET_STS_ERROR;

1202: p_old_CURR_DETAILS_rec.price_formula_id OR
1203: p_old_CURR_DETAILS_rec.price_formula_id IS NULL )
1204: THEN
1205: IF NOT QP_Validate.Price_Formula(p_CURR_DETAILS_rec.price_formula_id) THEN
1206: x_return_status := FND_API.G_RET_STS_ERROR;
1207: END IF;
1208: END IF;
1209:
1210: IF p_CURR_DETAILS_rec.program_application_id IS NOT NULL AND

Line 1216: x_return_status := FND_API.G_RET_STS_ERROR;

1212: p_old_CURR_DETAILS_rec.program_application_id OR
1213: p_old_CURR_DETAILS_rec.program_application_id IS NULL )
1214: THEN
1215: IF NOT QP_Validate.Program_Application(p_CURR_DETAILS_rec.program_application_id) THEN
1216: x_return_status := FND_API.G_RET_STS_ERROR;
1217: END IF;
1218: END IF;
1219:
1220: IF p_CURR_DETAILS_rec.program_id IS NOT NULL AND

Line 1226: x_return_status := FND_API.G_RET_STS_ERROR;

1222: p_old_CURR_DETAILS_rec.program_id OR
1223: p_old_CURR_DETAILS_rec.program_id IS NULL )
1224: THEN
1225: IF NOT QP_Validate.Program(p_CURR_DETAILS_rec.program_id) THEN
1226: x_return_status := FND_API.G_RET_STS_ERROR;
1227: END IF;
1228: END IF;
1229:
1230: IF p_CURR_DETAILS_rec.program_update_date IS NOT NULL AND

Line 1236: x_return_status := FND_API.G_RET_STS_ERROR;

1232: p_old_CURR_DETAILS_rec.program_update_date OR
1233: p_old_CURR_DETAILS_rec.program_update_date IS NULL )
1234: THEN
1235: IF NOT QP_Validate.Program_Update_Date(p_CURR_DETAILS_rec.program_update_date) THEN
1236: x_return_status := FND_API.G_RET_STS_ERROR;
1237: END IF;
1238: END IF;
1239:
1240: IF p_CURR_DETAILS_rec.request_id IS NOT NULL AND

Line 1246: x_return_status := FND_API.G_RET_STS_ERROR;

1242: p_old_CURR_DETAILS_rec.request_id OR
1243: p_old_CURR_DETAILS_rec.request_id IS NULL )
1244: THEN
1245: IF NOT QP_Validate.Request(p_CURR_DETAILS_rec.request_id) THEN
1246: x_return_status := FND_API.G_RET_STS_ERROR;
1247: END IF;
1248: END IF;
1249:
1250: IF p_CURR_DETAILS_rec.rounding_factor IS NOT NULL AND

Line 1256: x_return_status := FND_API.G_RET_STS_ERROR;

1252: p_old_CURR_DETAILS_rec.rounding_factor OR
1253: p_old_CURR_DETAILS_rec.rounding_factor IS NULL )
1254: THEN
1255: IF NOT QP_Validate.Rounding_Factor(p_CURR_DETAILS_rec.rounding_factor) THEN
1256: x_return_status := FND_API.G_RET_STS_ERROR;
1257: END IF;
1258: END IF;
1259:
1260: IF p_CURR_DETAILS_rec.selling_rounding_factor IS NOT NULL AND

Line 1266: x_return_status := FND_API.G_RET_STS_ERROR;

1262: p_old_CURR_DETAILS_rec.selling_rounding_factor OR
1263: p_old_CURR_DETAILS_rec.selling_rounding_factor IS NULL )
1264: THEN
1265: IF NOT QP_Validate.Rounding_Factor(p_CURR_DETAILS_rec.selling_rounding_factor) THEN
1266: x_return_status := FND_API.G_RET_STS_ERROR;
1267: END IF;
1268: END IF;
1269:
1270: IF p_CURR_DETAILS_rec.start_date_active IS NOT NULL AND

Line 1276: x_return_status := FND_API.G_RET_STS_ERROR;

1272: p_old_CURR_DETAILS_rec.start_date_active OR
1273: p_old_CURR_DETAILS_rec.start_date_active IS NULL )
1274: THEN
1275: IF NOT QP_Validate.Start_Date_Active(p_CURR_DETAILS_rec.start_date_active) THEN
1276: x_return_status := FND_API.G_RET_STS_ERROR;
1277: END IF;
1278: END IF;
1279:
1280: IF p_CURR_DETAILS_rec.to_currency_code IS NOT NULL AND

Line 1286: x_return_status := FND_API.G_RET_STS_ERROR;

1282: p_old_CURR_DETAILS_rec.to_currency_code OR
1283: p_old_CURR_DETAILS_rec.to_currency_code IS NULL )
1284: THEN
1285: IF NOT QP_Validate.To_Currency(p_CURR_DETAILS_rec.to_currency_code) THEN
1286: x_return_status := FND_API.G_RET_STS_ERROR;
1287: END IF;
1288: END IF;
1289:
1290: IF p_CURR_DETAILS_rec.curr_attribute_type IS NOT NULL AND

Line 1296: x_return_status := FND_API.G_RET_STS_ERROR;

1292: p_old_CURR_DETAILS_rec.curr_attribute_type OR
1293: p_old_CURR_DETAILS_rec.curr_attribute_type IS NULL )
1294: THEN
1295: IF NOT QP_Validate.Curr_Attribute_Type(p_CURR_DETAILS_rec.curr_attribute_type) THEN
1296: x_return_status := FND_API.G_RET_STS_ERROR;
1297: END IF;
1298: END IF;
1299:
1300: IF p_CURR_DETAILS_rec.curr_attribute_context IS NOT NULL AND

Line 1306: x_return_status := FND_API.G_RET_STS_ERROR;

1302: p_old_CURR_DETAILS_rec.curr_attribute_context OR
1303: p_old_CURR_DETAILS_rec.curr_attribute_context IS NULL )
1304: THEN
1305: IF NOT QP_Validate.Curr_Attribute_Context(p_CURR_DETAILS_rec.curr_attribute_context) THEN
1306: x_return_status := FND_API.G_RET_STS_ERROR;
1307: END IF;
1308: END IF;
1309:
1310: IF p_CURR_DETAILS_rec.curr_attribute IS NOT NULL AND

Line 1316: x_return_status := FND_API.G_RET_STS_ERROR;

1312: p_old_CURR_DETAILS_rec.curr_attribute OR
1313: p_old_CURR_DETAILS_rec.curr_attribute IS NULL )
1314: THEN
1315: IF NOT QP_Validate.Curr_Attribute(p_CURR_DETAILS_rec.curr_attribute) THEN
1316: x_return_status := FND_API.G_RET_STS_ERROR;
1317: END IF;
1318: END IF;
1319:
1320: IF p_CURR_DETAILS_rec.curr_attribute_value IS NOT NULL AND

Line 1326: x_return_status := FND_API.G_RET_STS_ERROR;

1322: p_old_CURR_DETAILS_rec.curr_attribute_value OR
1323: p_old_CURR_DETAILS_rec.curr_attribute_value IS NULL )
1324: THEN
1325: IF NOT QP_Validate.Curr_Attribute_Value(p_CURR_DETAILS_rec.curr_attribute_value) THEN
1326: x_return_status := FND_API.G_RET_STS_ERROR;
1327: END IF;
1328: END IF;
1329:
1330: IF p_CURR_DETAILS_rec.precedence IS NOT NULL AND

Line 1336: x_return_status := FND_API.G_RET_STS_ERROR;

1332: p_old_CURR_DETAILS_rec.precedence OR
1333: p_old_CURR_DETAILS_rec.precedence IS NULL )
1334: THEN
1335: IF NOT QP_Validate.Precedence(p_CURR_DETAILS_rec.precedence) THEN
1336: x_return_status := FND_API.G_RET_STS_ERROR;
1337: END IF;
1338: END IF;
1339:
1340: IF (p_CURR_DETAILS_rec.attribute1 IS NOT NULL AND

Line 1478: x_return_status := FND_API.G_RET_STS_ERROR;

1474:
1475: -- Validate descriptive flexfield.
1476:
1477: IF NOT QP_Validate.Desc_Flex( 'CURR_DETAILS' ) THEN
1478: x_return_status := FND_API.G_RET_STS_ERROR;
1479: END IF;
1480:
1481: END IF;
1482:

Line 1487: WHEN FND_API.G_EXC_ERROR THEN

1483: -- Done validating attributes
1484:
1485: EXCEPTION
1486:
1487: WHEN FND_API.G_EXC_ERROR THEN
1488:
1489: x_return_status := FND_API.G_RET_STS_ERROR;
1490:
1491: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1489: x_return_status := FND_API.G_RET_STS_ERROR;

1485: EXCEPTION
1486:
1487: WHEN FND_API.G_EXC_ERROR THEN
1488:
1489: x_return_status := FND_API.G_RET_STS_ERROR;
1490:
1491: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1492:
1493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1491: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1487: WHEN FND_API.G_EXC_ERROR THEN
1488:
1489: x_return_status := FND_API.G_RET_STS_ERROR;
1490:
1491: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1492:
1493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1494:
1495: WHEN OTHERS THEN

Line 1493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1489: x_return_status := FND_API.G_RET_STS_ERROR;
1490:
1491: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1492:
1493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1494:
1495: WHEN OTHERS THEN
1496:
1497: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1497: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1494:
1495: WHEN OTHERS THEN
1496:
1497: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1498:
1499: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1500: THEN
1501: OE_MSG_PUB.Add_Exc_Msg

Line 1516: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

1512: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1513: , p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
1514: )
1515: IS
1516: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1517: BEGIN
1518:
1519: -- Validate entity delete.
1520:

Line 1529: WHEN FND_API.G_EXC_ERROR THEN

1525: x_return_status := l_return_status;
1526:
1527: EXCEPTION
1528:
1529: WHEN FND_API.G_EXC_ERROR THEN
1530:
1531: x_return_status := FND_API.G_RET_STS_ERROR;
1532:
1533: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1531: x_return_status := FND_API.G_RET_STS_ERROR;

1527: EXCEPTION
1528:
1529: WHEN FND_API.G_EXC_ERROR THEN
1530:
1531: x_return_status := FND_API.G_RET_STS_ERROR;
1532:
1533: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1534:
1535: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1533: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1529: WHEN FND_API.G_EXC_ERROR THEN
1530:
1531: x_return_status := FND_API.G_RET_STS_ERROR;
1532:
1533: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1534:
1535: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1536:
1537: WHEN OTHERS THEN

Line 1535: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1531: x_return_status := FND_API.G_RET_STS_ERROR;
1532:
1533: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1534:
1535: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1536:
1537: WHEN OTHERS THEN
1538:
1539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1535: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1536:
1537: WHEN OTHERS THEN
1538:
1539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1540:
1541: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1542: THEN
1543: OE_MSG_PUB.Add_Exc_Msg