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.PO_DOC_NUMBERING_PKG dependencies on FND_MSG_PUB

Line 554: fnd_msg_pub.ADD;

550: x_errorcode := '-1';
551: x_msg_count := '1';
552: x_msg_data := 'Agency Identifiers not defined';
553: fnd_message.set_name('PO', 'PO_CLM_AGENCY_IDENTIFIER_NVD');
554: fnd_msg_pub.ADD;
555: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
556: END;
557:
558: x_agency_identifier_hidden := x_agency_identifier;

Line 555: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);

551: x_msg_count := '1';
552: x_msg_data := 'Agency Identifiers not defined';
553: fnd_message.set_name('PO', 'PO_CLM_AGENCY_IDENTIFIER_NVD');
554: fnd_msg_pub.ADD;
555: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
556: END;
557:
558: x_agency_identifier_hidden := x_agency_identifier;
559: --x_agency_identifier := 'CDC';

Line 656: fnd_msg_pub.ADD;

652: x_errorcode := '-1';
653: x_msg_count := '1';
654: x_msg_data := 'Unable to generate serial number';
655: fnd_message.set_name('PO', 'PO_DOC_NUM_SER_NUM_ERROR');
656: fnd_msg_pub.ADD;
657: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
658: END;
659:
660: END LOOP;

Line 657: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);

653: x_msg_count := '1';
654: x_msg_data := 'Unable to generate serial number';
655: fnd_message.set_name('PO', 'PO_DOC_NUM_SER_NUM_ERROR');
656: fnd_msg_pub.ADD;
657: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
658: END;
659:
660: END LOOP;
661:

Line 675: fnd_msg_pub.ADD;

671: x_errorcode := '-1';
672: x_msg_count := '1';
673: x_msg_data := 'Unable to generate serial number';
674: fnd_message.set_name('PO', 'PO_DOC_NUM_SER_NUM_ERROR');
675: fnd_msg_pub.ADD;
676: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
677: END IF;
678: END IF;
679:

Line 676: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);

672: x_msg_count := '1';
673: x_msg_data := 'Unable to generate serial number';
674: fnd_message.set_name('PO', 'PO_DOC_NUM_SER_NUM_ERROR');
675: fnd_msg_pub.ADD;
676: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
677: END IF;
678: END IF;
679:
680: END req_numbering_XD;

Line 755: fnd_msg_pub.ADD;

751: x_msg_count := '1';
752: x_msg_data := 'All the fields are compulsory, please enter the value for all the Attributes.';
753:
754: fnd_message.set_name('PO', 'PO_DOC_NUM_ALL_FIELDS_COMPUL');
755: fnd_msg_pub.ADD;
756: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
757:
758: END IF;
759:

Line 756: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);

752: x_msg_data := 'All the fields are compulsory, please enter the value for all the Attributes.';
753:
754: fnd_message.set_name('PO', 'PO_DOC_NUM_ALL_FIELDS_COMPUL');
755: fnd_msg_pub.ADD;
756: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
757:
758: END IF;
759:
760: IF 'N' = validate_serial_number(Upper(x_serial_number)) THEN

Line 766: fnd_msg_pub.ADD;

762: x_errorcode := '-1';
763: x_msg_count := '1';
764: x_msg_data := 'Serial number is invalid.';
765: fnd_message.set_name('PO', 'PO_CLM_SERIAL_NUM_INVALID');
766: fnd_msg_pub.ADD;
767: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
768:
769: ELSE
770: select count(*) INTO l_cnt

Line 767: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);

763: x_msg_count := '1';
764: x_msg_data := 'Serial number is invalid.';
765: fnd_message.set_name('PO', 'PO_CLM_SERIAL_NUM_INVALID');
766: fnd_msg_pub.ADD;
767: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
768:
769: ELSE
770: select count(*) INTO l_cnt
771: from po_req_headers_ext_b

Line 781: fnd_msg_pub.ADD;

777: x_errorcode := '-1';
778: x_msg_count := '1';
779: x_msg_data := 'Document Number is not Unique';
780: fnd_message.set_name('PO', 'PO_DOC_NUM_NOT_UNIQUE');
781: fnd_msg_pub.ADD;
782: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
783: ELSE
784: x_return_status := FND_API.G_RET_STS_SUCCESS;
785: x_errorcode := '0';

Line 782: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);

778: x_msg_count := '1';
779: x_msg_data := 'Document Number is not Unique';
780: fnd_message.set_name('PO', 'PO_DOC_NUM_NOT_UNIQUE');
781: fnd_msg_pub.ADD;
782: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
783: ELSE
784: x_return_status := FND_API.G_RET_STS_SUCCESS;
785: x_errorcode := '0';
786: x_msg_count := '1';

Line 933: fnd_msg_pub.ADD;

929: x_errorcode := '-1';
930: x_msg_count := '1';
931: x_msg_data := 'Unable to generate serial number';
932: fnd_message.set_name('PO', 'PO_DOC_NUM_SER_NUM_ERROR');
933: fnd_msg_pub.ADD;
934: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
935: END;
936:
937: IF l_serial_num_fetched = TRUE THEN

Line 934: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);

930: x_msg_count := '1';
931: x_msg_data := 'Unable to generate serial number';
932: fnd_message.set_name('PO', 'PO_DOC_NUM_SER_NUM_ERROR');
933: fnd_msg_pub.ADD;
934: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
935: END;
936:
937: IF l_serial_num_fetched = TRUE THEN
938: x_document_number := x_prefix || x_delimiter

Line 948: fnd_msg_pub.ADD;

944: x_errorcode := '-1';
945: x_msg_count := '1';
946: x_msg_data := 'Unable to generate serial number';
947: fnd_message.set_name('PO', 'PO_DOC_NUM_SER_NUM_ERROR');
948: fnd_msg_pub.ADD;
949: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
950: END IF;
951: END IF;
952:

Line 949: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);

945: x_msg_count := '1';
946: x_msg_data := 'Unable to generate serial number';
947: fnd_message.set_name('PO', 'PO_DOC_NUM_SER_NUM_ERROR');
948: fnd_msg_pub.ADD;
949: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
950: END IF;
951: END IF;
952:
953: END req_numbering_XLE;

Line 1051: fnd_msg_pub.ADD;

1047: WHERE ROWNUM=1;
1048: EXCEPTION
1049: WHEN No_Data_Found THEN
1050: fnd_message.set_name('PO', 'PO_CLM_AGENCY_IDENTIFIER_NVD');
1051: fnd_msg_pub.ADD;
1052: END;
1053:
1054:
1055: x_agency_identifier_hidden := x_agency_identifier;

Line 1070: fnd_msg_pub.ADD;

1066: WHERE ROWNUM=1;
1067: EXCEPTION
1068: WHEN No_Data_Found THEN
1069: fnd_message.set_name('PO', 'PO_CLM_ALLOWED_RANGE_NVD');
1070: fnd_msg_pub.ADD;
1071: END;
1072:
1073: x_allowed_range_hidden := x_allowed_range;
1074: --x_allowed_range := '0001_9999';

Line 1242: fnd_msg_pub.ADD;

1238: x_errorcode := '-1';
1239: x_msg_count := '1';
1240: x_msg_data := 'All the fields are compulsory, please enter the value for all the Attributes.';
1241: fnd_message.set_name('PO', 'PO_DOC_NUM_ALL_FIELDS_COMPUL');
1242: fnd_msg_pub.ADD;
1243: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
1244:
1245: END IF;
1246:

Line 1243: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);

1239: x_msg_count := '1';
1240: x_msg_data := 'All the fields are compulsory, please enter the value for all the Attributes.';
1241: fnd_message.set_name('PO', 'PO_DOC_NUM_ALL_FIELDS_COMPUL');
1242: fnd_msg_pub.ADD;
1243: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
1244:
1245: END IF;
1246:
1247: IF 'N' = validate_serial_number(Upper(x_serial_number)) THEN

Line 1253: fnd_msg_pub.ADD;

1249: x_errorcode := '-1';
1250: x_msg_count := '1';
1251: x_msg_data := 'Serial number is invalid.';
1252: fnd_message.set_name('PO', 'PO_CLM_SERIAL_NUM_INVALID');
1253: fnd_msg_pub.ADD;
1254: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
1255:
1256: ELSE
1257:

Line 1254: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);

1250: x_msg_count := '1';
1251: x_msg_data := 'Serial number is invalid.';
1252: fnd_message.set_name('PO', 'PO_CLM_SERIAL_NUM_INVALID');
1253: fnd_msg_pub.ADD;
1254: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
1255:
1256: ELSE
1257:
1258: select count(*) INTO l_cnt

Line 1269: fnd_msg_pub.ADD;

1265: x_errorcode := '-1';
1266: x_msg_count := '1';
1267: x_msg_data := 'Document Number is not Unique';
1268: fnd_message.set_name('PO', 'PO_DOC_NUM_NOT_UNIQUE');
1269: fnd_msg_pub.ADD;
1270: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
1271: ELSE
1272: x_return_status := FND_API.G_RET_STS_SUCCESS;
1273: x_errorcode := '0';

Line 1270: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);

1266: x_msg_count := '1';
1267: x_msg_data := 'Document Number is not Unique';
1268: fnd_message.set_name('PO', 'PO_DOC_NUM_NOT_UNIQUE');
1269: fnd_msg_pub.ADD;
1270: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
1271: ELSE
1272: x_return_status := FND_API.G_RET_STS_SUCCESS;
1273: x_errorcode := '0';
1274: x_msg_count := '1';

Line 1521: fnd_msg_pub.ADD;

1517:
1518: EXCEPTION
1519: WHEN No_Data_Found THEN
1520: fnd_message.set_name('PO', 'PO_CLM_AGENCY_IDENTIFIER_NVD');
1521: fnd_msg_pub.ADD;
1522: END;
1523:
1524: x_agency_identifier_hidden := x_agency_identifier;
1525: --x_agency_identifier := 'CDC';

Line 1539: fnd_msg_pub.ADD;

1535: WHERE ROWNUM=1;
1536: EXCEPTION
1537: WHEN No_Data_Found THEN
1538: fnd_message.set_name('PO', 'PO_CLM_ALLOWED_RANGE_NVD');
1539: fnd_msg_pub.ADD;
1540: END;
1541:
1542: x_allowed_range_hidden := x_allowed_range;
1543: --x_allowed_range := '0001_9999';

Line 1709: fnd_msg_pub.ADD;

1705: x_errorcode := '-1';
1706: x_msg_count := '1';
1707: x_msg_data := 'All the fields are compulsory, please enter the value for all the Attributes.';
1708: fnd_message.set_name('PO', 'PO_DOC_NUM_ALL_FIELDS_COMPUL');
1709: fnd_msg_pub.ADD;
1710: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
1711:
1712: END IF;
1713:

Line 1710: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);

1706: x_msg_count := '1';
1707: x_msg_data := 'All the fields are compulsory, please enter the value for all the Attributes.';
1708: fnd_message.set_name('PO', 'PO_DOC_NUM_ALL_FIELDS_COMPUL');
1709: fnd_msg_pub.ADD;
1710: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
1711:
1712: END IF;
1713:
1714: IF 'N' = validate_serial_number(Upper(x_serial_number)) THEN

Line 1720: fnd_msg_pub.ADD;

1716: x_errorcode := '-1';
1717: x_msg_count := '1';
1718: x_msg_data := 'Serial number is invalid.';
1719: fnd_message.set_name('PO', 'PO_CLM_SERIAL_NUM_INVALID');
1720: fnd_msg_pub.ADD;
1721: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
1722:
1723: ELSE
1724:

Line 1721: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);

1717: x_msg_count := '1';
1718: x_msg_data := 'Serial number is invalid.';
1719: fnd_message.set_name('PO', 'PO_CLM_SERIAL_NUM_INVALID');
1720: fnd_msg_pub.ADD;
1721: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
1722:
1723: ELSE
1724:
1725: select count(*) INTO l_cnt

Line 1736: fnd_msg_pub.ADD;

1732: x_errorcode := '-1';
1733: x_msg_count := '1';
1734: x_msg_data := 'Document Number is not Unique';
1735: fnd_message.set_name('PO', 'PO_DOC_NUM_NOT_UNIQUE');
1736: fnd_msg_pub.ADD;
1737: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
1738:
1739: ELSE
1740: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1737: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);

1733: x_msg_count := '1';
1734: x_msg_data := 'Document Number is not Unique';
1735: fnd_message.set_name('PO', 'PO_DOC_NUM_NOT_UNIQUE');
1736: fnd_msg_pub.ADD;
1737: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
1738:
1739: ELSE
1740: x_return_status := FND_API.G_RET_STS_SUCCESS;
1741: x_errorcode := '0';

Line 2028: fnd_msg_pub.ADD;

2024: x_errorcode := '-1';
2025: x_msg_count := '1';
2026: x_msg_data := 'All the fields are compulsory, please enter the value for all the Attributes';
2027: fnd_message.set_name('PO', 'PO_DOC_NUM_ALL_FIELDS_COMPUL');
2028: fnd_msg_pub.ADD;
2029: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
2030: END IF;
2031:
2032: select count(*) INTO l_cnt

Line 2029: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);

2025: x_msg_count := '1';
2026: x_msg_data := 'All the fields are compulsory, please enter the value for all the Attributes';
2027: fnd_message.set_name('PO', 'PO_DOC_NUM_ALL_FIELDS_COMPUL');
2028: fnd_msg_pub.ADD;
2029: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
2030: END IF;
2031:
2032: select count(*) INTO l_cnt
2033: from PO_HEADERS_ALL_EXT_B

Line 2044: fnd_msg_pub.ADD;

2040: x_errorcode := '-1';
2041: x_msg_count := '1';
2042: x_msg_data := 'Document Number is not Unique';
2043: fnd_message.set_name('PO', 'PO_DOC_NUM_NOT_UNIQUE');
2044: fnd_msg_pub.ADD;
2045: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
2046: ELSE
2047: x_return_status := FND_API.G_RET_STS_SUCCESS;
2048: x_errorcode := '0';

Line 2045: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);

2041: x_msg_count := '1';
2042: x_msg_data := 'Document Number is not Unique';
2043: fnd_message.set_name('PO', 'PO_DOC_NUM_NOT_UNIQUE');
2044: fnd_msg_pub.ADD;
2045: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
2046: ELSE
2047: x_return_status := FND_API.G_RET_STS_SUCCESS;
2048: x_errorcode := '0';
2049: x_msg_count := '1';

Line 2162: fnd_msg_pub.ADD;

2158: x_errorcode := '-1';
2159: x_msg_count := '1';
2160: x_msg_data := 'All the fields are compulsory, please enter the value for all the Attributes';
2161: fnd_message.set_name('PO', 'PO_DOC_NUM_ALL_FIELDS_COMPUL');
2162: fnd_msg_pub.ADD;
2163: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
2164: END IF;
2165:
2166: select count(*) INTO l_cnt

Line 2163: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);

2159: x_msg_count := '1';
2160: x_msg_data := 'All the fields are compulsory, please enter the value for all the Attributes';
2161: fnd_message.set_name('PO', 'PO_DOC_NUM_ALL_FIELDS_COMPUL');
2162: fnd_msg_pub.ADD;
2163: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
2164: END IF;
2165:
2166: select count(*) INTO l_cnt
2167: from PON_AUCTION_HEADERS_EXT_B

Line 2177: fnd_msg_pub.ADD;

2173: x_errorcode := '-1';
2174: x_msg_count := '1';
2175: x_msg_data := 'Document Number is not Unique';
2176: fnd_message.set_name('PO', 'PO_DOC_NUM_NOT_UNIQUE');
2177: fnd_msg_pub.ADD;
2178: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
2179: ELSE
2180: x_return_status := FND_API.G_RET_STS_SUCCESS;
2181: x_errorcode := '0';

Line 2178: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);

2174: x_msg_count := '1';
2175: x_msg_data := 'Document Number is not Unique';
2176: fnd_message.set_name('PO', 'PO_DOC_NUM_NOT_UNIQUE');
2177: fnd_msg_pub.ADD;
2178: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
2179: ELSE
2180: x_return_status := FND_API.G_RET_STS_SUCCESS;
2181: x_errorcode := '0';
2182: x_msg_count := '1';

Line 2266: fnd_msg_pub.ADD;

2262: EXCEPTION
2263: WHEN No_Data_Found THEN
2264: x_dodaac:='';
2265: fnd_message.set_name('PO', 'PO_CLM_DEFAULT_DODAAC_ND');
2266: fnd_msg_pub.ADD;
2267: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
2268: END;
2269:
2270: x_dodaac_hidden := x_dodaac;

Line 2267: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);

2263: WHEN No_Data_Found THEN
2264: x_dodaac:='';
2265: fnd_message.set_name('PO', 'PO_CLM_DEFAULT_DODAAC_ND');
2266: fnd_msg_pub.ADD;
2267: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
2268: END;
2269:
2270: x_dodaac_hidden := x_dodaac;
2271:

Line 2291: fnd_msg_pub.ADD;

2287: x_errorcode := '-1';
2288: x_msg_count := '1';
2289: x_msg_data := 'Lookup PO_CLM_INSTRUMENT_TYPE not found';
2290: fnd_message.set_name('PO', 'PO_CLM_INSTRUMENT_TYPE_NVD');
2291: fnd_msg_pub.ADD;
2292: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
2293: RETURN;
2294: END;
2295:

Line 2292: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);

2288: x_msg_count := '1';
2289: x_msg_data := 'Lookup PO_CLM_INSTRUMENT_TYPE not found';
2290: fnd_message.set_name('PO', 'PO_CLM_INSTRUMENT_TYPE_NVD');
2291: fnd_msg_pub.ADD;
2292: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
2293: RETURN;
2294: END;
2295:
2296: x_instrument_type_hidden := x_instrument_type;

Line 2312: fnd_msg_pub.ADD;

2308: x_errorcode := '-1';
2309: x_msg_count := '1';
2310: x_msg_data := 'Lookup PO_CLM_ALLOWED_RANGE not found';
2311: fnd_message.set_name('PO', 'PO_CLM_ALLOWED_RANGE_NVD');
2312: fnd_msg_pub.ADD;
2313: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
2314: RETURN;
2315: END;
2316:

Line 2313: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);

2309: x_msg_count := '1';
2310: x_msg_data := 'Lookup PO_CLM_ALLOWED_RANGE not found';
2311: fnd_message.set_name('PO', 'PO_CLM_ALLOWED_RANGE_NVD');
2312: fnd_msg_pub.ADD;
2313: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
2314: RETURN;
2315: END;
2316:
2317: x_allowed_range_hidden := x_allowed_range;

Line 2413: fnd_msg_pub.ADD;

2409: x_errorcode := '-1';
2410: x_msg_count := '1';
2411: x_msg_data := 'Unable to generate serial number';
2412: fnd_message.set_name('PO', 'PO_DOC_NUM_SER_NUM_ERROR');
2413: fnd_msg_pub.ADD;
2414: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
2415: END;
2416:
2417: IF l_serial_num_fetched = FALSE THEN

Line 2414: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);

2410: x_msg_count := '1';
2411: x_msg_data := 'Unable to generate serial number';
2412: fnd_message.set_name('PO', 'PO_DOC_NUM_SER_NUM_ERROR');
2413: fnd_msg_pub.ADD;
2414: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
2415: END;
2416:
2417: IF l_serial_num_fetched = FALSE THEN
2418:

Line 2500: fnd_msg_pub.ADD;

2496: x_errorcode := '-1';
2497: x_msg_count := '1';
2498: x_msg_data := 'Unable to generate serial number';
2499: fnd_message.set_name('PO', 'PO_DOC_NUM_SER_NUM_ERROR');
2500: fnd_msg_pub.ADD;
2501: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
2502: END;
2503:
2504: END IF;

Line 2501: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);

2497: x_msg_count := '1';
2498: x_msg_data := 'Unable to generate serial number';
2499: fnd_message.set_name('PO', 'PO_DOC_NUM_SER_NUM_ERROR');
2500: fnd_msg_pub.ADD;
2501: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
2502: END;
2503:
2504: END IF;
2505: END LOOP;

Line 2520: fnd_msg_pub.ADD;

2516: x_errorcode := '-1';
2517: x_msg_count := '1';
2518: x_msg_data := 'Unable to generate serial number';
2519: fnd_message.set_name('PO', 'PO_DOC_NUM_SER_NUM_ERROR');
2520: fnd_msg_pub.ADD;
2521: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
2522: END IF;
2523: END IF;
2524:

Line 2521: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);

2517: x_msg_count := '1';
2518: x_msg_data := 'Unable to generate serial number';
2519: fnd_message.set_name('PO', 'PO_DOC_NUM_SER_NUM_ERROR');
2520: fnd_msg_pub.ADD;
2521: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
2522: END IF;
2523: END IF;
2524:
2525: END dod_sol_numbering_XD;

Line 2605: fnd_msg_pub.ADD;

2601: x_errorcode := '-1';
2602: x_msg_count := '1';
2603: x_msg_data := 'All the fields are compulsory, please enter the value for all the Attributes.';
2604: fnd_message.set_name('PO', 'PO_DOC_NUM_ALL_FIELDS_COMPUL');
2605: fnd_msg_pub.ADD;
2606: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
2607:
2608: END IF;
2609:

Line 2606: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);

2602: x_msg_count := '1';
2603: x_msg_data := 'All the fields are compulsory, please enter the value for all the Attributes.';
2604: fnd_message.set_name('PO', 'PO_DOC_NUM_ALL_FIELDS_COMPUL');
2605: fnd_msg_pub.ADD;
2606: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
2607:
2608: END IF;
2609:
2610: IF x_serial_number IS NOT NULL AND Upper(x_serial_number) <> 'XXXX' THEN

Line 2617: fnd_msg_pub.ADD;

2613: x_errorcode := '-1';
2614: x_msg_count := '1';
2615: x_msg_data := 'Serial number is invalid.';
2616: fnd_message.set_name('PO', 'PO_CLM_SERIAL_NUM_INVALID');
2617: fnd_msg_pub.ADD;
2618: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
2619: ELSE
2620:
2621: IF(Length(x_document_number) > 240) THEN

Line 2618: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);

2614: x_msg_count := '1';
2615: x_msg_data := 'Serial number is invalid.';
2616: fnd_message.set_name('PO', 'PO_CLM_SERIAL_NUM_INVALID');
2617: fnd_msg_pub.ADD;
2618: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
2619: ELSE
2620:
2621: IF(Length(x_document_number) > 240) THEN
2622: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2627: fnd_msg_pub.ADD;

2623: x_errorcode := '-1';
2624: x_msg_count := '1';
2625: x_msg_data := 'Document Number length exceeds the maximum allowed limit.';
2626: fnd_message.set_name('PO', 'PO_CLM_DOC_NUM_LENGTH_ERR');
2627: fnd_msg_pub.ADD;
2628: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
2629: END IF;
2630:
2631: select count(*) INTO l_cnt

Line 2628: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);

2624: x_msg_count := '1';
2625: x_msg_data := 'Document Number length exceeds the maximum allowed limit.';
2626: fnd_message.set_name('PO', 'PO_CLM_DOC_NUM_LENGTH_ERR');
2627: fnd_msg_pub.ADD;
2628: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
2629: END IF;
2630:
2631: select count(*) INTO l_cnt
2632: from PON_AUCTION_HEADERS_EXT_B

Line 2642: fnd_msg_pub.ADD;

2638: x_errorcode := '-1';
2639: x_msg_count := '1';
2640: x_msg_data := 'Document Number is not Unique';
2641: fnd_message.set_name('PO', 'PO_DOC_NUM_NOT_UNIQUE');
2642: fnd_msg_pub.ADD;
2643: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
2644: END IF;
2645: END IF;
2646: END IF;

Line 2643: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);

2639: x_msg_count := '1';
2640: x_msg_data := 'Document Number is not Unique';
2641: fnd_message.set_name('PO', 'PO_DOC_NUM_NOT_UNIQUE');
2642: fnd_msg_pub.ADD;
2643: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
2644: END IF;
2645: END IF;
2646: END IF;
2647:

Line 2822: fnd_msg_pub.ADD;

2818: x_errorcode := '-1';
2819: x_msg_count := '1';
2820: x_msg_data := 'Users default DoDAAC not found';
2821: fnd_message.set_name('PO', 'PO_CLM_DEFAULT_DODAAC_ND');
2822: fnd_msg_pub.ADD;
2823: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
2824: END;
2825:
2826: x_dodaac_hidden := x_dodaac;

Line 2823: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);

2819: x_msg_count := '1';
2820: x_msg_data := 'Users default DoDAAC not found';
2821: fnd_message.set_name('PO', 'PO_CLM_DEFAULT_DODAAC_ND');
2822: fnd_msg_pub.ADD;
2823: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
2824: END;
2825:
2826: x_dodaac_hidden := x_dodaac;
2827:

Line 2847: fnd_msg_pub.ADD;

2843: x_errorcode := '-1';
2844: x_msg_count := '1';
2845: x_msg_data := 'Lookup PO_CLM_INSTRUMENT_TYPE not found';
2846: fnd_message.set_name('PO', 'PO_CLM_INSTRUMENT_TYPE_NVD');
2847: fnd_msg_pub.ADD;
2848: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
2849: RETURN;
2850: END;
2851:

Line 2848: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);

2844: x_msg_count := '1';
2845: x_msg_data := 'Lookup PO_CLM_INSTRUMENT_TYPE not found';
2846: fnd_message.set_name('PO', 'PO_CLM_INSTRUMENT_TYPE_NVD');
2847: fnd_msg_pub.ADD;
2848: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
2849: RETURN;
2850: END;
2851:
2852: x_instrument_type_hidden := x_instrument_type;

Line 2868: fnd_msg_pub.ADD;

2864: x_errorcode := '-1';
2865: x_msg_count := '1';
2866: x_msg_data := 'Lookup PO_CLM_ALLOWED_RANGE not found';
2867: fnd_message.set_name('PO', 'PO_CLM_ALLOWED_RANGE_NVD');
2868: fnd_msg_pub.ADD;
2869: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
2870: RETURN;
2871: END;
2872:

Line 2869: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);

2865: x_msg_count := '1';
2866: x_msg_data := 'Lookup PO_CLM_ALLOWED_RANGE not found';
2867: fnd_message.set_name('PO', 'PO_CLM_ALLOWED_RANGE_NVD');
2868: fnd_msg_pub.ADD;
2869: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
2870: RETURN;
2871: END;
2872:
2873: x_allowed_range_hidden := x_allowed_range;

Line 2973: fnd_msg_pub.ADD;

2969: x_errorcode := '-1';
2970: x_msg_count := '1';
2971: x_msg_data := 'Unable to generate serial number';
2972: fnd_message.set_name('PO', 'PO_DOC_NUM_SER_NUM_ERROR');
2973: fnd_msg_pub.ADD;
2974: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
2975: END;
2976:
2977: IF l_serial_num_fetched = FALSE THEN

Line 2974: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);

2970: x_msg_count := '1';
2971: x_msg_data := 'Unable to generate serial number';
2972: fnd_message.set_name('PO', 'PO_DOC_NUM_SER_NUM_ERROR');
2973: fnd_msg_pub.ADD;
2974: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
2975: END;
2976:
2977: IF l_serial_num_fetched = FALSE THEN
2978:

Line 3060: fnd_msg_pub.ADD;

3056: x_errorcode := '-1';
3057: x_msg_count := '1';
3058: x_msg_data := 'Unable to generate serial number';
3059: fnd_message.set_name('PO', 'PO_DOC_NUM_SER_NUM_ERROR');
3060: fnd_msg_pub.ADD;
3061: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
3062: END;
3063:
3064: END IF;

Line 3061: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);

3057: x_msg_count := '1';
3058: x_msg_data := 'Unable to generate serial number';
3059: fnd_message.set_name('PO', 'PO_DOC_NUM_SER_NUM_ERROR');
3060: fnd_msg_pub.ADD;
3061: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
3062: END;
3063:
3064: END IF;
3065: END LOOP;

Line 3080: fnd_msg_pub.ADD;

3076: x_errorcode := '-1';
3077: x_msg_count := '1';
3078: x_msg_data := 'Unable to generate serial number';
3079: fnd_message.set_name('PO', 'PO_DOC_NUM_SER_NUM_ERROR');
3080: fnd_msg_pub.ADD;
3081: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
3082: END IF;
3083: END IF;
3084:

Line 3081: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);

3077: x_msg_count := '1';
3078: x_msg_data := 'Unable to generate serial number';
3079: fnd_message.set_name('PO', 'PO_DOC_NUM_SER_NUM_ERROR');
3080: fnd_msg_pub.ADD;
3081: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
3082: END IF;
3083: END IF;
3084:
3085: END dod_award_numbering_XD;

Line 3167: fnd_msg_pub.ADD;

3163: x_errorcode := '-1';
3164: x_msg_count := '1';
3165: x_msg_data := 'All the fields are compulsory, please enter the value for all the Attributes.';
3166: fnd_message.set_name('PO', 'PO_DOC_NUM_ALL_FIELDS_COMPUL');
3167: fnd_msg_pub.ADD;
3168: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
3169:
3170: END IF;
3171:

Line 3168: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);

3164: x_msg_count := '1';
3165: x_msg_data := 'All the fields are compulsory, please enter the value for all the Attributes.';
3166: fnd_message.set_name('PO', 'PO_DOC_NUM_ALL_FIELDS_COMPUL');
3167: fnd_msg_pub.ADD;
3168: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
3169:
3170: END IF;
3171:
3172:

Line 3181: fnd_msg_pub.ADD;

3177: x_errorcode := '-1';
3178: x_msg_count := '1';
3179: x_msg_data := 'Serial number is invalid.';
3180: fnd_message.set_name('PO', 'PO_CLM_SERIAL_NUM_INVALID');
3181: fnd_msg_pub.ADD;
3182: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
3183: ELSE
3184:
3185: IF(Length(x_document_number) > 50) THEN

Line 3182: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);

3178: x_msg_count := '1';
3179: x_msg_data := 'Serial number is invalid.';
3180: fnd_message.set_name('PO', 'PO_CLM_SERIAL_NUM_INVALID');
3181: fnd_msg_pub.ADD;
3182: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
3183: ELSE
3184:
3185: IF(Length(x_document_number) > 50) THEN
3186: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3191: fnd_msg_pub.ADD;

3187: x_errorcode := '-1';
3188: x_msg_count := '1';
3189: x_msg_data := 'Document Number exceeds the maximum allowed limit of 50.';
3190: fnd_message.set_name('PO', 'PO_CLM_DOC_NUM_LENGTH_ERR');
3191: fnd_msg_pub.ADD;
3192: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
3193: END IF;
3194:
3195: select count(*) INTO l_cnt

Line 3192: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);

3188: x_msg_count := '1';
3189: x_msg_data := 'Document Number exceeds the maximum allowed limit of 50.';
3190: fnd_message.set_name('PO', 'PO_CLM_DOC_NUM_LENGTH_ERR');
3191: fnd_msg_pub.ADD;
3192: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
3193: END IF;
3194:
3195: select count(*) INTO l_cnt
3196: from PO_HEADERS_ALL_EXT_B

Line 3206: fnd_msg_pub.ADD;

3202: x_errorcode := '-1';
3203: x_msg_count := '1';
3204: x_msg_data := 'Document Number is not Unique';
3205: fnd_message.set_name('PO', 'PO_DOC_NUM_NOT_UNIQUE');
3206: fnd_msg_pub.ADD;
3207: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
3208: END IF;
3209: END IF;
3210: END IF;

Line 3207: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);

3203: x_msg_count := '1';
3204: x_msg_data := 'Document Number is not Unique';
3205: fnd_message.set_name('PO', 'PO_DOC_NUM_NOT_UNIQUE');
3206: fnd_msg_pub.ADD;
3207: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
3208: END IF;
3209: END IF;
3210: END IF;
3211:

Line 3402: fnd_msg_pub.ADD;

3398: x_errorcode := '-1';
3399: x_msg_count := '1';
3400: x_msg_data := 'Lookup PO_CLM_ALLOWED_RANGE not found';
3401: fnd_message.set_name('PO', 'PO_CLM_ALLOWED_RANGE_NVD');
3402: fnd_msg_pub.ADD;
3403: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
3404: RETURN;
3405: END;
3406:

Line 3403: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);

3399: x_msg_count := '1';
3400: x_msg_data := 'Lookup PO_CLM_ALLOWED_RANGE not found';
3401: fnd_message.set_name('PO', 'PO_CLM_ALLOWED_RANGE_NVD');
3402: fnd_msg_pub.ADD;
3403: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
3404: RETURN;
3405: END;
3406:
3407: x_allowed_range_hidden := x_allowed_range;

Line 3493: fnd_msg_pub.ADD;

3489: x_errorcode := '-1';
3490: x_msg_count := '1';
3491: x_msg_data := 'Unable to generate serial number';
3492: fnd_message.set_name('PO', 'PO_DOC_NUM_SER_NUM_ERROR');
3493: fnd_msg_pub.ADD;
3494: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
3495: END;
3496:
3497: IF l_serial_num_fetched = FALSE THEN

Line 3494: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);

3490: x_msg_count := '1';
3491: x_msg_data := 'Unable to generate serial number';
3492: fnd_message.set_name('PO', 'PO_DOC_NUM_SER_NUM_ERROR');
3493: fnd_msg_pub.ADD;
3494: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
3495: END;
3496:
3497: IF l_serial_num_fetched = FALSE THEN
3498:

Line 3577: fnd_msg_pub.ADD;

3573: x_errorcode := '-1';
3574: x_msg_count := '1';
3575: x_msg_data := 'Unable to generate serial number';
3576: fnd_message.set_name('PO', 'PO_DOC_NUM_SER_NUM_ERROR');
3577: fnd_msg_pub.ADD;
3578: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
3579: END;
3580:
3581: END IF;

Line 3578: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);

3574: x_msg_count := '1';
3575: x_msg_data := 'Unable to generate serial number';
3576: fnd_message.set_name('PO', 'PO_DOC_NUM_SER_NUM_ERROR');
3577: fnd_msg_pub.ADD;
3578: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
3579: END;
3580:
3581: END IF;
3582: END LOOP;

Line 3594: fnd_msg_pub.ADD;

3590: x_errorcode := '-1';
3591: x_msg_count := '1';
3592: x_msg_data := 'Unable to generate serial number';
3593: fnd_message.set_name('PO', 'PO_DOC_NUM_SER_NUM_ERROR');
3594: fnd_msg_pub.ADD;
3595: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
3596: END IF;
3597:
3598: END IF;

Line 3595: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);

3591: x_msg_count := '1';
3592: x_msg_data := 'Unable to generate serial number';
3593: fnd_message.set_name('PO', 'PO_DOC_NUM_SER_NUM_ERROR');
3594: fnd_msg_pub.ADD;
3595: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
3596: END IF;
3597:
3598: END IF;
3599:

Line 3637: fnd_msg_pub.ADD;

3633: x_errorcode := '-1';
3634: x_msg_count := '1';
3635: x_msg_data := 'All the fields are compulsory, please enter the value for all the Attributes.';
3636: fnd_message.set_name('PO', 'PO_DOC_NUM_ALL_FIELDS_COMPUL');
3637: fnd_msg_pub.ADD;
3638: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
3639:
3640: END IF;
3641:

Line 3638: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);

3634: x_msg_count := '1';
3635: x_msg_data := 'All the fields are compulsory, please enter the value for all the Attributes.';
3636: fnd_message.set_name('PO', 'PO_DOC_NUM_ALL_FIELDS_COMPUL');
3637: fnd_msg_pub.ADD;
3638: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
3639:
3640: END IF;
3641:
3642:

Line 3650: fnd_msg_pub.ADD;

3646: x_errorcode := '-1';
3647: x_msg_count := '1';
3648: x_msg_data := 'Serial number is invalid.';
3649: fnd_message.set_name('PO', 'PO_CLM_SERIAL_NUM_INVALID');
3650: fnd_msg_pub.ADD;
3651: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
3652: ELSE
3653:
3654: select count(*) INTO l_cnt

Line 3651: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);

3647: x_msg_count := '1';
3648: x_msg_data := 'Serial number is invalid.';
3649: fnd_message.set_name('PO', 'PO_CLM_SERIAL_NUM_INVALID');
3650: fnd_msg_pub.ADD;
3651: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
3652: ELSE
3653:
3654: select count(*) INTO l_cnt
3655: from PO_HEADERS_ALL_EXT_B

Line 3665: fnd_msg_pub.ADD;

3661: x_errorcode := '-1';
3662: x_msg_count := '1';
3663: x_msg_data := 'Document Number is not Unique';
3664: fnd_message.set_name('PO', 'PO_DOC_NUM_NOT_UNIQUE');
3665: fnd_msg_pub.ADD;
3666: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
3667: END IF;
3668: END IF;
3669: END IF;

Line 3666: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);

3662: x_msg_count := '1';
3663: x_msg_data := 'Document Number is not Unique';
3664: fnd_message.set_name('PO', 'PO_DOC_NUM_NOT_UNIQUE');
3665: fnd_msg_pub.ADD;
3666: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
3667: END IF;
3668: END IF;
3669: END IF;
3670:

Line 3943: fnd_msg_pub.ADD;

3939: x_errorcode := '-1';
3940: x_msg_count := '1';
3941: x_msg_data := 'All the fields are compulsory, please enter the value for all the Attributes.';
3942: fnd_message.set_name('PO', 'PO_DOC_NUM_ALL_FIELDS_COMPUL');
3943: fnd_msg_pub.ADD;
3944: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
3945:
3946: END IF;
3947:

Line 3944: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);

3940: x_msg_count := '1';
3941: x_msg_data := 'All the fields are compulsory, please enter the value for all the Attributes.';
3942: fnd_message.set_name('PO', 'PO_DOC_NUM_ALL_FIELDS_COMPUL');
3943: fnd_msg_pub.ADD;
3944: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
3945:
3946: END IF;
3947:
3948: IF x_serial_number IS NOT NULL AND (G_PO_VALIDATION_EVENT_TYPE LIKE 'SAVE' OR Upper(x_serial_number) <> 'XX') THEN

Line 3956: fnd_msg_pub.ADD;

3952: x_errorcode := '-1';
3953: x_msg_count := '1';
3954: x_msg_data := 'Serial number is invalid.';
3955: fnd_message.set_name('PO', 'PO_CLM_SERIAL_NUM_INVALID');
3956: fnd_msg_pub.ADD;
3957: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
3958: ELSE
3959:
3960: select count(*) INTO l_cnt

Line 3957: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);

3953: x_msg_count := '1';
3954: x_msg_data := 'Serial number is invalid.';
3955: fnd_message.set_name('PO', 'PO_CLM_SERIAL_NUM_INVALID');
3956: fnd_msg_pub.ADD;
3957: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
3958: ELSE
3959:
3960: select count(*) INTO l_cnt
3961: from PO_HEADERS_ALL_EXT_B

Line 3971: fnd_msg_pub.ADD;

3967: x_errorcode := '-1';
3968: x_msg_count := '1';
3969: x_msg_data := 'Document Number is not Unique';
3970: fnd_message.set_name('PO', 'PO_DOC_NUM_NOT_UNIQUE');
3971: fnd_msg_pub.ADD;
3972: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
3973: END IF;
3974: END IF;
3975: END IF;

Line 3972: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);

3968: x_msg_count := '1';
3969: x_msg_data := 'Document Number is not Unique';
3970: fnd_message.set_name('PO', 'PO_DOC_NUM_NOT_UNIQUE');
3971: fnd_msg_pub.ADD;
3972: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
3973: END IF;
3974: END IF;
3975: END IF;
3976:

Line 4205: fnd_msg_pub.ADD;

4201: x_errorcode := '-1';
4202: x_msg_count := '1';
4203: x_msg_data := 'All the fields are compulsory, please enter the value for all the Attributes';
4204: fnd_message.set_name('PO', 'PO_DOC_NUM_ALL_FIELDS_COMPUL');
4205: fnd_msg_pub.ADD;
4206: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
4207: END IF;
4208:
4209: IF x_serial_number IS NOT NULL AND Upper(x_serial_number) <> 'XXXX' THEN

Line 4206: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);

4202: x_msg_count := '1';
4203: x_msg_data := 'All the fields are compulsory, please enter the value for all the Attributes';
4204: fnd_message.set_name('PO', 'PO_DOC_NUM_ALL_FIELDS_COMPUL');
4205: fnd_msg_pub.ADD;
4206: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
4207: END IF;
4208:
4209: IF x_serial_number IS NOT NULL AND Upper(x_serial_number) <> 'XXXX' THEN
4210: select count(*) INTO l_cnt

Line 4221: fnd_msg_pub.ADD;

4217: x_errorcode := '-1';
4218: x_msg_count := '1';
4219: x_msg_data := 'Document Number is not Unique';
4220: fnd_message.set_name('PO', 'PO_DOC_NUM_NOT_UNIQUE');
4221: fnd_msg_pub.ADD;
4222: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
4223: END IF;
4224: END IF;
4225:

Line 4222: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);

4218: x_msg_count := '1';
4219: x_msg_data := 'Document Number is not Unique';
4220: fnd_message.set_name('PO', 'PO_DOC_NUM_NOT_UNIQUE');
4221: fnd_msg_pub.ADD;
4222: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
4223: END IF;
4224: END IF;
4225:
4226: END dod_sol_amd_XV;

Line 4335: fnd_msg_pub.ADD;

4331: x_errorcode := '-1';
4332: x_msg_count := '1';
4333: x_msg_data := 'Lookup PO_CLM_MODIFICATION_TYPE not found';
4334: fnd_message.set_name('PO', 'PO_CLM_MODIFICATION_TYPE_NVD');
4335: fnd_msg_pub.ADD;
4336: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
4337: RETURN;
4338: END;
4339:

Line 4336: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);

4332: x_msg_count := '1';
4333: x_msg_data := 'Lookup PO_CLM_MODIFICATION_TYPE not found';
4334: fnd_message.set_name('PO', 'PO_CLM_MODIFICATION_TYPE_NVD');
4335: fnd_msg_pub.ADD;
4336: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
4337: RETURN;
4338: END;
4339:
4340: x_modif_type_h := x_modif_type;

Line 4456: fnd_msg_pub.ADD;

4452: x_errorcode := '-1';
4453: x_msg_count := '1';
4454: x_msg_data := 'All the fields are compulsory, please enter the value for all the Attributes';
4455: fnd_message.set_name('PO', 'PO_DOC_NUM_ALL_FIELDS_COMPUL');
4456: fnd_msg_pub.ADD;
4457: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
4458: END IF;
4459:
4460: IF x_serial_number IS NOT NULL AND Upper(x_serial_number) <> 'XXXX' THEN

Line 4457: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);

4453: x_msg_count := '1';
4454: x_msg_data := 'All the fields are compulsory, please enter the value for all the Attributes';
4455: fnd_message.set_name('PO', 'PO_DOC_NUM_ALL_FIELDS_COMPUL');
4456: fnd_msg_pub.ADD;
4457: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
4458: END IF;
4459:
4460: IF x_serial_number IS NOT NULL AND Upper(x_serial_number) <> 'XXXX' THEN
4461:

Line 4474: fnd_msg_pub.ADD;

4470: x_errorcode := '-1';
4471: x_msg_count := '1';
4472: x_msg_data := 'Document Number is not Unique';
4473: fnd_message.set_name('PO', 'PO_DOC_NUM_NOT_UNIQUE');
4474: fnd_msg_pub.ADD;
4475: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
4476: END IF;
4477: END IF;
4478:

Line 4475: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);

4471: x_msg_count := '1';
4472: x_msg_data := 'Document Number is not Unique';
4473: fnd_message.set_name('PO', 'PO_DOC_NUM_NOT_UNIQUE');
4474: fnd_msg_pub.ADD;
4475: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
4476: END IF;
4477: END IF;
4478:
4479: END dod_ord_mod_XV;

Line 4679: fnd_msg_pub.ADD;

4675: x_errorcode := '-1';
4676: x_msg_count := '1';
4677: x_msg_data := 'Lookup PO_CLM_MODIFICATION_TYPE not found';
4678: fnd_message.set_name('PO', 'PO_CLM_MODIFICATION_TYPE_NVD');
4679: fnd_msg_pub.ADD;
4680: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
4681: RETURN;
4682: END;
4683:

Line 4680: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);

4676: x_msg_count := '1';
4677: x_msg_data := 'Lookup PO_CLM_MODIFICATION_TYPE not found';
4678: fnd_message.set_name('PO', 'PO_CLM_MODIFICATION_TYPE_NVD');
4679: fnd_msg_pub.ADD;
4680: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
4681: RETURN;
4682: END;
4683:
4684: BEGIN

Line 4698: fnd_msg_pub.ADD;

4694: x_errorcode := '-1';
4695: x_msg_count := '1';
4696: x_msg_data := 'Lookup PO_CLM_MODIFICATION_CODE not found';
4697: fnd_message.set_name('PO', 'PO_CLM_MODIFICATION_CODE_NVD');
4698: fnd_msg_pub.ADD;
4699: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
4700: RETURN;
4701: END;
4702:

Line 4699: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);

4695: x_msg_count := '1';
4696: x_msg_data := 'Lookup PO_CLM_MODIFICATION_CODE not found';
4697: fnd_message.set_name('PO', 'PO_CLM_MODIFICATION_CODE_NVD');
4698: fnd_msg_pub.ADD;
4699: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
4700: RETURN;
4701: END;
4702:
4703: x_delimiter := '-';

Line 4781: fnd_msg_pub.ADD;

4777: x_errorcode := '-1';
4778: x_msg_count := '1';
4779: x_msg_data := 'All the fields are compulsory, please enter the value for all the Attributes';
4780: fnd_message.set_name('PO', 'PO_DOC_NUM_ALL_FIELDS_COMPUL');
4781: fnd_msg_pub.ADD;
4782: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
4783: END IF;
4784:
4785: IF x_serial_number IS NOT NULL AND Upper(x_serial_number) <> 'XXXX' THEN

Line 4782: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);

4778: x_msg_count := '1';
4779: x_msg_data := 'All the fields are compulsory, please enter the value for all the Attributes';
4780: fnd_message.set_name('PO', 'PO_DOC_NUM_ALL_FIELDS_COMPUL');
4781: fnd_msg_pub.ADD;
4782: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
4783: END IF;
4784:
4785: IF x_serial_number IS NOT NULL AND Upper(x_serial_number) <> 'XXXX' THEN
4786: select count(*) INTO l_cnt

Line 4798: fnd_msg_pub.ADD;

4794: x_errorcode := '-1';
4795: x_msg_count := '1';
4796: x_msg_data := 'Document Number is not Unique';
4797: fnd_message.set_name('PO', 'PO_DOC_NUM_NOT_UNIQUE');
4798: fnd_msg_pub.ADD;
4799: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
4800: END IF;
4801: END IF;
4802:

Line 4799: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);

4795: x_msg_count := '1';
4796: x_msg_data := 'Document Number is not Unique';
4797: fnd_message.set_name('PO', 'PO_DOC_NUM_NOT_UNIQUE');
4798: fnd_msg_pub.ADD;
4799: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
4800: END IF;
4801: END IF;
4802:
4803: END dod_awd_mod_XV;