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

Line 206: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SOURCE_ID_NOT_EXISTS');

202: IF for_party_name%FOUND
203: THEN
204: l_document_tbl(i).source_party_id := l_source_party_id;
205: ELSE
206: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SOURCE_ID_NOT_EXISTS');
207: FND_MSG_PUB.ADD;
208: END IF;
209: CLOSE for_party_name;
210: ELSE

Line 212: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SOURCE_PARTY_ID_NULL');

208: END IF;
209: CLOSE for_party_name;
210: ELSE
211: --Both Party Id and Name are missing
212: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SOURCE_PARTY_ID_NULL');
213: FND_MSG_PUB.ADD;
214: END IF;
215: --Check for If ID present
216: ELSIF (p_x_document_tbl(i).source_party_id IS NOT NULL AND

Line 225: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SOURCE_ID_INVALID');

221: IF for_party_id%FOUND
222: THEN
223: l_document_tbl(i).source_party_id := p_x_document_tbl(i).source_party_id;
224: ELSE
225: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SOURCE_ID_INVALID');
226: FND_MSG_PUB.ADD;
227: END IF;
228: CLOSE for_party_id;
229: END IF;

Line 253: FND_MESSAGE.SET_NAME('AHL','AHL_DI_OPERATOR_CODE_NOT_EXIST');

249:
250:
251: IF get_operator_name_hz%ROWCOUNT = 0
252: THEN
253: FND_MESSAGE.SET_NAME('AHL','AHL_DI_OPERATOR_CODE_NOT_EXIST');
254: FND_MSG_PUB.ADD;
255: ELSIF get_operator_name_hz%ROWCOUNT > 1
256: THEN
257: FND_MESSAGE.SET_NAME('AHL','AHL_DI_OPERATOR_USE_LOV');

Line 257: FND_MESSAGE.SET_NAME('AHL','AHL_DI_OPERATOR_USE_LOV');

253: FND_MESSAGE.SET_NAME('AHL','AHL_DI_OPERATOR_CODE_NOT_EXIST');
254: FND_MSG_PUB.ADD;
255: ELSIF get_operator_name_hz%ROWCOUNT > 1
256: THEN
257: FND_MESSAGE.SET_NAME('AHL','AHL_DI_OPERATOR_USE_LOV');
258: FND_MSG_PUB.ADD;
259: END IF;
260: CLOSE get_operator_name_hz;
261: END IF;

Line 280: FND_MESSAGE.SET_NAME('AHL','AHL_DI_PRODTYPE_CODE_NOT_EXIST');

276: x_return_status => l_return_status);
277:
278: IF nvl(l_return_status, 'X') <> 'S'
279: THEN
280: FND_MESSAGE.SET_NAME('AHL','AHL_DI_PRODTYPE_CODE_NOT_EXIST');
281: FND_MSG_PUB.ADD;
282: END IF;
283:
284: --ID presntes

Line 308: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_TYPE_CODE_NOT_EXIST');

304: x_return_status => l_return_status);
305:
306: IF nvl(l_return_status, 'X') <> 'S'
307: THEN
308: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_TYPE_CODE_NOT_EXIST');
309: FND_MSG_PUB.ADD;
310: END IF;
311: END IF;
312: -- Id presents

Line 318: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_TYPE_CODE_NOT_EXIST');

314: p_x_document_tbl(i).doc_type_code <> FND_API.G_MISS_CHAR
315: THEN
316: l_document_tbl(i).doc_type_code := p_x_document_tbl(i).doc_type_code;
317: ELSE
318: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_TYPE_CODE_NOT_EXIST');
319: FND_MSG_PUB.ADD;
320: END IF;
321:
322: --For Doc Sub Type Code, meaning presents

Line 337: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_SUBT_COD_NOT_EXISTS');

333: x_return_status => l_return_status);
334:
335: IF nvl(l_return_status, 'X') <> 'S'
336: THEN
337: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_SUBT_COD_NOT_EXISTS');
338: FND_MSG_PUB.ADD;
339: END IF;
340: END IF;
341: --Id presents

Line 419: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SUPPL_ID_NOT_EXIST');

415: IF for_party_name%FOUND
416: THEN
417: l_supplier_tbl(i).supplier_id := l_supplier_id;
418: ELSE
419: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SUPPL_ID_NOT_EXIST');
420: FND_MESSAGE.SET_TOKEN('SUPNAME',p_x_supplier_tbl(i).supplier_number);
421: FND_MSG_PUB.ADD;
422: END IF;
423: CLOSE for_party_name;

Line 420: FND_MESSAGE.SET_TOKEN('SUPNAME',p_x_supplier_tbl(i).supplier_number);

416: THEN
417: l_supplier_tbl(i).supplier_id := l_supplier_id;
418: ELSE
419: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SUPPL_ID_NOT_EXIST');
420: FND_MESSAGE.SET_TOKEN('SUPNAME',p_x_supplier_tbl(i).supplier_number);
421: FND_MSG_PUB.ADD;
422: END IF;
423: CLOSE for_party_name;
424: ELSIF ahl_di_doc_index_pvt.get_product_install_status('PO') IN ('I','S')

Line 432: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SUPPL_ID_NOT_EXIST');

428: IF for_vendor_id%FOUND
429: THEN
430: l_supplier_tbl(i).supplier_id := l_supplier_id;
431: ELSE
432: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SUPPL_ID_NOT_EXIST');
433: FND_MESSAGE.SET_TOKEN('SUPNAME',p_x_supplier_tbl(i).supplier_number);
434: FND_MSG_PUB.ADD;
435: END IF;
436: CLOSE for_vendor_id;

Line 433: FND_MESSAGE.SET_TOKEN('SUPNAME',p_x_supplier_tbl(i).supplier_number);

429: THEN
430: l_supplier_tbl(i).supplier_id := l_supplier_id;
431: ELSE
432: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SUPPL_ID_NOT_EXIST');
433: FND_MESSAGE.SET_TOKEN('SUPNAME',p_x_supplier_tbl(i).supplier_number);
434: FND_MSG_PUB.ADD;
435: END IF;
436: CLOSE for_vendor_id;
437: END IF;

Line 445: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SUPPL_ID_NOT_EXIST');

441: THEN
442: l_supplier_tbl(i).supplier_id := p_x_supplier_tbl(i).supplier_id;
443: ELSE
444: --Both Supplier Id and Name are missing
445: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SUPPL_ID_NOT_EXIST');
446: FND_MESSAGE.SET_TOKEN('SUPNAME',p_x_supplier_tbl(i).supplier_number);
447: FND_MSG_PUB.ADD;
448: END IF;
449: END IF;

Line 446: FND_MESSAGE.SET_TOKEN('SUPNAME',p_x_supplier_tbl(i).supplier_number);

442: l_supplier_tbl(i).supplier_id := p_x_supplier_tbl(i).supplier_id;
443: ELSE
444: --Both Supplier Id and Name are missing
445: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SUPPL_ID_NOT_EXIST');
446: FND_MESSAGE.SET_TOKEN('SUPNAME',p_x_supplier_tbl(i).supplier_number);
447: FND_MSG_PUB.ADD;
448: END IF;
449: END IF;
450: -- For Preference Code, meaning presents

Line 465: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SUPPLIER_PREF_TYPE');

461: x_return_status => l_return_status);
462:
463: IF nvl(l_return_status, 'X') <> 'S'
464: THEN
465: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SUPPLIER_PREF_TYPE');
466: FND_MSG_PUB.ADD;
467: END IF;
468: END IF;
469: -- Pref Code presents

Line 544: FND_MESSAGE.SET_NAME('AHL','AHL_DI_RECIPIENT_ID_NOT_EXIST');

540: IF for_party_name%FOUND
541: THEN
542: l_recipient_tbl(i).recipient_party_id := l_recipient_id;
543: ELSE
544: FND_MESSAGE.SET_NAME('AHL','AHL_DI_RECIPIENT_ID_NOT_EXIST');
545: FND_MESSAGE.SET_TOKEN('RECPNAME',p_x_recipient_tbl(i).recipient_party_number);
546: FND_MSG_PUB.ADD;
547: END IF;
548: CLOSE for_party_name;

Line 545: FND_MESSAGE.SET_TOKEN('RECPNAME',p_x_recipient_tbl(i).recipient_party_number);

541: THEN
542: l_recipient_tbl(i).recipient_party_id := l_recipient_id;
543: ELSE
544: FND_MESSAGE.SET_NAME('AHL','AHL_DI_RECIPIENT_ID_NOT_EXIST');
545: FND_MESSAGE.SET_TOKEN('RECPNAME',p_x_recipient_tbl(i).recipient_party_number);
546: FND_MSG_PUB.ADD;
547: END IF;
548: CLOSE for_party_name;
549: --ID presents

Line 556: FND_MESSAGE.SET_NAME('AHL','AHL_DI_RECIPIENT_ID_NOT_EXIST');

552: THEN
553: l_recipient_tbl(i).recipient_party_id := p_x_recipient_tbl(i).recipient_party_id;
554: ELSE
555: --Both Recipient Id and Name are missing
556: FND_MESSAGE.SET_NAME('AHL','AHL_DI_RECIPIENT_ID_NOT_EXIST');
557: FND_MESSAGE.SET_TOKEN('RECPNAME',p_x_recipient_tbl(i).recipient_party_number);
558: FND_MSG_PUB.ADD;
559: END IF;
560: END IF;

Line 557: FND_MESSAGE.SET_TOKEN('RECPNAME',p_x_recipient_tbl(i).recipient_party_number);

553: l_recipient_tbl(i).recipient_party_id := p_x_recipient_tbl(i).recipient_party_id;
554: ELSE
555: --Both Recipient Id and Name are missing
556: FND_MESSAGE.SET_NAME('AHL','AHL_DI_RECIPIENT_ID_NOT_EXIST');
557: FND_MESSAGE.SET_TOKEN('RECPNAME',p_x_recipient_tbl(i).recipient_party_number);
558: FND_MSG_PUB.ADD;
559: END IF;
560: END IF;
561: l_recipient_tbl(i).recipient_document_id := p_x_recipient_tbl(i).recipient_document_id;

Line 626: FND_MESSAGE.SET_NAME('AHL','AHL_DI_REQ_PTY_ID_NOT_EXISTS');

622: IF for_party_name%FOUND
623: THEN
624: l_subscription_tbl(i).requested_by_party_id := l_requested_by_party_id;
625: ELSE
626: FND_MESSAGE.SET_NAME('AHL','AHL_DI_REQ_PTY_ID_NOT_EXISTS');
627: FND_MSG_PUB.ADD;
628: END IF;
629: CLOSE for_party_name;
630:

Line 641: FND_MESSAGE.SET_NAME('AHL','AHL_DI_REQ_PTY_ID_NOT_EXISTS');

637: IF for_party_id%FOUND
638: THEN
639: l_subscription_tbl(i).requested_by_party_id := l_requested_by_party_id;
640: ELSE
641: FND_MESSAGE.SET_NAME('AHL','AHL_DI_REQ_PTY_ID_NOT_EXISTS');
642: FND_MSG_PUB.ADD;
643: END IF;
644: CLOSE for_party_id;
645: ELSE

Line 647: FND_MESSAGE.SET_NAME('AHL','AHL_DI_REQ_PTY_ID_NULL');

643: END IF;
644: CLOSE for_party_id;
645: ELSE
646: --Both Party Id and Name are missing
647: FND_MESSAGE.SET_NAME('AHL','AHL_DI_REQ_PTY_ID_NULL');
648: FND_MSG_PUB.ADD;
649: END IF;
650: --For Subscribed from party id
651: -- If subscribed from Party Name is available

Line 696: FND_MESSAGE.SET_NAME('AHL','AHL_DI_MEDTYP_CODE_NOT_EXISTS');

692: x_return_status => l_return_status);
693:
694: IF nvl(l_return_status, 'X') <> 'S'
695: THEN
696: FND_MESSAGE.SET_NAME('AHL','AHL_DI_MEDTYP_CODE_NOT_EXISTS');
697: FND_MSG_PUB.ADD;
698: END IF;
699: END IF;
700: -- If id is present

Line 724: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SUBTYP_CODE_NOT_EXISTS');

720: x_return_status => l_return_status);
721:
722: IF nvl(l_return_status, 'X') <> 'S'
723: THEN
724: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SUBTYP_CODE_NOT_EXISTS');
725: FND_MSG_PUB.ADD;
726: END IF;
727: END IF;
728: -- Code Presents

Line 752: FND_MESSAGE.SET_NAME('AHL','AHL_DI_FREQCY_CODE_NOT_EXISTS');

748: x_return_status => l_return_status);
749:
750: IF nvl(l_return_status, 'X') <> 'S'
751: THEN
752: FND_MESSAGE.SET_NAME('AHL','AHL_DI_FREQCY_CODE_NOT_EXISTS');
753: FND_MSG_PUB.ADD;
754: END IF;
755: END IF;
756: -- Frequency Code present

Line 781: FND_MESSAGE.SET_NAME('AHL','AHL_DI_STATUS_CODE_NOT_EXISTS');

777: x_return_status => l_return_status);
778:
779: IF nvl(l_return_status, 'X') <> 'S'
780: THEN
781: FND_MESSAGE.SET_NAME('AHL','AHL_DI_STATUS_CODE_NOT_EXISTS');
782: FND_MSG_PUB.ADD;
783: END IF;
784: END IF;
785: -- If Status Code is Avialable

Line 792: FND_MESSAGE.SET_NAME('AHL','AHL_DI_STATUS_CODE_NULL');

788: THEN
789: l_subscription_tbl(i).status_code := p_x_subscription_tbl(i).status_code;
790: -- If both are missing
791: ELSE
792: FND_MESSAGE.SET_NAME('AHL','AHL_DI_STATUS_CODE_NULL');
793: FND_MSG_PUB.ADD;
794: END IF;
795:
796: l_subscription_tbl(i).document_id := p_x_subscription_tbl(i).document_id;

Line 858: FND_MESSAGE.SET_NAME('AHL','AHL_DI_APP_BY_PTY_ID_NOT_EXIST');

854: IF for_party_name%FOUND
855: THEN
856: l_revision_tbl(i).approved_by_party_id := l_approved_by_party_id;
857: ELSE
858: FND_MESSAGE.SET_NAME('AHL','AHL_DI_APP_BY_PTY_ID_NOT_EXIST');
859: FND_MSG_PUB.ADD;
860: END IF;
861: CLOSE for_party_name;
862: --If Party Id is present

Line 872: FND_MESSAGE.SET_NAME('AHL','AHL_DI_APP_BY_PTY_ID_NOT_EXIST');

868: IF for_party_id%FOUND
869: THEN
870: l_revision_tbl(i).approved_by_party_id := l_approved_by_party_id;
871: ELSE
872: FND_MESSAGE.SET_NAME('AHL','AHL_DI_APP_BY_PTY_ID_NOT_EXIST');
873: FND_MSG_PUB.ADD;
874: END IF;
875: CLOSE for_party_id;
876: ELSE

Line 896: FND_MESSAGE.SET_NAME('AHL','AHL_DI_REV_TYPE_CODE_NOT_EXIST');

892: x_return_status => l_return_status);
893:
894: IF nvl(l_return_status, 'X') <> 'S'
895: THEN
896: FND_MESSAGE.SET_NAME('AHL','AHL_DI_REV_TYPE_CODE_NOT_EXIST');
897: FND_MSG_PUB.ADD;
898: END IF;
899: END IF;
900: -- If Code is present

Line 924: FND_MESSAGE.SET_NAME('AHL','AHL_DI_MEDTYP_CODE_NOT_EXISTS');

920: x_return_status => l_return_status);
921:
922: IF nvl(l_return_status, 'X') <> 'S'
923: THEN
924: FND_MESSAGE.SET_NAME('AHL','AHL_DI_MEDTYP_CODE_NOT_EXISTS');
925: FND_MSG_PUB.ADD;
926: END IF;
927: END IF;
928: -- If ID presnt

Line 952: FND_MESSAGE.SET_NAME('AHL','AHL_DI_REV_STAT_CODE_NOT_EXIST');

948: x_return_status => l_return_status);
949:
950: IF nvl(l_return_status, 'X') <> 'S'
951: THEN
952: FND_MESSAGE.SET_NAME('AHL','AHL_DI_REV_STAT_CODE_NOT_EXIST');
953: FND_MSG_PUB.ADD;
954: END IF;
955: END IF;
956: -- If Revision status code presents

Line 1497: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SOURCE_ID_NOT_EXISTS');

1493: IF for_party_name%FOUND
1494: THEN
1495: l_document_tbl(i).source_party_id := l_source_party_id;
1496: ELSE
1497: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SOURCE_ID_NOT_EXISTS');
1498: FND_MSG_PUB.ADD;
1499: END IF;
1500: CLOSE for_party_name;
1501: ELSE

Line 1503: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SOURCE_PARTY_ID_NULL');

1499: END IF;
1500: CLOSE for_party_name;
1501: ELSE
1502: --Both Party Id and Name are missing
1503: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SOURCE_PARTY_ID_NULL');
1504: FND_MSG_PUB.ADD;
1505: END IF;
1506:
1507: --Check for If ID present

Line 1522: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SOURCE_PARTY_ID_NULL');

1518: END IF;
1519: CLOSE for_party_id;
1520: ELSE
1521: --Both Party Id and Name are missing
1522: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SOURCE_PARTY_ID_NULL');
1523: FND_MSG_PUB.ADD;
1524: END IF;
1525: --For Operator Code, Meaning presnts
1526: IF p_x_document_tbl(i).operator_name IS NOT NULL AND

Line 1547: FND_MESSAGE.SET_NAME('AHL','AHL_DI_OPERATOR_CODE_NOT_EXIST');

1543:
1544:
1545: IF get_operator_name_hz%ROWCOUNT = 0
1546: THEN
1547: FND_MESSAGE.SET_NAME('AHL','AHL_DI_OPERATOR_CODE_NOT_EXIST');
1548: FND_MSG_PUB.ADD;
1549: ELSIF get_operator_name_hz%ROWCOUNT > 1
1550: THEN
1551: FND_MESSAGE.SET_NAME('AHL','AHL_DI_OPERATOR_USE_LOV');

Line 1551: FND_MESSAGE.SET_NAME('AHL','AHL_DI_OPERATOR_USE_LOV');

1547: FND_MESSAGE.SET_NAME('AHL','AHL_DI_OPERATOR_CODE_NOT_EXIST');
1548: FND_MSG_PUB.ADD;
1549: ELSIF get_operator_name_hz%ROWCOUNT > 1
1550: THEN
1551: FND_MESSAGE.SET_NAME('AHL','AHL_DI_OPERATOR_USE_LOV');
1552: FND_MSG_PUB.ADD;
1553: END IF;
1554: CLOSE get_operator_name_hz;
1555: END IF;

Line 1574: FND_MESSAGE.SET_NAME('AHL','AHL_DI_PRODTYPE_CODE_NOT_EXIST');

1570: x_return_status => l_return_status);
1571:
1572: IF nvl(l_return_status, 'X') <> 'S'
1573: THEN
1574: FND_MESSAGE.SET_NAME('AHL','AHL_DI_PRODTYPE_CODE_NOT_EXIST');
1575: FND_MSG_PUB.ADD;
1576: END IF;
1577:
1578: --ID presntes

Line 1602: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_TYPE_CODE_NOT_EXIST');

1598: x_return_status => l_return_status);
1599:
1600: IF nvl(l_return_status, 'X') <> 'S'
1601: THEN
1602: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_TYPE_CODE_NOT_EXIST');
1603: FND_MSG_PUB.ADD;
1604: END IF;
1605: END IF;
1606: -- Id presents

Line 1612: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_TYPE_CODE_NOT_EXIST');

1608: p_x_document_tbl(i).doc_type_code <> FND_API.G_MISS_CHAR
1609: THEN
1610: l_document_tbl(i).doc_type_code := p_x_document_tbl(i).doc_type_code;
1611: ELSE
1612: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_TYPE_CODE_NOT_EXIST');
1613: FND_MSG_PUB.ADD;
1614: END IF;
1615:
1616: --For Doc Sub Type Code, meaning presents

Line 1631: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_SUBT_COD_NOT_EXISTS');

1627: x_return_status => l_return_status);
1628:
1629: IF nvl(l_return_status, 'X') <> 'S'
1630: THEN
1631: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_SUBT_COD_NOT_EXISTS');
1632: FND_MSG_PUB.ADD;
1633: END IF;
1634: END IF;
1635: --Id presents

Line 1650: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SUBSC_AVAIL_FLAG_NO');

1646: THEN
1647: OPEN check_sub_exists(p_x_document_tbl(i).document_id);
1648: FETCH check_sub_exists INTO l_operator_code;
1649: IF check_sub_exists%FOUND THEN
1650: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SUBSC_AVAIL_FLAG_NO');
1651: FND_MSG_PUB.ADD;
1652: ELSE
1653: p_x_document_tbl(i).subscribe_to_flag := 'N';
1654: END IF;

Line 1661: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SUPPLIER_EXISTS');

1657: OPEN check_sup_exists(p_x_document_tbl(i).document_id);
1658: FETCH check_sup_exists INTO l_operator_code;
1659: IF check_sup_exists%FOUND
1660: THEN
1661: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SUPPLIER_EXISTS');
1662: FND_MSG_PUB.ADD;
1663: END IF;
1664: CLOSE check_sup_exists;
1665: END IF;

Line 1734: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SUPPL_ID_NOT_EXIST');

1730: IF for_party_name%FOUND
1731: THEN
1732: l_supplier_tbl(i).supplier_id := l_supplier_id;
1733: ELSE
1734: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SUPPL_ID_NOT_EXIST');
1735: FND_MESSAGE.SET_TOKEN('SUPNAME',p_x_supplier_tbl(i).supplier_number);
1736: FND_MSG_PUB.ADD;
1737: END IF;
1738: CLOSE for_party_name;

Line 1735: FND_MESSAGE.SET_TOKEN('SUPNAME',p_x_supplier_tbl(i).supplier_number);

1731: THEN
1732: l_supplier_tbl(i).supplier_id := l_supplier_id;
1733: ELSE
1734: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SUPPL_ID_NOT_EXIST');
1735: FND_MESSAGE.SET_TOKEN('SUPNAME',p_x_supplier_tbl(i).supplier_number);
1736: FND_MSG_PUB.ADD;
1737: END IF;
1738: CLOSE for_party_name;
1739: ELSIF ahl_di_doc_index_pvt.get_product_install_status('PO') IN ('I','S')

Line 1747: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SUPPL_ID_NOT_EXIST');

1743: IF for_vendor_id%FOUND
1744: THEN
1745: l_supplier_tbl(i).supplier_id := l_supplier_id;
1746: ELSE
1747: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SUPPL_ID_NOT_EXIST');
1748: FND_MESSAGE.SET_TOKEN('SUPNAME',p_x_supplier_tbl(i).supplier_number);
1749: FND_MSG_PUB.ADD;
1750: END IF;
1751: CLOSE for_vendor_id;

Line 1748: FND_MESSAGE.SET_TOKEN('SUPNAME',p_x_supplier_tbl(i).supplier_number);

1744: THEN
1745: l_supplier_tbl(i).supplier_id := l_supplier_id;
1746: ELSE
1747: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SUPPL_ID_NOT_EXIST');
1748: FND_MESSAGE.SET_TOKEN('SUPNAME',p_x_supplier_tbl(i).supplier_number);
1749: FND_MSG_PUB.ADD;
1750: END IF;
1751: CLOSE for_vendor_id;
1752: END IF;

Line 1761: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SUPPL_ID_NOT_EXIST');

1757: l_supplier_tbl(i).supplier_id := p_x_supplier_tbl(i).supplier_id;
1758: ELSE
1759: IF p_x_supplier_tbl(i).delete_flag <> 'Y' THEN
1760: --Both Supplier Id and Name are missing
1761: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SUPPL_ID_NOT_EXIST');
1762: FND_MESSAGE.SET_TOKEN('SUPNAME',p_x_supplier_tbl(i).supplier_number);
1763: FND_MSG_PUB.ADD;
1764: ELSE
1765: l_supplier_tbl(i).supplier_id := p_x_supplier_tbl(i).supplier_id;

Line 1762: FND_MESSAGE.SET_TOKEN('SUPNAME',p_x_supplier_tbl(i).supplier_number);

1758: ELSE
1759: IF p_x_supplier_tbl(i).delete_flag <> 'Y' THEN
1760: --Both Supplier Id and Name are missing
1761: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SUPPL_ID_NOT_EXIST');
1762: FND_MESSAGE.SET_TOKEN('SUPNAME',p_x_supplier_tbl(i).supplier_number);
1763: FND_MSG_PUB.ADD;
1764: ELSE
1765: l_supplier_tbl(i).supplier_id := p_x_supplier_tbl(i).supplier_id;
1766: END IF;

Line 1784: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SUPPLIER_PREF_TYPE');

1780: x_return_status => l_return_status);
1781:
1782: IF nvl(l_return_status, 'X') <> 'S'
1783: THEN
1784: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SUPPLIER_PREF_TYPE');
1785: FND_MSG_PUB.ADD;
1786: END IF;
1787: END IF;
1788: -- Pref Code presents

Line 1801: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SUPPL_DOC_ID_NULL');

1797:
1798: --if a Subscription exists that Subscribes from the particular Supplier, this Supplier cannot be deleted :prithwi
1799: IF p_x_supplier_tbl(i).delete_flag = 'Y' THEN
1800: if p_x_supplier_tbl(i).document_id IS NULL then
1801: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SUPPL_DOC_ID_NULL');
1802: FND_MSG_PUB.ADD;
1803: end if;
1804: OPEN for_subcr_validate(l_supplier_tbl(i).supplier_id, p_x_supplier_tbl(i).document_id );
1805: FETCH for_subcr_validate INTO l_subscription_id;

Line 1808: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SUPPL_ASSOC_EXISTS');

1804: OPEN for_subcr_validate(l_supplier_tbl(i).supplier_id, p_x_supplier_tbl(i).document_id );
1805: FETCH for_subcr_validate INTO l_subscription_id;
1806: IF for_subcr_validate%FOUND
1807: THEN
1808: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SUPPL_ASSOC_EXISTS');
1809:
1810: -- Bug : Perf Fixes for 4918997
1811: /*
1812: OPEN for_supplier_name(p_x_supplier_tbl(i).supplier_number);

Line 1826: FND_MESSAGE.SET_TOKEN('SUPP',l_supplier_name);

1822: FETCH for_supplier_name_po INTO l_supplier_name;
1823: CLOSE for_supplier_name_po;
1824: END IF;
1825:
1826: FND_MESSAGE.SET_TOKEN('SUPP',l_supplier_name);
1827: FND_MSG_PUB.ADD;
1828: END IF;
1829: CLOSE for_subcr_validate;
1830:

Line 1898: FND_MESSAGE.SET_NAME('AHL','AHL_DI_RECIPIENT_ID_NOT_EXIST');

1894: IF for_party_name%FOUND
1895: THEN
1896: l_recipient_tbl(i).recipient_party_id := l_recipient_id;
1897: ELSE
1898: FND_MESSAGE.SET_NAME('AHL','AHL_DI_RECIPIENT_ID_NOT_EXIST');
1899: FND_MESSAGE.SET_TOKEN('RECPNAME',p_x_recipient_tbl(i).recipient_party_number);
1900: FND_MSG_PUB.ADD;
1901: END IF;
1902: CLOSE for_party_name;

Line 1899: FND_MESSAGE.SET_TOKEN('RECPNAME',p_x_recipient_tbl(i).recipient_party_number);

1895: THEN
1896: l_recipient_tbl(i).recipient_party_id := l_recipient_id;
1897: ELSE
1898: FND_MESSAGE.SET_NAME('AHL','AHL_DI_RECIPIENT_ID_NOT_EXIST');
1899: FND_MESSAGE.SET_TOKEN('RECPNAME',p_x_recipient_tbl(i).recipient_party_number);
1900: FND_MSG_PUB.ADD;
1901: END IF;
1902: CLOSE for_party_name;
1903: --ID presents