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.INV_CUSTOMER_ITEM_GRP dependencies on FND_MESSAGE

Line 249: FND_MESSAGE.Set_Name('INV',

245:
246: IF ((X_Error_Code = 'APP-00000') AND
247: (Attribute_Variable IS NULL)) THEN
248:
249: FND_MESSAGE.Set_Name('INV',
250: 'INV_NULL_ATTRIBUTE_VALUE');
251: Error_Code := 'APP-43041';
252: Error_Flag := 'W';
253: Error_Message := FND_MESSAGE.Get;

Line 253: Error_Message := FND_MESSAGE.Get;

249: FND_MESSAGE.Set_Name('INV',
250: 'INV_NULL_ATTRIBUTE_VALUE');
251: Error_Code := 'APP-43041';
252: Error_Flag := 'W';
253: Error_Message := FND_MESSAGE.Get;
254: RETURN;
255: ELSE
256: Attribute_Value := Attribute_Variable;
257:

Line 261: FND_MESSAGE.Set_Name('INV', 'INV_INVALID_COLUMN_NAME');

257:
258: END IF;
259:
260: ELSE
261: FND_MESSAGE.Set_Name('INV', 'INV_INVALID_COLUMN_NAME');
262: Error_Code := 'APP-43043';
263: Error_Flag := 'Y';
264: Error_Message := FND_MESSAGE.Get;
265: RETURN;

Line 264: Error_Message := FND_MESSAGE.Get;

260: ELSE
261: FND_MESSAGE.Set_Name('INV', 'INV_INVALID_COLUMN_NAME');
262: Error_Code := 'APP-43043';
263: Error_Flag := 'Y';
264: Error_Message := FND_MESSAGE.Get;
265: RETURN;
266: END IF;
267:
268: ELSE

Line 270: FND_MESSAGE.Set_Name('INV', 'INV_MISSING_REQUIRED_PARAMETER');

266: END IF;
267:
268: ELSE
269:
270: FND_MESSAGE.Set_Name('INV', 'INV_MISSING_REQUIRED_PARAMETER');
271: Error_Code := 'APP-43042';
272: Error_Flag := 'Y';
273: Error_Message := FND_MESSAGE.Get;
274: RETURN;

Line 273: Error_Message := FND_MESSAGE.Get;

269:
270: FND_MESSAGE.Set_Name('INV', 'INV_MISSING_REQUIRED_PARAMETER');
271: Error_Code := 'APP-43042';
272: Error_Flag := 'Y';
273: Error_Message := FND_MESSAGE.Get;
274: RETURN;
275: END IF;
276:
277: EXCEPTION

Line 281: FND_MESSAGE.Set_Name('INV', 'INV_MISSING_REQUIRED_PARAMETER');

277: EXCEPTION
278:
279: WHEN NO_DATA_FOUND THEN
280:
281: FND_MESSAGE.Set_Name('INV', 'INV_MISSING_REQUIRED_PARAMETER');
282: Error_Code := 'APP-43042';
283: Error_Flag := 'Y';
284: Error_Message := FND_MESSAGE.Get;
285: RETURN;

Line 284: Error_Message := FND_MESSAGE.Get;

280:
281: FND_MESSAGE.Set_Name('INV', 'INV_MISSING_REQUIRED_PARAMETER');
282: Error_Code := 'APP-43042';
283: Error_Flag := 'Y';
284: Error_Message := FND_MESSAGE.Get;
285: RETURN;
286:
287: WHEN OTHERS THEN
288:

Line 470: FND_MESSAGE.Set_Name('INV', 'INV_MISSING_REQUIRED_PARAMETER');

466: IF ( (Y_Customer_Id IS NULL)
467: OR (Y_Organization_Id IS NULL)
468: OR ( (Y_Customer_Item_Id IS NULL) AND
469: (Y_Customer_Item_Number IS NULL) ) ) THEN
470: FND_MESSAGE.Set_Name('INV', 'INV_MISSING_REQUIRED_PARAMETER');
471: X_Error_Flag := 'Y';
472: X_Error_Code := 'APP-43042';
473: X_Error_Message := FND_MESSAGE.Get;
474: RETURN;

Line 473: X_Error_Message := FND_MESSAGE.Get;

469: (Y_Customer_Item_Number IS NULL) ) ) THEN
470: FND_MESSAGE.Set_Name('INV', 'INV_MISSING_REQUIRED_PARAMETER');
471: X_Error_Flag := 'Y';
472: X_Error_Code := 'APP-43042';
473: X_Error_Message := FND_MESSAGE.Get;
474: RETURN;
475: END IF;
476:
477: --rdevakum, fix for bug 466738. variables for item definition level.

Line 491: FND_MESSAGE.Set_Name('INV', 'INV_INVALID_CUST_ADDRESS');

487: OPEN RA_Addresses_Cur (Y_Address_Id);
488: FETCH RA_Addresses_Cur
489: INTO l_Customer_Id;
490: IF ( RA_Addresses_Cur%NOTFOUND ) THEN
491: FND_MESSAGE.Set_Name('INV', 'INV_INVALID_CUST_ADDRESS');
492: X_Error_Flag := 'Y';
493: X_Error_Code := 'APP-43099';
494: X_Error_Message := FND_MESSAGE.Get;
495: CLOSE RA_Addresses_Cur;

Line 494: X_Error_Message := FND_MESSAGE.Get;

490: IF ( RA_Addresses_Cur%NOTFOUND ) THEN
491: FND_MESSAGE.Set_Name('INV', 'INV_INVALID_CUST_ADDRESS');
492: X_Error_Flag := 'Y';
493: X_Error_Code := 'APP-43099';
494: X_Error_Message := FND_MESSAGE.Get;
495: CLOSE RA_Addresses_Cur;
496: RETURN;
497: END IF;
498: CLOSE RA_Addresses_Cur;

Line 512: FND_MESSAGE.Set_Name('INV', 'INV_NO_CUSTOMER_ITEM');

508: Temp_Item_Definition_Level;
509:
510: IF ((CI_Cur%NOTFOUND) AND (CI_Cur%ROWCOUNT = 0)) THEN
511:
512: FND_MESSAGE.Set_Name('INV', 'INV_NO_CUSTOMER_ITEM');
513: X_Error_Code := 'APP-43037';
514: X_Error_Flag := 'Y';
515: X_Error_Message := FND_MESSAGE.Get;
516: RETURN;

Line 515: X_Error_Message := FND_MESSAGE.Get;

511:
512: FND_MESSAGE.Set_Name('INV', 'INV_NO_CUSTOMER_ITEM');
513: X_Error_Code := 'APP-43037';
514: X_Error_Flag := 'Y';
515: X_Error_Message := FND_MESSAGE.Get;
516: RETURN;
517: END if;
518:
519: IF Y_Line_Category_Code = 'ORDER' THEN -- bug 13718740

Line 576: FND_MESSAGE.Set_Name('INV',

572: ELSE
573: IF ((Temp_Inactive_Flag = 'Y') AND
574: (CI_Cur%NOTFOUND) AND (CI_Cur%ROWCOUNT > 0)) THEN
575:
576: FND_MESSAGE.Set_Name('INV',
577: 'INV_INACTIVE_CUSTOMER_ITEM');
578: X_Error_Code := 'APP-43039';
579: X_Error_Flag := 'Y';
580: X_Error_Message := FND_MESSAGE.Get;

Line 580: X_Error_Message := FND_MESSAGE.Get;

576: FND_MESSAGE.Set_Name('INV',
577: 'INV_INACTIVE_CUSTOMER_ITEM');
578: X_Error_Code := 'APP-43039';
579: X_Error_Flag := 'Y';
580: X_Error_Message := FND_MESSAGE.Get;
581: Temp_Inactive_Flag := NULL;
582: RETURN;
583: ELSIF ((Temp_Item_Definition_Level = '3') AND
584: (Temp_Address_Id <> Y_Address_Id) AND

Line 587: FND_MESSAGE.Set_Name('INV',

583: ELSIF ((Temp_Item_Definition_Level = '3') AND
584: (Temp_Address_Id <> Y_Address_Id) AND
585: (CI_Cur%NOTFOUND) AND (CI_Cur%ROWCOUNT > 0)) THEN
586:
587: FND_MESSAGE.Set_Name('INV',
588: 'INV_INVALID_CUST_ADDRESS');
589: X_Error_Code := 'APP-43099';
590: X_Error_Flag := 'Y';
591: X_Error_Message := FND_MESSAGE.Get;

Line 591: X_Error_Message := FND_MESSAGE.Get;

587: FND_MESSAGE.Set_Name('INV',
588: 'INV_INVALID_CUST_ADDRESS');
589: X_Error_Code := 'APP-43099';
590: X_Error_Flag := 'Y';
591: X_Error_Message := FND_MESSAGE.Get;
592: Temp_Inactive_Flag := NULL;
593: RETURN;
594:
595: END IF;

Line 658: FND_MESSAGE.Set_Name('INV',

654: ELSE
655: IF ((Temp_Inactive_Flag = 'Y') AND
656: (CI_Cur%NOTFOUND) AND (CI_Cur%ROWCOUNT > 0)) THEN
657:
658: FND_MESSAGE.Set_Name('INV',
659: 'INV_INACTIVE_CUSTOMER_ITEM');
660: X_Error_Code := 'APP-43039';
661: X_Error_Flag := 'Y';
662: X_Error_Message := FND_MESSAGE.Get;

Line 662: X_Error_Message := FND_MESSAGE.Get;

658: FND_MESSAGE.Set_Name('INV',
659: 'INV_INACTIVE_CUSTOMER_ITEM');
660: X_Error_Code := 'APP-43039';
661: X_Error_Flag := 'Y';
662: X_Error_Message := FND_MESSAGE.Get;
663: Temp_Inactive_Flag := NULL;
664: RETURN;
665: ELSIF ((Temp_Item_Definition_Level = '3') AND
666: (Temp_Address_Id <> Y_Address_Id) AND

Line 669: FND_MESSAGE.Set_Name('INV',

665: ELSIF ((Temp_Item_Definition_Level = '3') AND
666: (Temp_Address_Id <> Y_Address_Id) AND
667: (CI_Cur%NOTFOUND) AND (CI_Cur%ROWCOUNT > 0)) THEN
668:
669: FND_MESSAGE.Set_Name('INV',
670: 'INV_INVALID_CUST_ADDRESS');
671: X_Error_Code := 'APP-43099';
672: X_Error_Flag := 'Y';
673: X_Error_Message := FND_MESSAGE.Get;

Line 673: X_Error_Message := FND_MESSAGE.Get;

669: FND_MESSAGE.Set_Name('INV',
670: 'INV_INVALID_CUST_ADDRESS');
671: X_Error_Code := 'APP-43099';
672: X_Error_Flag := 'Y';
673: X_Error_Message := FND_MESSAGE.Get;
674: Temp_Inactive_Flag := NULL;
675: RETURN;
676:
677: END IF;

Line 701: FND_MESSAGE.Set_Name('INV',

697: Temp_Inactive_Flag;
698:
699: IF (CI_XREF_Cur%NOTFOUND) THEN
700:
701: FND_MESSAGE.Set_Name('INV',
702: 'INV_NO_CUSTOMER_ITEM_XREF');
703: X_Error_Code := 'APP-43038';
704: X_Error_Flag := 'Y';
705: X_Error_Message := FND_MESSAGE.Get;

Line 705: X_Error_Message := FND_MESSAGE.Get;

701: FND_MESSAGE.Set_Name('INV',
702: 'INV_NO_CUSTOMER_ITEM_XREF');
703: X_Error_Code := 'APP-43038';
704: X_Error_Flag := 'Y';
705: X_Error_Message := FND_MESSAGE.Get;
706: RETURN;
707: --Bug: 5157639 Commented out this code to remove validation based on Incative flag
708: ELSIF (Y_Line_Category_Code = 'ORDER' AND Temp_Inactive_Flag = 'Y') THEN -- bug 13718740
709:

Line 719: FND_MESSAGE.Set_Name('INV',

715: Temp_Inactive_Flag;
716:
717: IF (CI_XREF_Cur%NOTFOUND) THEN
718:
719: FND_MESSAGE.Set_Name('INV',
720: 'INV_INACTIVE_CI_XREF');
721: X_Error_Code := 'APP-43040';
722: X_Error_Flag := 'Y';
723: X_Error_Message :=

Line 724: FND_MESSAGE.Get;

720: 'INV_INACTIVE_CI_XREF');
721: X_Error_Code := 'APP-43040';
722: X_Error_Flag := 'Y';
723: X_Error_Message :=
724: FND_MESSAGE.Get;
725: Temp_Inactive_Flag := NULL;
726: RETURN;
727:
728: ELSIF (Temp_Inactive_Flag = 'N') THEN