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_API

Line 125: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_return_status', FND_API.G_RET_STS_SUCCESS, l_external_attr_value_pairs);

121:
122: IF p_caller = 'PO_MOD' OR p_caller = 'PO' THEN
123:
124: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('p_source_doc_number', l_idv_number, l_external_attr_value_pairs);
125: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_return_status', FND_API.G_RET_STS_SUCCESS, l_external_attr_value_pairs);
126: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_errorcode', '0', l_external_attr_value_pairs);
127: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_msg_count', '0', l_external_attr_value_pairs);
128: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_msg_data', 'SUCCESS', l_external_attr_value_pairs);
129:

Line 162: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_return_status', FND_API.G_RET_STS_SUCCESS, l_external_attr_value_pairs);

158:
159: ELSIF p_caller = 'SOL_AMD' THEN
160:
161: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('BASE_AUCTION_HEADER_ID', p_draft_id, l_external_attr_value_pairs);
162: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_return_status', FND_API.G_RET_STS_SUCCESS, l_external_attr_value_pairs);
163: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_errorcode', '0', l_external_attr_value_pairs);
164: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_msg_count', '0', l_external_attr_value_pairs);
165: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_msg_data', 'SUCCESS', l_external_attr_value_pairs);
166:

Line 279: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_return_status', FND_API.G_RET_STS_SUCCESS, l_external_attr_value_pairs);

275: ,x_msg_data => l_msg_data
276: );
277:
278: l_external_attr_value_pairs :=NULL;
279: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_return_status', FND_API.G_RET_STS_SUCCESS, l_external_attr_value_pairs);
280: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_errorcode', '0', l_external_attr_value_pairs);
281: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_msg_count', '0', l_external_attr_value_pairs);
282: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_msg_data', 'SUCCESS', l_external_attr_value_pairs);
283: IF p_caller = 'SOL_AMD' THEN

Line 289: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

285: ELSIF p_caller = 'PO' AND l_source_org_owned <> 'NA' THEN
286: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('p_source_doc_number', l_idv_number, l_external_attr_value_pairs);
287: END IF;
288:
289: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
290: PO_UDA_IMPORT_PKG.EXECUTE_IMPORT_UDA_FUNCTION
291: (
292: p_template_id => p_template_id
293: ,p_event => 'XD'

Line 314: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

310: 'UDA_TEMPLATE_ID',p_template_id || ''
311: )
312: );
313:
314: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
315: EGO_USER_ATTRS_DATA_PVT.Process_User_Attrs_Data
316: (
317: p_api_version => 1.0
318: ,p_object_name => l_src_object_name

Line 526: x_return_status := FND_API.G_RET_STS_SUCCESS;

522: l_serial_num_fetched BOOLEAN := FALSE;
523:
524: BEGIN
525: -- If document number is already generated, just return and don't redefault
526: x_return_status := FND_API.G_RET_STS_SUCCESS;
527: x_errorcode := '0';
528: x_msg_count := '1';
529: x_msg_data := 'SUCCESS';
530:

Line 549: x_return_status := FND_API.G_RET_STS_ERROR;

545: and enabled_flag = 'Y' and trunc(nvl(inactive_date, sysdate)) >= trunc(sysdate) order by lookup_code)
546: WHERE ROWNUM=1;
547: EXCEPTION
548: WHEN No_Data_Found THEN
549: x_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 651: x_return_status := FND_API.G_RET_STS_ERROR;

647: EXCEPTION
648: WHEN No_Data_Found THEN
649: l_serial_num_fetched := FALSE;
650: WHEN OTHERS THEN
651: x_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 670: x_return_status := FND_API.G_RET_STS_ERROR;

666: || x_fiscal_year || x_delimiter
667: || x_agency_identifier || x_delimiter
668: || x_serial_number ;
669: ELSE
670: x_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 749: x_return_status := FND_API.G_RET_STS_ERROR;

745: x_fiscal_year IS NULL OR
746: x_agency_identifier IS NULL OR x_agency_identifier = '' OR
747: x_serial_number IS NULL OR x_serial_number = '' THEN
748:
749: x_return_status := FND_API.G_RET_STS_ERROR;
750: x_errorcode := '-1';
751: x_msg_count := '1';
752: x_msg_data := 'All the fields are compulsory, please enter the value for all the Attributes.';
753:

Line 761: x_return_status := FND_API.G_RET_STS_ERROR;

757:
758: END IF;
759:
760: IF 'N' = validate_serial_number(Upper(x_serial_number)) THEN
761: x_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 776: x_return_status := FND_API.G_RET_STS_ERROR;

772: WHERE C_EXT_ATTR40 = x_document_number
773: AND requisition_header_id <> x_requisition_header_id;
774:
775: IF l_cnt > 0 THEN
776: x_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 784: x_return_status := FND_API.G_RET_STS_SUCCESS;

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';
787: x_msg_data := 'SUCCESS';
788: END IF;

Line 838: x_return_status := FND_API.G_RET_STS_SUCCESS;

834: l_lookup_code NUMBER;
835:
836: BEGIN
837:
838: x_return_status := FND_API.G_RET_STS_SUCCESS;
839: x_errorcode := '0';
840: x_msg_count := '1';
841: x_msg_data := 'SUCCESS';
842:

Line 928: x_return_status := FND_API.G_RET_STS_ERROR;

924: EXCEPTION
925: WHEN No_Data_Found THEN
926: l_serial_num_fetched := FALSE;
927: WHEN OTHERS THEN
928: x_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 943: x_return_status := FND_API.G_RET_STS_ERROR;

939: || x_fiscal_year || x_delimiter
940: || x_agency_identifier || x_delimiter
941: || x_serial_number ;
942: ELSE
943: x_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 1159: x_return_status := FND_API.G_RET_STS_SUCCESS;

1155: || x_serial_number ;
1156:
1157: END IF;
1158:
1159: x_return_status := FND_API.G_RET_STS_SUCCESS;
1160: x_errorcode := '0';
1161: x_msg_count := '1';
1162: x_msg_data := 'SUCCESS';
1163:

Line 1237: x_return_status := FND_API.G_RET_STS_ERROR;

1233: x_fiscal_year IS NULL OR
1234: x_agency_identifier IS NULL OR x_agency_identifier = '' OR
1235: x_serial_number IS NULL OR x_serial_number = '' THEN
1236:
1237: x_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 1248: x_return_status := FND_API.G_RET_STS_ERROR;

1244:
1245: END IF;
1246:
1247: IF 'N' = validate_serial_number(Upper(x_serial_number)) THEN
1248: x_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 1264: x_return_status := FND_API.G_RET_STS_ERROR;

1260: WHERE C_EXT_ATTR40 = x_document_number
1261: AND auction_header_id <> x_auction_header_id;
1262:
1263: IF l_cnt > 0 THEN
1264: x_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 1272: x_return_status := FND_API.G_RET_STS_SUCCESS;

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';
1275: x_msg_data := 'SUCCESS';
1276: END IF;

Line 1415: x_return_status := FND_API.G_RET_STS_SUCCESS;

1411:
1412:
1413: END IF;
1414:
1415: x_return_status := FND_API.G_RET_STS_SUCCESS;
1416: x_errorcode := '0';
1417: x_msg_count := '1';
1418: x_msg_data := 'SUCCESS';
1419:

Line 1628: x_return_status := FND_API.G_RET_STS_SUCCESS;

1624: || x_serial_number ;
1625:
1626: END IF;
1627:
1628: x_return_status := FND_API.G_RET_STS_SUCCESS;
1629: x_errorcode := '0';
1630: x_msg_count := '1';
1631: x_msg_data := 'SUCCESS';
1632:

Line 1704: x_return_status := FND_API.G_RET_STS_ERROR;

1700: x_fiscal_year IS NULL OR
1701: x_agency_identifier IS NULL OR x_agency_identifier = '' OR
1702: x_serial_number IS NULL OR x_serial_number = '' THEN
1703:
1704: x_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 1715: x_return_status := FND_API.G_RET_STS_ERROR;

1711:
1712: END IF;
1713:
1714: IF 'N' = validate_serial_number(Upper(x_serial_number)) THEN
1715: x_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 1731: x_return_status := FND_API.G_RET_STS_ERROR;

1727: WHERE C_EXT_ATTR40 = x_document_number
1728: AND po_header_id <> x_order_header_id;
1729:
1730: IF l_cnt > 0 THEN
1731: x_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 1740: x_return_status := FND_API.G_RET_STS_SUCCESS;

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';
1742: x_msg_count := '1';
1743: x_msg_data := 'SUCCESS';
1744: END IF;

Line 1880: x_return_status := FND_API.G_RET_STS_SUCCESS;

1876:
1877:
1878: END IF;
1879:
1880: x_return_status := FND_API.G_RET_STS_SUCCESS;
1881: x_errorcode := '0';
1882: x_msg_count := '1';
1883: x_msg_data := 'SUCCESS';
1884:

Line 1991: x_return_status := FND_API.G_RET_STS_SUCCESS;

1987: x_delimiter := '-';
1988: x_document_number := x_base_doc_number ||x_delimiter|| x_serial_number;
1989: END IF;
1990:
1991: x_return_status := FND_API.G_RET_STS_SUCCESS;
1992: x_errorcode := '0';
1993: x_msg_count := '1';
1994: x_msg_data := 'SUCCESS';
1995:

Line 2023: x_return_status := FND_API.G_RET_STS_ERROR;

2019:
2020: IF x_base_doc_number IS NULL OR x_base_doc_number='' OR
2021: x_serial_number IS NULL OR x_serial_number='' THEN
2022:
2023: x_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 2039: x_return_status := FND_API.G_RET_STS_ERROR;

2035: AND draft_id <> p_draft_id
2036: AND po_header_id <> p_po_header_id;
2037:
2038: IF l_cnt > 0 THEN
2039: x_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 2047: x_return_status := FND_API.G_RET_STS_SUCCESS;

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';
2050: x_msg_data := 'SUCCESS';
2051: END IF;

Line 2127: x_return_status := FND_API.G_RET_STS_SUCCESS;

2123: x_delimiter := '-';
2124: x_document_number := x_base_doc_number ||x_delimiter|| x_serial_number;
2125: END IF;
2126:
2127: x_return_status := FND_API.G_RET_STS_SUCCESS;
2128: x_errorcode := '0';
2129: x_msg_count := '1';
2130: x_msg_data := 'SUCCESS';
2131:

Line 2157: x_return_status := FND_API.G_RET_STS_ERROR;

2153:
2154: IF x_base_doc_number IS NULL OR x_base_doc_number='' OR
2155: x_serial_number IS NULL OR x_serial_number='' THEN
2156:
2157: x_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 2172: x_return_status := FND_API.G_RET_STS_ERROR;

2168: WHERE C_EXT_ATTR40 = x_document_number
2169: AND AUCTION_HEADER_ID <> p_auction_header_id;
2170:
2171: IF l_cnt > 0 THEN
2172: x_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 2180: x_return_status := FND_API.G_RET_STS_SUCCESS;

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';
2183: x_msg_data := 'SUCCESS';
2184: END IF;

Line 2245: x_return_status := FND_API.G_RET_STS_SUCCESS;

2241: max_code NUMBER;
2242: l_lookup_code NUMBER;
2243: BEGIN
2244:
2245: x_return_status := FND_API.G_RET_STS_SUCCESS;
2246: x_errorcode := '0';
2247: x_msg_count := '1';
2248: x_msg_data := 'SUCCESS';
2249:

Line 2286: x_return_status := FND_API.G_RET_STS_ERROR;

2282: and enabled_flag = 'Y' and trunc(nvl(inactive_date, sysdate)) >= trunc(sysdate) order by lookup_code)
2283: WHERE ROWNUM=1;
2284: EXCEPTION
2285: WHEN No_Data_Found THEN
2286: x_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 2307: x_return_status := FND_API.G_RET_STS_ERROR;

2303: and enabled_flag = 'Y' and trunc(nvl(inactive_date, sysdate)) >= trunc(sysdate) order by lookup_code)
2304: WHERE ROWNUM=1;
2305: EXCEPTION
2306: WHEN No_Data_Found THEN
2307: x_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 2408: x_return_status := FND_API.G_RET_STS_ERROR;

2404: EXCEPTION
2405: WHEN No_Data_Found THEN
2406: l_serial_num_fetched := FALSE;
2407: WHEN OTHERS THEN
2408: x_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 2495: x_return_status := FND_API.G_RET_STS_ERROR;

2491: EXCEPTION
2492: WHEN No_Data_Found THEN
2493: l_serial_num_fetched := FALSE;
2494: WHEN OTHERS THEN
2495: x_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 2515: x_return_status := FND_API.G_RET_STS_ERROR;

2511: || x_fiscal_year || x_delimiter
2512: || x_instrument_type || x_delimiter
2513: || x_serial_number ;
2514: ELSE
2515: x_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 2590: x_return_status := FND_API.G_RET_STS_SUCCESS;

2586: l_cnt NUMBER;
2587:
2588: BEGIN
2589: --First initialize the out variable to success
2590: x_return_status := FND_API.G_RET_STS_SUCCESS;
2591: x_errorcode := '0';
2592: x_msg_count := '1';
2593: x_msg_data := 'SUCCESS';
2594:

Line 2600: x_return_status := FND_API.G_RET_STS_ERROR;

2596: IF x_dodaac IS NULL OR x_dodaac = '' OR
2597: x_fiscal_year IS NULL OR
2598: x_instrument_type IS NULL OR x_instrument_type = '' THEN
2599:
2600: x_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 2612: x_return_status := FND_API.G_RET_STS_ERROR;

2608: END IF;
2609:
2610: IF x_serial_number IS NOT NULL AND Upper(x_serial_number) <> 'XXXX' THEN
2611: IF 'N' = validate_serial_number(Upper(x_serial_number)) THEN
2612: x_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 2622: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2637: x_return_status := FND_API.G_RET_STS_ERROR;

2633: WHERE C_EXT_ATTR40 = x_document_number
2634: AND auction_header_id <> x_auction_header_id;
2635:
2636: IF l_cnt > 0 THEN
2637: x_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 2693: x_return_status := FND_API.G_RET_STS_SUCCESS;

2689: || x_serial_number ;
2690:
2691: END IF;
2692:
2693: x_return_status := FND_API.G_RET_STS_SUCCESS;
2694: x_errorcode := '0';
2695: x_msg_count := '1';
2696: x_msg_data := 'SUCCESS';
2697:

Line 2790: x_return_status := FND_API.G_RET_STS_SUCCESS;

2786: l_lookup_code NUMBER;
2787:
2788: BEGIN
2789:
2790: x_return_status := FND_API.G_RET_STS_SUCCESS;
2791: x_errorcode := '0';
2792: x_msg_count := '1';
2793: x_msg_data := 'SUCCESS';
2794:

Line 2817: x_return_status := FND_API.G_RET_STS_ERROR;

2813: AND pei.person_id= fu.employee_id
2814: AND fu.user_id = fnd_global.user_id;
2815: EXCEPTION
2816: WHEN No_Data_Found THEN
2817: x_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 2842: x_return_status := FND_API.G_RET_STS_ERROR;

2838: and enabled_flag = 'Y' and trunc(nvl(inactive_date, sysdate)) >= trunc(sysdate) order by lookup_code)
2839: WHERE ROWNUM=1;
2840: EXCEPTION
2841: WHEN No_Data_Found THEN
2842: x_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 2863: x_return_status := FND_API.G_RET_STS_ERROR;

2859: and enabled_flag = 'Y' and trunc(nvl(inactive_date, sysdate)) >= trunc(sysdate) order by lookup_code)
2860: WHERE ROWNUM=1;
2861: EXCEPTION
2862: WHEN No_Data_Found THEN
2863: x_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 2968: x_return_status := FND_API.G_RET_STS_ERROR;

2964: EXCEPTION
2965: WHEN No_Data_Found THEN
2966: l_serial_num_fetched := FALSE;
2967: WHEN OTHERS THEN
2968: x_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 3055: x_return_status := FND_API.G_RET_STS_ERROR;

3051: EXCEPTION
3052: WHEN No_Data_Found THEN
3053: l_serial_num_fetched := FALSE;
3054: WHEN OTHERS THEN
3055: x_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 3075: x_return_status := FND_API.G_RET_STS_ERROR;

3071: || x_fiscal_year || x_delimiter
3072: || x_instrument_type || x_delimiter
3073: || x_serial_number ;
3074: ELSE
3075: x_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 3152: x_return_status := FND_API.G_RET_STS_SUCCESS;

3148: l_cnt NUMBER;
3149:
3150: BEGIN
3151: --Initialize the out variable to success
3152: x_return_status := FND_API.G_RET_STS_SUCCESS;
3153: x_errorcode := '0';
3154: x_msg_count := '1';
3155: x_msg_data := 'SUCCESS';
3156:

Line 3162: x_return_status := FND_API.G_RET_STS_ERROR;

3158: IF x_dodaac IS NULL OR x_dodaac = '' OR
3159: x_fiscal_year IS NULL OR
3160: x_instrument_type IS NULL OR x_instrument_type = '' THEN
3161:
3162: x_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 3176: x_return_status := FND_API.G_RET_STS_ERROR;

3172:
3173: IF x_serial_number IS NOT NULL AND (G_PO_VALIDATION_EVENT_TYPE LIKE 'SAVE' OR Upper(x_serial_number) <> 'XXXX') THEN
3174:
3175: IF 'N' = validate_serial_number(Upper(x_serial_number)) THEN
3176: x_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 3186: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 3201: x_return_status := FND_API.G_RET_STS_ERROR;

3197: WHERE C_EXT_ATTR40 = x_document_number
3198: AND po_header_id <> x_order_header_id;
3199:
3200: IF l_cnt > 0 THEN
3201: x_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 3257: x_return_status := FND_API.G_RET_STS_SUCCESS;

3253: || x_serial_number ;
3254:
3255: END IF;
3256:
3257: x_return_status := FND_API.G_RET_STS_SUCCESS;
3258: x_errorcode := '0';
3259: x_msg_count := '1';
3260: x_msg_data := 'SUCCESS';
3261:

Line 3313: x_return_status := FND_API.G_RET_STS_SUCCESS;

3309: )
3310: IS
3311: BEGIN
3312:
3313: x_return_status := FND_API.G_RET_STS_SUCCESS;
3314: x_errorcode := '0';
3315: x_msg_count := '1';
3316: x_msg_data := 'SUCCESS';
3317:

Line 3377: x_return_status := FND_API.G_RET_STS_SUCCESS;

3373: l_lookup_code NUMBER;
3374:
3375: BEGIN
3376: --First initialize the out variable to success
3377: x_return_status := FND_API.G_RET_STS_SUCCESS;
3378: x_errorcode := '0';
3379: x_msg_count := '1';
3380: x_msg_data := 'SUCCESS';
3381:

Line 3397: x_return_status := FND_API.G_RET_STS_ERROR;

3393: and enabled_flag = 'Y' and trunc(nvl(inactive_date, sysdate)) >= trunc(sysdate) order by lookup_code)
3394: WHERE ROWNUM=1;
3395: EXCEPTION
3396: WHEN No_Data_Found THEN
3397: x_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 3488: x_return_status := FND_API.G_RET_STS_ERROR;

3484: EXCEPTION
3485: WHEN No_Data_Found THEN
3486: l_serial_num_fetched := FALSE;
3487: WHEN OTHERS THEN
3488: x_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 3572: x_return_status := FND_API.G_RET_STS_ERROR;

3568: EXCEPTION
3569: WHEN No_Data_Found THEN
3570: l_serial_num_fetched := FALSE;
3571: WHEN OTHERS THEN
3572: x_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 3589: x_return_status := FND_API.G_RET_STS_ERROR;

3585:
3586: IF l_serial_num_fetched = TRUE THEN
3587: x_document_number := x_source_doc_number || x_delimiter || x_serial_number;
3588: ELSE
3589: x_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 3624: x_return_status := FND_API.G_RET_STS_SUCCESS;

3620: l_cnt NUMBER;
3621:
3622: BEGIN
3623: --First initialize the out variable to success
3624: x_return_status := FND_API.G_RET_STS_SUCCESS;
3625: x_errorcode := '0';
3626: x_msg_count := '1';
3627: x_msg_data := 'SUCCESS';
3628:

Line 3632: x_return_status := FND_API.G_RET_STS_ERROR;

3628:
3629: --If any of the value is null then we need to throw back the error
3630: IF x_source_doc_number IS NULL OR x_source_doc_number = '' THEN
3631:
3632: x_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 3645: x_return_status := FND_API.G_RET_STS_ERROR;

3641:
3642:
3643: IF x_serial_number IS NOT NULL AND (G_PO_VALIDATION_EVENT_TYPE LIKE 'SAVE' OR Upper(x_serial_number) <> 'XXXX') THEN
3644: IF 'N' = validate_serial_number(Upper(x_serial_number)) THEN
3645: x_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 3660: x_return_status := FND_API.G_RET_STS_ERROR;

3656: WHERE C_EXT_ATTR40 = x_document_number
3657: AND po_header_id <> x_order_header_id;
3658:
3659: IF l_cnt > 0 THEN
3660: x_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 3742: x_return_status := FND_API.G_RET_STS_SUCCESS;

3738: x_document_number := x_source_doc_number || x_delimiter || x_serial_number;
3739:
3740: END IF;
3741:
3742: x_return_status := FND_API.G_RET_STS_SUCCESS;
3743: x_errorcode := '0';
3744: x_msg_count := '1';
3745: x_msg_data := 'SUCCESS';
3746:

Line 3793: x_return_status := FND_API.G_RET_STS_SUCCESS;

3789: )
3790: IS
3791: BEGIN
3792:
3793: x_return_status := FND_API.G_RET_STS_SUCCESS;
3794: x_errorcode := '0';
3795: x_msg_count := '1';
3796: x_msg_data := 'SUCCESS';
3797:

Line 3840: x_return_status := FND_API.G_RET_STS_SUCCESS;

3836: AND puatu.attribute2='N';
3837:
3838: BEGIN
3839: --First initialize the out variable to success
3840: x_return_status := FND_API.G_RET_STS_SUCCESS;
3841: x_errorcode := '0';
3842: x_msg_count := '1';
3843: x_msg_data := 'SUCCESS';
3844:

Line 3929: x_return_status := FND_API.G_RET_STS_SUCCESS;

3925: l_cnt NUMBER;
3926:
3927: BEGIN
3928: --First initialize the out variable to success
3929: x_return_status := FND_API.G_RET_STS_SUCCESS;
3930: x_errorcode := '0';
3931: x_msg_count := '1';
3932: x_msg_data := 'SUCCESS';
3933:

Line 3938: x_return_status := FND_API.G_RET_STS_ERROR;

3934: --If any of the value is null then we need to throw back the error
3935: IF x_source_doc_number IS NULL OR x_source_doc_number = '' OR
3936: x_call_order_number IS NULL OR x_call_order_number = '' THEN
3937:
3938: x_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 3951: x_return_status := FND_API.G_RET_STS_ERROR;

3947:
3948: IF x_serial_number IS NOT NULL AND (G_PO_VALIDATION_EVENT_TYPE LIKE 'SAVE' OR Upper(x_serial_number) <> 'XX') THEN
3949:
3950: IF 'N' = validate_serial_number_2digit(Upper(x_serial_number)) THEN
3951: x_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 3966: x_return_status := FND_API.G_RET_STS_ERROR;

3962: WHERE C_EXT_ATTR40 = x_document_number
3963: AND po_header_id <> x_order_header_id;
3964:
3965: IF l_cnt > 0 THEN
3966: x_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 4060: x_return_status := FND_API.G_RET_STS_SUCCESS;

4056: )
4057: IS
4058: BEGIN
4059:
4060: x_return_status := FND_API.G_RET_STS_SUCCESS;
4061: x_errorcode := '0';
4062: x_msg_count := '1';
4063: x_msg_data := 'SUCCESS';
4064:

Line 4111: x_return_status := FND_API.G_RET_STS_SUCCESS;

4107: AND puatu.attribute2='NA';
4108:
4109: BEGIN
4110: --First initialize the out variable to success
4111: x_return_status := FND_API.G_RET_STS_SUCCESS;
4112: x_errorcode := '0';
4113: x_msg_count := '1';
4114: x_msg_data := 'SUCCESS';
4115:

Line 4191: x_return_status := FND_API.G_RET_STS_SUCCESS;

4187: l_cnt NUMBER;
4188:
4189: BEGIN
4190: --First initialize the out variable to success
4191: x_return_status := FND_API.G_RET_STS_SUCCESS;
4192: x_errorcode := '0';
4193: x_msg_count := '1';
4194: x_msg_data := 'SUCCESS';
4195:

Line 4200: x_return_status := FND_API.G_RET_STS_ERROR;

4196: --If any of the value is null then we need to throw back the error
4197: IF x_base_doc_number IS NULL OR x_base_doc_number='' OR
4198: x_control_char IS NULL OR x_control_char='' THEN
4199:
4200: x_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 4216: x_return_status := FND_API.G_RET_STS_ERROR;

4212: WHERE C_EXT_ATTR40 = x_document_number
4213: AND AUCTION_HEADER_ID <> p_auction_header_id;
4214:
4215: IF l_cnt > 0 THEN
4216: x_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 4307: x_return_status := FND_API.G_RET_STS_SUCCESS;

4303: l_lookup_code NUMBER;
4304: BEGIN
4305:
4306: --First initialize the out variable to success
4307: x_return_status := FND_API.G_RET_STS_SUCCESS;
4308: x_errorcode := '0';
4309: x_msg_count := '1';
4310: x_msg_data := 'SUCCESS';
4311:

Line 4330: x_return_status := FND_API.G_RET_STS_ERROR;

4326: and enabled_flag = 'Y' and trunc(nvl(inactive_date, sysdate)) >= trunc(sysdate) order by lookup_code)
4327: WHERE ROWNUM=1;
4328: EXCEPTION
4329: WHEN No_Data_Found THEN
4330: x_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 4443: x_return_status := FND_API.G_RET_STS_SUCCESS;

4439:
4440: BEGIN
4441:
4442: --First initialize the out variable to success
4443: x_return_status := FND_API.G_RET_STS_SUCCESS;
4444: x_errorcode := '0';
4445: x_msg_count := '1';
4446: x_msg_data := 'SUCCESS';
4447:

Line 4451: x_return_status := FND_API.G_RET_STS_ERROR;

4447:
4448: IF x_base_doc_number IS NULL OR x_base_doc_number='' OR
4449: x_control_char IS NULL OR x_control_char='' THEN
4450:
4451: x_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 4469: x_return_status := FND_API.G_RET_STS_ERROR;

4465: AND draft_id <> p_draft_id
4466: AND po_header_id <> p_po_header_id;
4467:
4468: IF l_cnt > 0 THEN
4469: x_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 4509: x_return_status := FND_API.G_RET_STS_SUCCESS;

4505: x_document_number := x_base_doc_number ||x_delimiter|| x_control_char||x_serial_number;
4506:
4507: END IF;
4508:
4509: x_return_status := FND_API.G_RET_STS_SUCCESS;
4510: x_errorcode := '0';
4511: x_msg_count := '1';
4512: x_msg_data := 'SUCCESS';
4513:

Line 4575: x_return_status := FND_API.G_RET_STS_SUCCESS;

4571: )
4572: IS
4573: BEGIN
4574: --First initialize the out variable to success
4575: x_return_status := FND_API.G_RET_STS_SUCCESS;
4576: x_errorcode := '0';
4577: x_msg_count := '1';
4578: x_msg_data := 'SUCCESS';
4579:

Line 4602: x_return_status := FND_API.G_RET_STS_SUCCESS;

4598: )
4599: IS
4600: BEGIN
4601:
4602: x_return_status := FND_API.G_RET_STS_SUCCESS;
4603: x_errorcode := '0';
4604: x_msg_count := '1';
4605: x_msg_data := 'SUCCESS';
4606:

Line 4649: x_return_status := FND_API.G_RET_STS_SUCCESS;

4645:
4646: BEGIN
4647:
4648: --First initialize the out variable to success
4649: x_return_status := FND_API.G_RET_STS_SUCCESS;
4650: x_errorcode := '0';
4651: x_msg_count := '1';
4652: x_msg_data := 'SUCCESS';
4653:

Line 4674: x_return_status := FND_API.G_RET_STS_ERROR;

4670: and enabled_flag = 'Y' and trunc(nvl(inactive_date, sysdate)) >= trunc(sysdate) order by lookup_code)
4671: WHERE ROWNUM=1;
4672: EXCEPTION
4673: WHEN No_Data_Found THEN
4674: x_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 4693: x_return_status := FND_API.G_RET_STS_ERROR;

4689: and enabled_flag = 'Y' and trunc(nvl(inactive_date, sysdate)) >= trunc(sysdate) order by lookup_code)
4690: WHERE ROWNUM=1;
4691: EXCEPTION
4692: WHEN No_Data_Found THEN
4693: x_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 4768: x_return_status := FND_API.G_RET_STS_SUCCESS;

4764: l_cnt NUMBER;
4765:
4766: BEGIN
4767: --First initialize the out variable to success
4768: x_return_status := FND_API.G_RET_STS_SUCCESS;
4769: x_errorcode := '0';
4770: x_msg_count := '1';
4771: x_msg_data := 'SUCCESS';
4772:

Line 4776: x_return_status := FND_API.G_RET_STS_ERROR;

4772:
4773: IF x_base_doc_number IS NULL OR x_base_doc_number='' OR
4774: x_control_char IS NULL OR x_control_char='' THEN
4775:
4776: x_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 4793: x_return_status := FND_API.G_RET_STS_ERROR;

4789: AND draft_id <> p_draft_id
4790: AND po_header_id <> p_po_header_id;
4791:
4792: IF l_cnt > 0 THEN
4793: x_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 4886: x_return_status := FND_API.G_RET_STS_SUCCESS;

4882: AND puatu.attribute2='NA';
4883:
4884: BEGIN
4885: --First initialize the out variable to success
4886: x_return_status := FND_API.G_RET_STS_SUCCESS;
4887: x_errorcode := '0';
4888: x_msg_count := '1';
4889: x_msg_data := 'SUCCESS';
4890:

Line 4973: x_return_status := FND_API.G_RET_STS_SUCCESS;

4969: )
4970: IS
4971: BEGIN
4972:
4973: x_return_status := FND_API.G_RET_STS_SUCCESS;
4974: x_errorcode := '0';
4975: x_msg_count := '1';
4976: x_msg_data := 'SUCCESS';
4977:

Line 5093: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_return_status', FND_API.G_RET_STS_SUCCESS, l_external_attr_value_pairs);

5089: ,x_msg_count => x_msg_count
5090: ,x_msg_data => x_msg_data
5091: );
5092:
5093: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_return_status', FND_API.G_RET_STS_SUCCESS, l_external_attr_value_pairs);
5094: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_errorcode', '0', l_external_attr_value_pairs);
5095: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_msg_count', '0', l_external_attr_value_pairs);
5096: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_msg_data', 'SUCCESS', l_external_attr_value_pairs);
5097:

Line 5098: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

5094: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_errorcode', '0', l_external_attr_value_pairs);
5095: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_msg_count', '0', l_external_attr_value_pairs);
5096: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_msg_data', 'SUCCESS', l_external_attr_value_pairs);
5097:
5098: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
5099: PO_UDA_IMPORT_PKG.EXECUTE_IMPORT_UDA_FUNCTION
5100: (
5101: p_template_id => p_uda_template_id
5102: ,p_event => 'XPA'

Line 5123: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

5119: ,p_uda_template_id || ''
5120: )
5121: );
5122:
5123: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
5124: EGO_USER_ATTRS_DATA_PVT.Process_User_Attrs_Data
5125: (
5126: p_api_version => 1.0
5127: ,p_object_name => l_src_object_name

Line 5367: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_return_status', FND_API.G_RET_STS_SUCCESS, l_external_attr_value_pairs);

5363: );
5364:
5365:
5366: l_external_attr_value_pairs :=NULL;
5367: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_return_status', FND_API.G_RET_STS_SUCCESS, l_external_attr_value_pairs);
5368: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_errorcode', '0', l_external_attr_value_pairs);
5369: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_msg_count', '0', l_external_attr_value_pairs);
5370: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_msg_data', 'SUCCESS', l_external_attr_value_pairs);
5371:

Line 5372: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

5368: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_errorcode', '0', l_external_attr_value_pairs);
5369: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_msg_count', '0', l_external_attr_value_pairs);
5370: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_msg_data', 'SUCCESS', l_external_attr_value_pairs);
5371:
5372: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
5373: PO_UDA_IMPORT_PKG.EXECUTE_IMPORT_UDA_FUNCTION
5374: (
5375: p_template_id => l_template_id
5376: ,p_event => 'XDA'

Line 5388: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

5384: ,x_msg_data => l_msg_data
5385: );
5386: END IF;
5387:
5388: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
5389: PO_UDA_DEFAULTING_PKG.GET_EXT_ATTR_NAME_VALUE_PAIR('DELIMITER', l_external_attr_value_pairs, l_ext_name_val_obj);
5390: l_delimiter := l_ext_name_val_obj.VALUE ;
5391: --ELSE
5392: --l_delimiter := '-';

Line 5498: x_return_status := FND_API.G_RET_STS_SUCCESS;

5494: PO_LOG.proc_begin(d_module, 'x_delimiter', x_delimiter);
5495: PO_LOG.proc_begin(d_module, 'x_document_number', x_document_number);
5496: END IF;
5497: --First initialize the out variable to success
5498: x_return_status := FND_API.G_RET_STS_SUCCESS;
5499: x_errorcode := '0';
5500: x_msg_count := '1';
5501: x_msg_data := 'SUCCESS';
5502: